For each question, identify the current normal form $\{$UNF$,1$NF$,2$NF$,3$NF$\},$ generate a few business rules $\{$functional dependencies$\}.$ Then normalize the tables into $3$NF$.$

$$ You may create key attributes $[$primary keys or foreign keys$]$ if needed.

$$ You may either draw the tables $($using Word table option$)$ or use standard written form.

Standard Written Form:

TABLENAME$($primaryKey$,$ attribute, attribute, $...,$ foreignkeyattribute$)$

o TABLENAMES are in all caps

o primaryKeys are underlined

o foreignKeys are italicized

o not all tables have foreign keys BUT all tables have primary keys

$1.$ A database is needed to track procedures performed by surgeons.

Surgeons

Pin Procedure

ID Surgeons

Name Procedure

Name Surgery

Date

What form is this table in$?$

Identify at least $3$ business rules $($functional dependencies$).$ I have done provided the first one as an example.

$1.$ Surgeons are identified by a unique numeric PIN

$2.\_$

$3.\_$

Normalize to $3$NF$.$