Translation from ERD To Relation Schema for the Pizza Delivery Database

Customer (name, phone, email, address)

OrderStaff (empID, name)

DeliveryPerson (phone, name, model)

Orders (empID_FK, email_FK, phone_FK, orderDate, orderType, order num )

Pizza item Num, size, price)

Orderltem (order_Num_FK, item_Num_FK, auto Gen)

Topping (item Num, name, price)

hasTopping (item _Num_FK, auto_Gen_FK)

 

Create the Relational Schema and Metadata on excel!

 

Transcribed Image Text:

name Craig Nelson phone email Customer address empid_FK email_FK date order num type phone_FK empid name Takes Places M Order Staff name phone model Delivery Person Order M Delivers contains order_num_FK auto_gen item_num M item_num_FK Order Item 000 price Pizza size is a item_num M auto_gen_FK item_num_FK name price Topping Has name Craig Nelson phone email Customer address empid_FK email_FK date order num type phone_FK empid name Takes Places M Order Staff name phone model Delivery Person Order M Delivers contains order_num_FK auto_gen item_num M item_num_FK Order Item 000 price Pizza size is a item_num M auto_gen_FK item_num_FK name price Topping Has