4. Translate the Enhanced Entity-Relationship Diagram in Table 2 above into a Re

Question

4. Translate the Enhanced Entity-Relationship Diagram in Table 2 above

into a Relational Model using the translation explained in Lecture 7.

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

Receives_by_phone Restaurant hone_line phone num Contains dateTi me billingNo total Order Originates from Table optional.orh number PhoneOrder TableOrder street wai ter deliveryAddress postcode city

Explanation / Answer

Hi,

Below are the relational tables-

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));

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---

---

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