DBA

1. Members of your design team have been working with the local hospital to develop a data model for their need to store information about patients, the patient's room number, the patient's docto drug information. r, drug prescriptions given, and specific However, they all went on vacation and left you to figure out the model. They also failed to give you any of their documentation other than the entities and attributes illustrated here. Instead of going back to the hospital, which could reflect poorly on your company, you're going to have to think about everything you know about hospitals! Your task is to generate a list of business rules you think were used to arrive at the information shown here. Use your imagination. List 10 structural rules, 5 procedural rules, and 2 programmatic rules (rules to be addressed by computer applications in the future). State each rule as a single sentence Based on your set of business rules, draw the ERD ROOM building number room number PATIENT patient number patient name PHYSICIAN physician numberprescription number name license number PRESCRIPTION date issued DRUG code drug name cost DRUG LABEL label number dosage treatment duration expiration date