Trusted by 2+ million users,
1000+ happy students everyday
1000+ happy students everyday
Showing pages 1 to 3 of 7 pages
MET CS 669 Database Design and Implementation for BusinessAssignment 2The two parts in this assignment will contribute equally to your grade and will beevaluated separately.Part 1: Authors and BooksReview 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 businessrules do not specify both sides of the relationship. You will be completing this list ofbusiness rules.1. To get started, list the names of all entities provided in the business rules above.- Author, Book, Subject2. Identify the entities that are related to each other.Author to Book, and Book to Author- each author can have multiple books andeach book can have multiple authors.Book to Subject, Subject to Book- one subject applies to at least 20 books, eachbook has at least one subject.Each Book contains a Year as an attribute.3. Identify the optionality and plurality constraints on both sides of each relationship,where possible. Indicate where the provided business rules do not provide theoptionality and plurality constraints.Author to Book – Mandatory, Plural relationship. Each Author must write one ormore books.Book to Author – Mandatory, Plural relationship. Each Book must be written byone or more AuthorsBook to Subject – Mandatory, Pluralrelationship. Each Book must correspond toat least one subject (not stated explicitly, but assumed).Subject to Book – Mandatory, Plural relationship. Each Subject must correspondto at least 20 books.4. Create a complete list of business rules. The new list should not add additionalentities, but should specify the optionality and plurality constraints for both sides of allrelationships. Make reasonable assumptions to create the list and state yourassumptions. There is no provably “right” list of assumptions.An author must write one or more books.A book must be written by one or more authors.A subject must apply to at least 20 books.Copyright 2011-2013 Boston University. All Rights Reserved.
A book must correspond to at least one subject.5. Create aconceptualentity-relationship diagram using Crow’s Foot notation thatreflects your list of business rules. You may use Microsoft Visio Pro or another similarlycapable drawing application to produce your ERD. Note that cardinalities are notrequired in the diagram, though relationship connectivities are required.
Part 2: Veterinary ClinicIn this part, you will be repeating the same steps in Part 1 for a more complex veterinaryclinic scenario. Review the following business rules then complete the steps indicatedbelow.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 pet owner.1. List the names of all entities provided in the business rules above.PetOwnerVeterinariansAppointmentBill2. Identify the entities that are related to each other.Pet to OwnerOwner to PetPet to AppointmentAppointment to PetVeterinarian to AppointmentAppointment to VeterinarianAppointment to BillBill to AppointmentBill to OwnerOwner to Bill3. Identify the optionality and plurality constraints on both sides of each relationship,where possible. Indicate where the provided business rules do not provide theoptionality and plurality constraints.Pet to Owner- Plural, Mandatory. Every pet must have one or more owners(assuming a pet can be linked to different members of a family, say mother andfather are each listed as an owner for their dog).Owner to Pet- Plural, Mandatory. Every owner must have one or more pets.Pet to Appointment- Singular, Optional. Every pet could have zero or moreappointments scheduled.Appointment to Pet- Singular, Mandatory.Every appointment must be for onepet (assuming that the vets do not treat more than one pet at a time).Veterinarian to Appointment- Singular, Optional. Every vet could have 0 or moreappointments scheduled.