Answer the following questions using the attached ER diagram, make no assumption

Question

Answer the following questions using the attached ER diagram, make no assumptions about business rules outside of what is shown in the diagram. I.E. drivers are members of leagues, drivers have results for races, and leagues hold races, but the diagram does not state whether only league members can participate in races for that league.

Must every race offer prizes?

Must every driver be part of a league?

Must ever car have results for at least one race?

Can two cars have the same make, model and year?

Must every race be held by a league?

Explanation / Answer

a. True, every race must offer prize as it is one to many relation between race and prize.

b. True, every driver can be a part of many leagues.

c. True. as it is many to one

d. False as these are the primary key so can not be repeated

e. True, as every race is a part of a series which is held by league

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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