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 clinic maintains records for each

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

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 19 21 2012 Proceedings Part 3 Lnai 7198

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284922, 978-3642284922

More Books

Students also viewed these Databases questions

Question

Define Management or What is Management?

Answered: 1 week ago

Question

What do you understand by MBO?

Answered: 1 week ago

Question

What is meant by planning or define planning?

Answered: 1 week ago

Question

Define span of management or define span of control ?

Answered: 1 week ago