Answered step by step
Verified Expert Solution
Link Copied!

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

image

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management A Systems Approach To Planning Scheduling And Controlling

Authors: Harold Kerzner

13th Edition

1119805376, 978-1119805373

More Books

Students also viewed these Databases questions