The ERD below indicates a Builder can use a set of Plans a minimum of 0 times an

Question

The ERD below indicates a Builder can use a set of Plans a minimum of 0 times and a maximum of many times. It also shows a set of Plans can be used by a minimum of 0 Builders and a maximum of many Builders. The primary key of the Builder table is the BuilderlD column. The primary key of the Plan table is the combination of DrawingNumber and RevisionNumber columns. The ERD shows a binary many-to-many relationship. A many-to-many relationship can't be implemented without using a third table (not shown). What is the minimum primary key this third table must have. Select all the columns that apply Builder Plans Used By BuilderlD LicenseNumber PhoneNumber DrawingNumber RevisionNumber DateCreated Drawinglmage Uses O DrawingNumber Drawinglmage O LicenseNumber BuilderlD DateCreated Phone RevisionNumber

Explanation / Answer

So, the primary key should be the combination of primary keys of both table

SO, ans: BuilderID, DrawingNumber, RevisionNumber

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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