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

 The ERD below indicates a Builder can use a set of

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!