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 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
Get step-by-step solutions from verified subject matter experts
