 |
These are the Business Rules that have been drafted for Sultan Albalwi to define the conditions that the Database must meet.
A Patient can have one or many Addresses.
A Patient can stay in one or many Rooms during a stay in the Hospital.
A Patient can have one or many Bills.
Each Patient Bill can have one or many Bill Items.
Each Patient can have one or many Patient Records.
Each Patient Record can be for a different Record Component, such as Admission, Diagnosis, Medication etc..
A Patient can have one or many Methods of Payment.
Staff can have one or many Addresses.
Barry Williams
22nd. September 2013
Principal Consultant
Database Answers
|
