CS669_Assignment2Health-1 - MET CS 669 Database Design and...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
MET CS 669 Database Design and Implementation for Business Health Assignment 2 The two parts in this assignment will contribute equally to your grade and will be evaluated separately. Part 1: Physicians and Patients Review the following business rules regarding physicians and patients to complete this part. A diagnosis is given to one or more patients. A patient is given one or more diagnoses. An attending physician sees at least 20 patients. Each diagnosis is given a diagnosis code. 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. Copyright 2011-2013 Boston University. All Rights Reserved.
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Part 2: Pediatricians and Children In this part, you will be repeating the same steps in Part 1 for a more complex pediatrician clinic scenario. Review the following business rules then complete the steps
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern