IS 3063

3.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