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


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.