Transform the attached ERD into relation. Use DIA or WORD to answer the question

Question

Transform the attached ERD into relation. Use DIA or WORD to answer the question. Solid underline all PKs, Dash underline all FKs and draw arrowhead lines from FKs to PKs.

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

CUSTOMER(Customer ID, Name, Address, Phone Number) BILLING(Service Date, Bill Due Date, Amount Due) Purch Date Cush Contact OFFERING(Offering ID, Description, Offering Type) PRODUCT(Product Name, Std Price, First Release Date) SERVICE( Unit Resp Name, Service Conditions, Service Type) REPAIR(Cost) MAINTENANCE(Hourly Rate)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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