Members of your design team have been working with the local hospital to develop a data...

Transcribed Image Text:

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 doctor, drug prescriptions given, and specific drug information. 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! These are the entities that you might be using: ROOM PHYSICIAN PATIENT DRUG PRESCRIPTION DRUG LABEL 1. Create an Oracle Database that stores at least 5 instances of each entity you create, and note the foreign keys as well. 2. Afterwards, place screenshots of the code creating the tables, adding the instances, adding the foreign keys. 3. Place screenshots of all the tables used along with their instances. 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 doctor, drug prescriptions given, and specific drug information. 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! These are the entities that you might be using: ROOM PHYSICIAN PATIENT DRUG PRESCRIPTION DRUG LABEL 1. Create an Oracle Database that stores at least 5 instances of each entity you create, and note the foreign keys as well. 2. Afterwards, place screenshots of the code creating the tables, adding the instances, adding the foreign keys. 3. Place screenshots of all the tables used along with their instances.