Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Solaris 11.2 System Administration (oracle Press)

Authors: Harry Foxwell

1st Edition

007184421X, 9780071844215

More Books

Students also viewed these Databases questions