---

Conceptual design (pg.122#12)

---

Logical design (pg.203#3)

a. 3NF

b. 3NF

c. 2NF

CLASS (Course_No, Section_No, Room)

ROOM (Room, Capacity)

d. 1NF

COURSE (Course_No, Course_Name)

CLASS (Course_No, Section_No, Room)

ROOM (Room, Capacity)

---

Physical design (pg.250#6)

A listing of employee schedules showing the employee’s name and the department’s manager. Rather than joining three tables (SCHEDULE, DEPARTMENT, and EMPLOYEE) to extract data for the list, it may be advisable to combine attributes from these tables giving DeNormalizedSchedule (Department_ID, Employee_ID, Date, Mangager_ID, Employee_Name). This approach is advantageous if such a list is needed frequently.

---