The Specifications have been defined in a question from Naveed Shahzad to the Database Answers Community.
If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
We might also design a Data Warehouse which is very useful for providng data for Reports and Business Intelligence.
This is a Generic Model showing Table names and Key fields only.
There is another Model showing a separate Table for each Test :-
Patient Tests with Separate Tables
Database Answers Ltd.
March 10th. 2011
© DataBase Answers Ltd. 2010