DATABASE NURSE NurseID 2 PROCEDURE NurseID 1 1 2 First Alice

DATABASE

NURSE NurseID 2 PROCEDURE NurseID 1 1 2 First Alice Bob Charlie Procedure Push IV Meds Arterial Sticks Push IV Meds Last Andrews Baker Chan Level RN CNA RN

Solution

1.

SELECT First, Last FROM
Nurse NOT IN (SELECT First, Last
FROM Nurse
NATURAL JOIN Procedure)

2.

SELECT Level,Count(Level)
FROM Nurse
ORDER BY Count(LEVEL)

3.
While inserting into tables we can encounter the following constraints:

1. FOREIGN KEY - Ensure the referential integrity of the data in one table to match values in another table
2. NOT NULL: Indicates that a column cannot store NULL value
3. DEFAULT: Specifies a default value for a column
4. UNIQUE - Ensures that each row for a column must have a unique value
5. PRIMARY KEY - A combination of a NOT NULL and UNIQUE

a) PRIMARY KEY CONSTRAINT can happen if NurseID is the primary key for the table.

b) NO code Violated.
c) UNIQUE CONSTRAINT will be violated since we have a similar tuple already inserted into the table in step b.

d) Multiple Values with Last name as \"Chan\" may get deleted using this code.
e) NO code Violated.
f) No ONSTRAINT will be violated since we have a similar tuple already inserted into the table in step e but with different primary key.

1.

SELECT First, Last FROM

Nurse NOT IN (SELECT First, Last

FROM Nurse

NATURAL JOIN Procedure)

2.

SELECT Level,Count(Level)

FROM Nurse

ORDER BY Count(LEVEL)

3.

While inserting into tables we can encounter the following constraints:

1. FOREIGN KEY - Ensure the referential integrity of the data in one table to match values in another table

2. NOT NULL: Indicates that a column cannot store NULL value

3. DEFAULT: Specifies a default value for a column

4. UNIQUE - Ensures that each row for a column must have a unique value

5. PRIMARY KEY - A combination of a NOT NULL and UNIQUE

a) PRIMARY KEY CONSTRAINT can happen if NurseID is the primary key for the table.

b) NO code Violated.

c) UNIQUE CONSTRAINT will be violated since we have a similar tuple already inserted into the table in step b.

d) Multiple Values with Last name as \"Chan\" may get deleted using this code.

e) NO code Violated.

f) No ONSTRAINT will be violated since we have a similar tuple already inserted into the table in step e but with different primary key.

5.

SELECT First, Last FROM

Nurse NOT IN (SELECT First, Last

FROM Nurse

NATURAL JOIN Procedure)

6.

SELECT Level,Count(Level)

FROM Nurse

ORDER BY Count(LEVEL)

7.

While inserting into tables we can encounter the following constraints:

1. FOREIGN KEY - Ensure the referential integrity of the data in one table to match values in another table

2. NOT NULL: Indicates that a column cannot store NULL value

3. DEFAULT: Specifies a default value for a column

4. UNIQUE - Ensures that each row for a column must have a unique value

5. PRIMARY KEY - A combination of a NOT NULL and UNIQUE

a) PRIMARY KEY CONSTRAINT can happen if NurseID is the primary key for the table.

b) NO code Violated.

c) UNIQUE CONSTRAINT will be violated since we have a similar tuple already inserted into the table in step b.

d) Multiple Values with Last name as \"Chan\" may get deleted using this code.

e) NO code Violated.

f) No ONSTRAINT will be violated since we have a similar tuple already inserted into the table in step e but with different primary key.