Homework#3, Due date:4/12/2006

Consider the following: R (CLASS,SECTION,STUDENT,MAJOR,EXAM,EXAM-GRADE,YEAR,INSTRUCTOR, RANK,SALARY,TEXT,DAY,ROOM)

1. Assuming the following dependencies, split R into 4NF relations.

   
   
   	CLASS,SECTION ----> TEXT              TEXT ----> CLASS
   	CLASS,SECTION ----> INSTRUCTOR        STUDENT ----> YEAR
           STUDENT ----> MAJOR                   INSTRUCTOR ----> SALARY
   	INSTRUCTOR ----> RANK         
           CLASS,SECTION ---->----> DAY
   	CLASS,SECTION,STUDENT,EXAM ----> EXAM-GRADE
   
   

2. Assuming that each of your relations is an entity, draw ER diagram to represent the result of normalizing R.