Database Answers Bahrain Medical Laboratory
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Medical Laboratories with Payments 
Back to the Data Model.
The Area being Modelled is :-
A Database for Medical Laboratories with Payments

Roberto says :-   
OK, so basically this is what I have right now. please excuse the language -literally :) but spanish is not hard to crack.

Paciente is Client, Resultado is Test Result, and Empresa is Company - oh by the way, this DB is to report tests results for a medical laboratory.

I use this currently to do reports BUT, I want to add billing capabilities.

By this I mean that I want at the end to show how much the Company has to pay for the tests.

I know this doesn�t obey almost ANY law of data normalization so I guess we could start from there.

The Resultado table holds all the variables of ALL the different tests that are performed in the lab;

note not all clients have all the test taken.


© DataBase Answers Ltd. 2010
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map