Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The ERD below indicates a Builder can use a set of Plans a minimum of 0 times and a maximum of many times. It
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 BuilderID column. The primary key of the Plan table is the combination of DrawingNumber and Revision Number 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 BuilderID LicenseNumber PhoneNumber O DateCreated DrawingNumber Phone BuilderID DrawingImage LicenseNumber Revision Number Used By Uses Plans DrawingNumber Revision Number DateCreated DrawingImage
Step by Step Solution
★★★★★
3.32 Rating (146 Votes )
There are 3 Steps involved in it
Step: 1
The detailed answer for the above question is provided below The image provided shows an Entity Rela...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started