Some help with steps .. The helpful answer deserve the rate Map the ER-Diagram o

Question

Some help with steps .. The helpful answer deserve the rate Map the ER-Diagram of the first assignment into a relational model. Map each entity into a relation (base table) using appropriate attributes as primary keys and foreign keys. Map each of the relationships of the ERD into either using a common attribute as FK-PK or a separate relation based on the type of relationship. Entities: customer, vendor, product inventory Relationships: orders (between customer and products), supplies (between vendor products) Present detailed schema identifying all the attributes and primary keys and foreign keys.

Explanation / Answer

customer is an entity and attributes are 1.cust_name,cust_ph,cust_adress.

order is an entity and attributes are 1.order_no,date, amount.

supplier is an entity attributers are supp_name,supp_adress,contac_no,supp_id.

primary key: cust_ph,order_no,supp_id

foreign key is:cust_ph,supp_id

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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