Database Answers City Hall

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Prescriptions Database
Back to the Data Model.

The Draft Business Rules have been defined and are listed below.
The Area being Modelled is a :-
Prescriptions Database

I would like an electronic prescription database application that would allow a doctor to
access patient information remotely and send prescriptions to pharmacy nationwide using wireless access.

Patients should be able to put in requests either via web access or phone and the doctor should be able to
access patients records, and treatment information and determine the appropriate response in terms of prescription.

A. DESIGN NOTES :
A.1

B. The Things of Interest, ('THINGS'), include :-
B.1 Patients
B.2 Drugs and Medications
B.3 Physicians
B.4 Prescriptions

C. These THINGS are Related as follows :-
C.1 A PATIENT can have zero, one or many PRESCRIPTIONS.
D. Other Characteristics of these THINGS include :-
D.1 To be determined.

E. Sample Data includes :-
E.1 To be determined

F. Typical Enquiries include :-
F.1 To be Determined
  Barry Williams
25th. jUNE 2009
Principal Consultant
Database Answers
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map