$3\mathrm{.}4$ Identifying Normal Forms $($ questions are all in bold $).$

For each of the following relations, indicate the highest normal forms the relation conforms to $($if any$).$

$1.$ Employee$($ EmpID, Name, Address, Phone, Skills$)$

FD Phone $$ Address

a$.$ Third Normal Form

b$.$ First Normal Form

c$.$ None of the above

d$.$ Second Normal Form

$2.$ Worker$($ WorkerID, WorkerName, SpouseSSN, SpouseName$)$

FD: SpouseSSN $$ SpouseName

a$.$ First Normal Form

b$.$ None of the above

c$.$ Third Normal Form

d$.$ Second Normal Form

$3.$ Sale$($Date$,$ Customer, Product, Vendor, Vendor$-$City, Salesrep$)$

FD: Customer $$ Salesrep

a$.$ Third Normal Form

b$.$ Second Normal Form

c$.$ None of the above

d$.$ First Normal Form

$4.$ Employee$($ ssn$,$ Name, Address, Salary, Supervisor, SupName$)$

FD: Supervisor $$ SupName

a$.$ Second Normal Form

b$.$ Third Normal Form

c$.$ First Normal Form

d$.$ None of the above

$5.$ Worker$($WorkerID$,$ WorkerName, SpouseName, Children$)$

a$.$ First Normal Form

b$.$ Second Normal Form

c$.$ None of the above

d$.$ Third Normal Form

$6.$ Student $($StudentNum$,$ Name, Bldg$,$ Floor, SeniorResident$)$

FD: Bldg$,$ Floor $$ SeniorResident

a$.$ First Normal Form

b$.$ None of the above

c$.$ Third Normal Form

d$.$ Second Normal Form

$7.$ Sale$($Date$,$ Customer, Product, Vendor, VendorCity, Salesrep$)$

FD: Vendor $$ VendorCity

FD: Product $$ Vendor

a$.$ First Normal Form

b$.$ Third Normal Form

c$.$ None of the above

d$.$ Second Normal Form

$8.$ Enrollment $($CourseNum$,$ StudentNum, Grade, Instructor, RoomNum$)$

FD: CourseNum $$ Instructor

FD: CourseNum $$ RoomNum

a$.$ First Normal Form

b$.$ None of the above

c$.$ Third Normal Form

d$.$ Second Normal Form

$9.$ Activity $($StudentNum$,$ Description, Date, Bldg$,$ Room, Cost$)$

FD: Description $$ Bldg

FD: Bldg $$ Cost

a$.$ Third Normal Form

b$.$ Second Normal Form

c$.$ First Normal Form

d$.$ None of the above

$10.$ InspectionDetail $($InspectionID$,$ EmployeeID, Score, Comment, Approval$)$

a$.$ Third Normal Form

b$.$ Second Normal Form

c$.$ None of the above

d$.$ First Normal Form