Normalization:

For each problem -

a. Identify the given table as 1NF, 2NF, 3NF, or UNF (contains repeating group).

b. Identify all partial and transitive dependencies by drawing a dependency diagram (for a UNF table, transform it to 1NF, then draw the dependency diagram).

c. Transform all tables into 3NF by following the steps below. For c, you do NOT have to draw dependency diagrams.

1. STUDENT (STUDENT SSN, ST NAME, MAJOR, ADVISOR NUM, ADV NAME ADV_OFFICE, ADV PHONE, ST CREDITHRS, CLASS_STANDING) where: STUDENT SSN ?All other attributes ADVISOR NUM > ADV NAME, ADV OFFICE, ADV_PHONE ST CREDIT HRS ? CLASS STANDING Note: XYZ QRS means that XYZ determines QRS You can also find this notation in figure 6.3 and definition of determination on page 62 2. MOVIE (MOVIE NUM, MOVIE TITLE, STAR NUM, STAR NAME) Sample data: ?You can determine prima based on the sample data. STAR NUM S001 S002 S001 S003 STAR NAME Brendan Fraser Rachel Weisz Brendan Fraser Sandra Bullock MOVIE NUM M001 MOVIE TITLE The Mumm M002 Crash (You may notice one movie can feature many stars and one star can act in many movies.) 3. MOVIE (MOVIE NUM, MOVIE TITLE, DIRECTOR NUM, DIR NAME) where: MOVIE NUM ? MOVIE TITLE, DIRECTOR NUM. DIR NAME DIRECTOR NUM DIR NAME