. Consider the following Entity Relationship Diagram and answer the questheas be

Question

. Consider the following Entity Relationship Diagram and answer the questheas below cus coot INV DATE NITIAL CUS AREACODE LINE PRICE CUS BALANCE s found in V NAME AREACODE P PRICE CODE a) Write the business rules captured in the above ERD oy on e and ony one on suly invoice Zero O tach Produa ovncong on b) Identify the strong and the weak tables as well as the identifying and non-idemifying relationships. Strong Weak Relationship Identifying CUSTOMER INVOICE LINE | CUSTOMER-INVOICE ! ', TNVOICE-LINE Inger LINE-PRODUCT I-???'?PRODUCT-VENDOR | PRODUCT VENDOR

Explanation / Answer

1. Business rules

2. Strong and weak tables.

A table is said to be strong if it is having a primary key by its own and if the table dependens on other table's key then it is known as weak table

Identifying and non-identifying relationships

If the primary key of the parent entity is included as the primary key of child entity then it is known as Identifying relationships and if the primary key of the parent entity is not as a part of the child entity's primary key then it is a non-identifying relationship.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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