Question: Part D. E-R Mapping (28 points, 7 points each). Below is an E-R diagram that conceptualizes the business requirements for a cab company. Consider this

 Part D. E-R Mapping (28 points, 7 points each). Below is
an E-R diagram that conceptualizes the business requirements for a cab company.
Consider this diagram for questions 1821. Select all answers that apply to

Part D. E-R Mapping (28 points, 7 points each). Below is an E-R diagram that conceptualizes the business requirements for a cab company. Consider this diagram for questions 1821. Select all answers that apply to each multiple-choice question. Some questions may have multiple answers. Consider the service relationship between CAB and MECHANIC. Which of the following is true? a. CarID can be stored in MECHANIC as a foreign key. NULLs are not possible. b. Phone can be stored in CAB as a foreign key. NULLs are possible. c. A new relation must be created to represent this relationship. d. CarID can be stored in MECHANIC as a foreign key. NULLs are possible. e. Phone can be stored in CAB as a foreign key. NULLs are not possible. Consider the parks relationship between CAB and GARAGE. Which of the following is true? a. A new relation must be created to represent this relationship. b. Address can be stored in CAB as a foreign key. NULLs are possible. c. CarID can be stored in GARAGE as a foreign key. NULLs are possible. d. Address can be stored in CAB as a foreign key. NULLs are not possible. e. CarID can be stored in GARAGE as a foreign key. NULLs are not possible

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!