Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Members of your design team have been working with the local hospital to develop a data model for their need to store information about
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started