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.