The Area being Modelled is :-
Medical Laboratories.

A. STATEMENT OF USER REQUIREMENTS :
These Functional Requirements have been provided by Abdel.
I would like to have an ER Diagram to manage a Medical Laboratory.
These are the test type :-

1- Chemistry
2- Coagulation
3- CSF
4- Fluid
5- Hematology
6- Hormone
7- Microbiology
8- Urine

That is the end of the Functional Requirements for the Database.

A. WHAT ARE THE THINGS OF INTEREST ?
1. Tests
2. Test Results
3. Test Types


B. HOW ARE THE THINGS OF INTEREST RELATED ?
B.1 Each Test is of a specific Type.
B.2 A Test produces Test Results

Here is an analysis of the second Data Model which was received on Sunday, Ausgit 10th. 2008.


The Entities include :
 1. Account_Patient
 2. Emp_File
 3. In_Patient
 4. Insurance_Company
 5. Insurance_Cover
 6. Medicine
 7. Medicine_Alternative
 8. Nationality
 9. Patient_Date
10. Pharmacy
11. Title_Info
12. User_Prive
13. XRay
14. XRay_Info
15. XRay_Patient


Barry Williams
9th. August 2008
Principal Consultant
Database Answers