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 |
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 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.