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

Table name: Restaurant

Primary key: r_id

Foreign key: r_name

(1:M)

Table name: Products

Primary key: p_id

Foreign key: p_price

(1:M)

Table name: Orders

Primary key: o_id

Foreign key: none

References

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

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.