Question

Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.2 into a dependency diagram that is in at least 3NF

Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.2 into a dependency diagram that is in at least 3NF

Answer 1

For the given ERD we draw the initial dependency diagram as below, Pres SessionNum Pres order Pres Date Pres Room Pres Title Pres AuthorlD Pres FName Pres LName Pres SessionNum Pres order Att Num Reg Date 「 ! Att Num Att Fname Att Lname Att Status From the dependency diagram we identify the PARTIAL and TRANSITIVE dependencies as, Pres_SessionNum -> Pres_Date, Pres_Room Pres AuthorID ->Pres FName, Pres LName Werevise the initial dependency diagram to show the "PARTIAL and TRANSITIVE" dependency Pres SessionNum Pres order Pres Date Pres Room Pres Title Pres AuthorID Pres FName Pres LName Att Num Att Fname Att Lname Att Status

Next we will eliminate the "PARTIAL" dependency to make the ERD in 2nd Normal Form. PRESENTATION SESSION Pres SessionNum Pres Date Pres Room PRESENTATION Pres SessionNum Pres order Pres Title Pres AuthorID Pres FName Pres LName REGISTRATION: Pres SessionNum Pres order Att Num Reg Date ATTENDANCE Att Num Att Fname Att Lname Att Status ERD in 3NF after removing "TRANSITIVE" dependency, PRESENTATION SESSION Pres SessionNum Pres Date Pres Room

PRESENTATION Pres SessionNum Pres order Pres Title Pres AuthorlD PRESENTATION AUTHOFR Pres AuthorID Pres FName Pres LName REGISTRATION: Pres_SessionNum Pres order Att_Num Reg_Date ATTENDANCE Att Num Att Fname Att Lname Att Status