Online Food Ordering Database – Task 1, Thesis of Community Corrections

Download Online Food Ordering Database – Task 1 and more Thesis Community Corrections in PDF only on Docsity!

Running head: ONLINE FOOD ORDERING DATABASE – TASK 1 1

Online Food Ordering Database – Task 1

CPT 310 Database Systems & Management

Restaurant - This schema will provide details about the restaurant including the

name,id,address,rating, phone number, business hours,and email.

R_id R_name R_phone R_address R_email R_hours R_rating 1 Hurtz Pizza 423-555-5440 1 Pizza Street [email protected] 10am – 8pm 4.

Customer - This schema will save customer details.This data will be used in conjunction with the

data from the order so that the customer’s order can be tracked.

Menu Details - This schema will save the menu details including price, description, and the last

time the menu item was changed.

P_id P_name P_available P_description P_lastedit P_price 1 Cheese Pizza 5 Pizza with marinara and shredded mozzarella October 20, 2020 $10.

Order Details - This schema will provide data related to the order including order id,order date,

order details (what was ordered),total price, and any discounts that are applied.

O_id O_date O_number O_detail O_quantity O_price O_discount 1 October 28, 2020 1 Cheese Pizza

C_id C_username C_firstname C_lastname C_password C_email C_phone C_address C_payment 1 Hodginda Daniel Hodgin Hodg123 [email protected] 423-555- 4550

Roadblock Ln. Wichita, KS 67226 Mastercard

References

Branson, T. (2016, November 16). 8 major advantages of using MySQL. Retrieved October 31,

2020, from https://www.datamation.com/storage/8-major-advantages-of-using-

mysql.html

Coronel, C., & Morris, S. (2019). Database systems: Design, implementation, and management

(13th ed.). Boston, MA: Cengage.

Gravelle, R. (2018, August 09). The Best (and Worst) Cloud Services for MySQL. Retrieved

October 30, 2020, from https://www.databasejournal.com/features/mysql/slideshows/the-

best-and-worst-cloud-services-for-mysql.html