Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Design an E/R Model for a small lab clinic. The data requirements for your design are summarized as follows: the clinic maintains records for each
Design an E/R Model for a small lab clinic. The data requirements for your design are summarized as follows: the clinic maintains records for each patient that uses the clinic, including: id (auto- generated by the system), first and last name, email, and phone(s); when patients visit the clinic, they can order one or more lab exams; for each order, the system automatically generates an unique order number; an order also records the date and time of the visit: an order is composed of a list of lab exams, each prescribed by a physician; a physician is identified by their UPIN, also having first and last name and email; each ordered lab exam is based on a national table of standardized lab exams; each standard lab exam is uniquely identified by its Logical Observation Identifiers Names and Codes (LOINC) number, also having a description, instructions for the patient, and instructions for the medical technician; the clinic record information about the physician that prescribed each lab exam ordered; an ordered lab exam can be on 3 different stages while is being processed: pre-testing, testing, and post-testing; it is only when an ordered lab exam is in post-testing stage that its results are available for patients; depending of the nature of the lab exam, it can potentially yield many results, also defined by its national standard; a lab exam result has a sequential number (unique within the lab exam LOINC number), a description, a value, a unit, and reference values (a text); for example, a Complete Blood Test (CBC) lab exam shows counts for red cells and platelets (each count is a result), among other results; the system should be able to present a report showing: patient information, date and time of the order, the name of each exam ordered, the physician that prescribed the exam, and the results of each exam (if in the post-testing stage)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started