$1.$ Using the table description and business rules listed below answer or perform the following:

a$.$ Identify the Primary Key of the table as it is currently shown.

b$.$ Identify all of the functional dependencies.

c$.$ Draw the dependency diagram for the table$($s$)$

$2.$ Normalize the relation to $3$rd Normal Form $(3$NF$).$

Include progression from $1$NF to $3$NF

a$.$ List the normalized tables using the standard table notation

$($Remember Chen and$/$or Crow$$s foot$)$

$$ Tablename $($Col$1,$ Col$2......$Coln$)$

Primary Key:

Foreign Key:

b$.$ Draw the dependency diagrams for each of the tables.

$($ Hint: you should have no less than four tables$)$

c$.$ Provide an E$-$R Diagram of the tables to be created

d$.$ Review pages $208212$ in text

$3.$ Using the CREATE TABLE command, create each of the normalized tables. Run a

DESCRIBE command for each table.

$$ Include the PRIMARY KEY constraint for each table.

$$ Include the FOREIGN KEY constraint for each table to which it applies.

$$ Include the NOT NULL constraint for Student Name and Instructor Name.

$$ Include the CHECK constraint for the Grade to ensure it is one of the $5$ acceptable values $($A$,$ B$,$ C$,$ D$,$ or F$).$

$4.$ Code INSERT commands to insert the data from the attached page into the tables you created in $2.$

$$ Run $$SELECT $*$ FROM tablename; commands to check the contents of your tables.