(1) Translate the Enhanced Entity-Relationship Diagram in the Table above into a

Question

(1) Translate the Enhanced Entity-Relationship Diagram in the Table above into a Relational Model.  

(2) Present the final model (no need for explanations or intermediate steps) as a Relational Database Schema in textual form and not as a diagram. Primary and foreign keys must be explicitly declared.

Receives by_phone Restaurant name phone_line phone num Contains dateTime billingNo total Order Originates_fromTable optional,or) number PhoneOrde TableOrder street waiter deliveryAddress postcode city

Explanation / Answer

RELATIONAL MODEL AND DATA BASE SCHEMA

CREATE TABLE ORDER(BILLING_NUMBER VARCHAR(20) PRIMARY KEY, DATETIME TIMESTAMP,TOTAL NUMBER(10,2), ORDER_TYPE_ID VARCHAR(10));

CREATE TABLE PHONEORDER(PHONEORDERID VARCHAR(10) PRIMARY KEY, BILLING_NUMBER VARCHAR(20) REFERENCES ORDER(BILLING_NUMBER), STREET VARCHAR(10), POSTCODE NUMBER(10), CITY VARCHAR(10));

CREATE TABLE TABLEORDER(TABLEORDERID VARCHAR(10) PRIMARY KEY, BILLING_NUMBER VARCHAR(20) REFERENCES ORDER(BILLING_NUMBER), WAITER VARCHAR(10));

CREATE TABLE RESTAURANT(NAME VARCHAR(10) PRIMARY KEY, PHONENUM NUMBER(10));

CREATE TABLE TABLE1( TABLE_NUMBER NUMBER(10),RESTAURANT_NAME VARCHAR(10) REFERENCES RESTAURANT(NAME));

AS YOU ASKED NO NEED FOR EXPLANATION

IF ANY QUERIES REGARDING ABOVE PLEASE GET BACK TO ME

THANK YOU

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.