Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

department Pid Hints: name Indexes Instructions: physician Pid name position SSN department id Indexes procedures cade name cost Indexes patient SSN name address phone

department Pid Hints: name Indexes Instructions: physician Pid name position SSN department id Indexes

department Pid Hints: name Indexes Instructions: physician Pid name position SSN department id Indexes procedures cade name cost Indexes patient SSN name address phone insurance Indexes hospital record record d patient san procedure code physician d -assistingNurse_id room num date undergoes stay Start stayEnd Indexes nurse Pid name position registered SSN Indexes Droom number roomType floor block Indexes You will need to interpret this diagram and complete the following steps to create our new tables and populate them with data. 1. You can use the CSV files located on Canvas to help you create the tables 2. All the tables have an ID column, sometimes referenced in a different table. This is the primary key-foreign key relationship. 3. If foreign key constraints exist, the order you create tables and import data matters. You might want to start with the department table. 4. Include all screenshots in a single Word document with headers for each step. Part 1: Our new database contains 7 tables. You will need to create the new tables using SQL statements and establish referential integrity between the appropriate tables. 1. Provide screenshot(s) of the SQL statements used to create the new tables (include the statement and the Action Output) 2. Provide screenshot(s) of the SQL statements used to establish referential integrity between the appropriate tables a. Make sure to use CASCADE UPDATE and CASCADE DELETE b Hint: You can interpret which columns are foreign keys from the ERD

Step by Step Solution

3.39 Rating (161 Votes )

There are 3 Steps involved in it

Step: 1

Since I cannot interact with external files or systems such as the Canvas platform mentioned Im unable to access the CSV files or to include screensho... 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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Programming questions

Question

What is activity-based product costing?

Answered: 1 week ago