CS669 Assignment2
The two parts in this assignment will contribute equally to your grade and will be evaluated separately.
Part 1: Authors and Books
Review the following business rules regarding authors and books to complete this part.
An author writes one or more books.
A book is written by one or more authors.
A subject applies to at least 20 books.
A book is published in a year.
The business rules above specify all of the relevant entities; however, some business rules do not specify both sides of the relationship. You will be completing this list of business rules.
1. To get started, list the names of all entities provided in the business rules above.
2. Identify the entities that are related to each other.
3. Identify the optionality and plurality constraints on both sides of each relationship, where possible. Indicate where the provided business rules do not provide the optionality and plurality constraints.
4. Create a complete list of business rules. The new list should not add additional entities, but should specify the optionality and plurality constraints for both sides of all relationships. Make reasonable assumptions to create the list and state your assumptions. There is no provably “right” list of assumptions.
5. Create a conceptual entity-relationship diagram using Crow’s Foot notation that reflects your list of business rules. You may use Microsoft Visio Pro or another similarly capable drawing application to produce your ERD. Note that cardinalities are not required in the diagram, though relationship connectivities are required.
Part 2: Veterinary Clinic
In this part, you will be repeating the same steps in Part 1 for a more complex veterinary clinic scenario. Review the following business rules then complete the steps indicated below.
Every pet has an owner.
Owners have one or more pets.
A pet may have multiple appointments with multiple veterinarians in the clinic.
One veterinarian attends each appointment.
Each appointment results in a bill for the
Part 1: Authors and Books
Review the following business rules regarding authors and books to complete this part.
An author writes one or more books.
A book is written by one or more authors.
A subject applies to at least 20 books.
A book is published in a year.
The business rules above specify all of the relevant entities; however, some business rules do not specify both sides of the relationship. You will be completing this list of business rules.
1. To get started, list the names of all entities provided in the business rules above.
2. Identify the entities that are related to each other.
3. Identify the optionality and plurality constraints on both sides of each relationship, where possible. Indicate where the provided business rules do not provide the optionality and plurality constraints.
4. Create a complete list of business rules. The new list should not add additional entities, but should specify the optionality and plurality constraints for both sides of all relationships. Make reasonable assumptions to create the list and state your assumptions. There is no provably “right” list of assumptions.
5. Create a conceptual entity-relationship diagram using Crow’s Foot notation that reflects your list of business rules. You may use Microsoft Visio Pro or another similarly capable drawing application to produce your ERD. Note that cardinalities are not required in the diagram, though relationship connectivities are required.
Part 2: Veterinary Clinic
In this part, you will be repeating the same steps in Part 1 for a more complex veterinary clinic scenario. Review the following business rules then complete the steps indicated below.
Every pet has an owner.
Owners have one or more pets.
A pet may have multiple appointments with multiple veterinarians in the clinic.
One veterinarian attends each appointment.
Each appointment results in a bill for the