Review the following structural business rules regarding a car repair shop to complete this section:

Every car has an owner driver.

Owners own one or more cars.

An owner may schedule multiple appointments with multiple car repair shops

Each appointment is scheduled for one car.

Each appointment results in a bill for the cars owner.

Questions

The business rules above specify all relevant entities needed for this exercise. List the names of all entities provided in the business rules above.

The business rules above also specify all of the relevant relationships between entities. Identify each relationship along with the entities it relates.

Some rules are not well formed in that they either do not describe both directions of the relationship, or they combine multiple relationships or entities into one statement. In practice, this can result in missing or ambiguous optionality and plurality constraints. Correct these rules by modifying them or adding new statements as necessary. You may make reasonable assumptions when doing so. Please state any assumptions that you make.

Combine the original list of rules with your modifications to create a complete list of business rules. This combined list must not add additional entities. It will specify and clarify the optionality and plurality constraints for both sides of all relationships.

Create a conceptual entity-relationship diagram using Crows Foot notation that reflects your list of business rules. You can use any tool you wish, but I would suggest a free account at http://www.lucidchart.com