CPT310 Database Systems And Management

CPT 310: Database Systems & Management

The Online Food Ordering Database – Task 2

Database systems not only provide businesses a means to store their data, but also an efficient way to communicate, update, and sort information.  Which in other words means database systems empower companies to better monitor activities and trends, as well as share more information to consumers.  An example of this would be a database that stored items a company carried and the inventory amount for each item, which could be shared with online consumers.  Databases can be built with the use of a database management system (DBMS).  There are many types of DBMSs; in order to determine the best DBMS for a database many considerations should be reviewed.  This paper will explore what DBMS system would be best for an online food company’s database system.

Create a complete Chen ER diagram design for the entities and attributes you have identified in Week 1. Include a screen shot of your diagram in your paper.

Create tables in Word that corresponds with the entities and attributes in your ER diagram. Your tables should include fields and data types for attributes, as well as the relationships between entities.

Describe the advantages and concepts of your Chen ER diagram and how the diagram will help shape the overall relationship between tables. Your description should be a minimum of 300 words.

Chen ER Diagram Design

Relational Tables

Database name: Online_Food_Ordering_CPT310

Table name: Customer

Primary key: c_id

Foreign key: none

c_id

c_username

c_firstName

c_lastName

c_password

c_email

c_phone

c_address

c_paymentType

Datatype

1

JSmith

Jane

Smith

123Smith

Smith@none.com

405-999-9999

1 Smith Rd

Visa

text

Table name: Restaurant

Primary key: r_id

Foreign key: r_name

r_id

r_name

r_phone

r_address

r_email

r_hours

r_rating

Datatype

1

Rich’s Donuts

405-555-5555

1 Donut Ln

Rds@none.com

6am – 3pm

3.8

text

(1:M)

Table name: Products

Primary key: p_id

Foreign key: p_price

p_id

r_name

p_availability

p_description

p_lastModified

p_price

Datatype

1

Rich’s Donuts

22

Sprinkled Donuts

6/02/2020

$1.20

text

(1:M)

Table name: Orders

Primary key: o_id

Foreign key: none

o_id

o_date

o_orderNum

o_orderDetail

o_quantity

p_price

o_discount

o_total

Datatype

1

6/17/2020

1

1 Sprinkled Donut

1

$1.20

0

$1.20

text

References

Coronel, C., & Morris, S. (2019). Database systems: Design, implementation, and management (13th ed.). Retrieved from https://www.vitalsource.com

hihi

Download Sample Now

Earn back money you have spent on downloaded sample



Upload Document Document Unser Evaluion Get Money Into Your Wallet



Cite This work.

To export a reference to this article please select a referencing stye below.

Assignment Hippo (2021) . Retrive from http://assignmenthippo.com/sample-assignment/cpt310-database-systems-and-management

"." Assignment Hippo ,2021, http://assignmenthippo.com/sample-assignment/cpt310-database-systems-and-management

Assignment Hippo (2021) . Available from: http://assignmenthippo.com/sample-assignment/cpt310-database-systems-and-management

[Accessed 17/10/2021].

Assignment Hippo . ''(Assignment Hippo,2021) http://assignmenthippo.com/sample-assignment/cpt310-database-systems-and-management accessed 17/10/2021.


Want latest solution of this assignment

Want to order fresh copy of the Sample Template Answers? online or do you need the old solutions for Sample Template, contact our customer support or talk to us to get the answers of it.


Submit Your Assignment Here

AssignmentHippo Features

On Time Delivery

Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.

Plagiarism Free Work

Get reliable and unique assignments by using our 100% plagiarism-free.

24 X 7 Live Help

Get connected 24*7 with our Live Chat support executives to receive instant solutions for your assignment.

Services For All Subjects

Get Help with all the subjects like: Programming, Accounting, Finance, Engineering, Law and Marketing.

Best Price Guarantee

Get premium service at a pocket-friendly rate at AssignmentHippo

FREE RESOURCES

  • Assignment Writing Guide
  • Essay Writing Guide
  • Dissertation Writing Guide
  • Research Paper Writing Guide

FREE SAMPLE FILE

  • Accounts
  • Computer Science
  • Economics
  • Engineering

Client Review

I was struggling so hard to complete my marketing assignment on brand development when I decided to finally reach to the experts of this portal. They certainly deliver perfect consistency and the desired format. The content prepared by the experts of this platform was simply amazing. I definitely owe my grades to them.

Tap to Chat
Get instant assignment help