We are modeling a medical records database for a clinic. The following story describes the entities and their relationships in our clinic: For each patient, there is an ID, name, age. We also need to maintain the patient's medical history before they joined the clinic. The medical history includes information on their previous illnesses, as well as, their vaccination record. The vaccination record includes the date and the place the vaccine is given, the name and the quantity of vaccine. For each vaccine, there is a unique id, name, and producer. For each physician, there is an ID, name, and specialty. We also need to keep track of each visit: Who the patient is, who the attending doctor is, and the date of the visit. For each visit, we also need to know: the medications prescribed and their dosage, tests ordered and the results of those tests, and the doctor's notes about the visit. Note: ⚫ For each time of vaccination, more than one vaccines could be given; ⚫ For each visit, 0 or more medicines could be prescribed, and 0 or more tests could be ordered Use Visual Paradigm to draw the ERD for the database model that you come up with for this clinic. Your diagram should show entities and their attributes, primary keys, and connecting relationships. Use three Normal Form rules to examine your tables to make sure they satisfy all three Normal Forms. Also, please resolve all m -n relationships into 1m or 1-1 relationships.
We are modeling a medical records database for a clinic. The following story describes the entities and their relationships in our clinic: For each patient, there is an ID, name, age. We also need to maintain the patient's medical history before they joined the clinic. The medical history includes information on their previous illnesses, as well as, their vaccination record. The vaccination record includes the date and the place the vaccine is given, the name and the quantity of vaccine. For each vaccine, there is a unique id, name, and producer. For each physician, there is an ID, name, and specialty. We also need to keep track of each visit: Who the patient is, who the attending doctor is, and the date of the visit. For each visit, we also need to know: the medications prescribed and their dosage, tests ordered and the results of those tests, and the doctor's notes about the visit. Note: ⚫ For each time of vaccination, more than one vaccines could be given; ⚫ For each visit, 0 or more medicines could be prescribed, and 0 or more tests could be ordered Use Visual Paradigm to draw the ERD for the database model that you come up with for this clinic. Your diagram should show entities and their attributes, primary keys, and connecting relationships. Use three Normal Form rules to examine your tables to make sure they satisfy all three Normal Forms. Also, please resolve all m -n relationships into 1m or 1-1 relationships.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
I need do fast typing clear urjent no chatgpt used i will give 5 upvotes pls full explain
Transcribed Image Text:We are modeling a medical records database for a
clinic. The following story describes the entities and
their relationships in our clinic:
For each patient, there is an ID, name, age. We also
need to maintain the patient's medical history before
they joined the clinic. The medical history includes
information on their previous illnesses, as well as, their
vaccination record. The vaccination record includes the
date and the place the vaccine is given, the name and
the quantity of vaccine. For each vaccine, there is a
unique id, name, and producer.
For each physician, there is an ID, name, and specialty.
We also need to keep track of each visit: Who the
patient is, who the attending doctor is, and the date of
the visit. For each visit, we also need to know: the
medications prescribed and their dosage, tests ordered
and the results of those tests, and the doctor's notes
about the visit.
Note:
⚫ For each time of vaccination, more than one vaccines
could be given;
⚫ For each visit, 0 or more medicines could be
prescribed, and 0 or more tests could be ordered
Use Visual Paradigm to draw the ERD for the database
model that you come up with for this clinic. Your
diagram should show entities and their attributes,
primary keys, and connecting relationships.
Use three Normal Form rules to examine your tables to
make sure they satisfy all three Normal Forms. Also,
please resolve all m -n relationships into 1m or 1-1
relationships.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.