Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!


Help With Database Design Project – HealthOne Medical Database

Help With Database Design Project – HealthOne Medical Database

General Guidance:

  • The Project has 3 parts each with the same number of points. Carefully read the instructions so you do not miss any relevant information.
  • What to submit: 
    • All parts must be submitted in ONE word document. 
    • All diagrams must be made using LucidChart or equivalent. 
  • Check specific instructions for each part.

Project Scenario

  • You are a small database consulting company specializing in developing databases for the medical industry. You have just been awarded the contract to develop a data model for a database application system for a mid-size health insurance company to keep track of health claims including patient information, provider(doctor) information, information about patient visits to their doctor as well as prescription drugs prescribed to patients.
  • Information such as patient name, address, phone, email etc. are needed as well as who each patient’s primary care doctor is, their insurance ID number and insurance company name. We also want information on each doctor such as their specialty and what hospitals they are affiliated with as well as their phone, address etc. Regarding the hospitals themselves we will need to know where they are located and how to contact them.
  • The prescriptions given to each patient by a health-care provider also need to be tracked in this particular database at this time to determine claim eligibility including some basic information on the drug being prescribed to make sure there are no conflicts with a patient’s other prescriptions. We need to know each drug’s name, purpose/use, and possible side effects.
  • Eventually, the database will be used to track trends and for some extrapolative modeling based on the accumulated data. The database will be accessible in English only right now, although plans include making it available in multiple languages eventually.

Part A: Determining entities, attributes, UIDs

Based on the business scenario stated above you will identify the database needs, and then create a conceptual data model to support these needs.

  1. Review the types of information a medical database may contain. Read articles and check the internet to understand the challenges of tracking this information.
  2. Research medical information to better understand your topic. Look for the type of information you will need to track.
  3. Build a list of business needs, rules and assumptions based on your scenario, research, and objectives.
  4. Develop a list of potential entities including their attributes, the attribute’s optionality as well as a possible UID for each entity.  HINT: A maximum of 4 are required. Choose carefully!
  5. Create a preliminary Entity Relationship Diagram (ERD) that meets these needs and objectives. (Note: Create entities only, relationships will be added in Part C)

What to submit: All relevant documentation for parts 1 to 4 plus preliminary ERD

PART B: Supertypes and subtypes

As stated in the scenario we need to track the visits a patient makes to their doctor. Some patient visits are related to a new issue/illness, some are follow up visits to an existing diagnosis and some visits are routine “well patient” visits or checkups. We would like to be able to track which type of visit each instance is so we can keep specific information regarding the visit. For example:

  • For a new issue/illness visit we will store an initial diagnosis
  • For follow-up visits we need to keep track of the patient’s status regarding the diagnosis
  • For routine checkups we need to track patient vital information such as current blood pressure, height, and weight and if any condition is discovered a diagnosis will be noted.

Finally, modify the ERD using a supertype/subtype structure within the Office Visit entity.

What to submit: Modified ERD 

PART C: Relationships

While creating your entities you should have been thinking about what relationships the entities would have with each other. Create the relationships between your entities including the relationship’s optionality and cardinality.

  1. Write out the ERDish for each of the relationships. HINT For example: Each PATIENT must have one and only one DOCTOR (their primary doctor) and/or Each PRESCRIPTION must be prescribed by one and only one DOCTOR. 
  2. Some relationships will be transferrable and some non-transferrable – be sure to illustrate this point on the ERD. For example, once a prescription is written for a patient it cannot be transferred to another patient.
  3. The possible relationship types are: 1-to-1, 1-to-many and many-to-many.
  4. Any many-to-many relationships will need to be resolved. For example, each doctor may be affiliated with many hospitals and each hospital may have many doctors affiliated with it. We need to make sure the many-to-many relationships are resolved.
  5. Modify the ERD from parts A and B to include the relationships.

What to submit: All ERDish rules and ERD diagram with relationships


Project 3 RubricProject 3 RubricCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeConceptual ER5 ptsFull Marks0 ptsNo Marks5 pts
This criterion is linked to a Learning OutcomeLogical/Implementation5 ptsFull Marks0 ptsNo Marks5 pts
This criterion is linked to a Learning OutcomeSubtypes5 ptsFull Marks0 ptsNo Marks5 pts
Total Points: 15

Our Service Charter

1. Professional & Expert Writers: Studymonk only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Studymonk are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Studymonk is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Studymonk, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.