Hi, I did this homework for my database class, but my professor wanted me to make some changes. Here are the answers I have so far:

10) All attributes are dependent on StudentNum:

StudentNum -> StudentName, StudentMajor, AdvisorNum, AdvisorName, AdvisorOfficeNum, AdvisorPhone, NumCredits, Class

StudentNum determines the name, major, advisor number, advisor name, office number, phone number, the number of credits and the class.

AdvisorNum -> AdvisorName, AdvisorOfficeNum, AdvisorPhone

AdvisorNum determines the advisors name, office number and phone number. Each student only has one advisor and each advisor has one office and phone number.

Class -> NumCredits

The number of credits can be determined by the type of class that was taken.

12) Convert the table to a collection of tables in third normal form:

Student (StudentNum, StudentName, NumCredits, AdvisorNum, AdvisorName, DeptNum, DeptName,(CourseNum, Description, Term, Grade))

StudentNum (StudentNum, StudentName, NumCredits, AdvisorNum, AdvisorName, DeptNum,DeptName)

AdvisorNum (AdvisorName, DeptNum, DeptName)

CourseNum (Description, Term)

Student (StudentNum, StudentName, NumCredits, AdvisorNum)

Advisor (AdvisorNum, AdvisorName, DeptNum, DeptName)

Course (CourseNum, Description)

Grade (StudentNum, CourseNum, Description, Term, Grade)

However, I was supposed to do extra work that wasn't in the book and missed where she explained it. Here are the instructions:

In each problem, take the information given and convert it to a collection of tables in 3rd Normal Form using DBDL format (I dont need to see the steps you took to get therejust the final result). I dont really like how the book attempts to document dependencies; in fact I think they can be misleading. Use common sense and document any assumptions you made. Dont forget to underline the primary key for each table in your answer.

#10

Instead of placing in 3NF using DBDL you follwed the book. Please follow the dropbox.

#12

Num fields are primary keys and not table names..

I would probably break out StudentName, AdviorsName into two fields

Where is the department table?

No ERDS.....They are going to show up in the take home exam. and DB Project #2