Sunday, February 13, 2011

2.0.4 QUESTION 4

Everyday, there are FIVE doctors is on duty in Orthopedic words. There are working on shift. A doctor can give a treatment to their patients and each patients can received a treatment from many doctor based on type of diseases. A patient can take a medicine but much medicine could be taken by many patients.
  1. Doctor information is DoctorID and DoctorName
  2. Patient information is PatientID, PatientName and Address
  3. Medicine informtion is MedicineCode and MedicineName
  4. For each treatment, it had TypeOfTreatment and CostOfTreatment
  5. For each accepted medicine, it has a Quantity and Date
ANSWER:

No comments:

Post a Comment