Question: 7) Create a NURSE table using the CREATE TABLE SQL statement. 8) Implement the 1: 1 relationship between NURSE and OFFICE (OfficeID is an FK
7) Create a NURSE table using the CREATE TABLE SQL statement.
8) Implement the 1: 1 relationship between NURSE and OFFICE (OfficeID is an FK in NURSE).
9) Insert 6 dummy records into the NURSE table (you can use SQL statements or directly type in the value, you can use unique values of your choosing for the PK).
10) Create the junction table NUR_SCH table using the CREATE TABLE SQL statement.
11) Implement the two FK relationships of the NUR_SCH table.
12) Insert 6 dummy records into the NUR_SCH table (you can use SQL statements or directly type in the value, you can use unique values of your choosing for the PK).
13) Create and populate the INGREDIENT table.
14) Create and populate the DRUG_INGDT table.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help