Transform the attached ERD into relation. Solid underline all PKs, Dash underlin

Question

Transform the attached ERD into relation. Solid underline all PKs, Dash underline all FKs and draw arrowhead lines from FKs to PKs. Use DIA or WORD to answer the question.(Don't forget to connect the relations with arrows)

CUSTOMER BILLING Customer ID Service Date Name Bill Due Date Address Amount Due Phone Number Purch Date Cust Contact Purchases OFFERING Offering ID Description Offering Type offering Type SERVICE PRODUCT Product Name Unit Resp Name Service Conditions Std Price Service Type First Release Date Service Type MAINTENANCE REPAIR Hourly Rate Cos Is

Explanation / Answer

CREATE TABLE CUSTOMER(

                CUSTOMER_ID NUMBER(18),

NAME VARCHAR2(100),

ADDRESS VARCHAR2(100),

PHONE_NUMBER NUMBER(10),

                PRIMARY KEY (CUSTOMER_ID)

)

CREATE TABLE BILLING(

                SERVICE_DATE TIMESTAMP,

BIL_DUE_DATE TIMESTAMP,

AMOUNT_DATE TIMESTAMP

)

CREATE TABLE PURCHASING(

                PURCHASE_DATE TIMESTAMP,

CUTOMER_CONTACT NUMBER(10)

)

CREATE TABLE OFFERING(

                OFFERING_ID NUMBER(18),

DESCRIPTION VARCHAR2(500),
OFFERING_TYPE VARCHAR2(100)

)

CREATE TABLE PRODUCT(

                PRODUCT_NAME VARCHAR2(100),

STANDARD_PRICE NMBER(18,2),

FIRST_RELEASE_DATE TIMESTAMP

)

CEATE TABLE SERVICE(

                UNIT_NAME VARCHAR2(100),

SERVICE_CONDITION VARCHAR2(50),

SERVICE_TYPE VARCHAR2(50)

)

CREATE TABLE REPAIR(

                REPAIR_COST NUMBER(18,2),

                PRODUCT_NAME VARCHAR2(100),

FOREIGN KEY (PRODUCT_NAME) REFERENCES PRODUCT (PRODUCT_NAME)

)

CREATE TABLE MAINTENANCE(

                HOURLY_RATE NUMBER(18,2),

                SERVICE_TYPE VARCHAR2(50),

FOREIGN KEY (SERVICE_TYPE) REFERENCES SERVICE (SERVICE_TYPE)

)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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