Heyz

i got a normalization question, and was wondering what is the best way to go about this step by step:

Normalise the following list of attributes to 3rd normal form. give appropriate names for the resulting relations and indicate the primary key of each relation.

Student_ID, Student_Name, Campus_Address, Major, Course_ID, Course_Title, Instructor_Name, Instructor_Location, Grade

Note: A student can take more than one course. An instructor can teach many courses and one course may have many instructors.

Cheers

This is just an overview, but:

1) Read the textbook
2) Take notes, especially for the points you don't understand very well
3) Attend class
4) Ask lots of questions, especially about the points you didn't understand
5) Take advantage of office hours and or lab time
6) Start your homework early!

When you get to the point that you have specific questions that the teacher doesn't/can't cover, post those questions and I'll bet that one of us will answer them!

-PatP

That's an old-fashioned approach! These days the preferred method is:

1) Attend class if really necessary, or preferably just get a copy of the notes from someone else who did
2) Post homework questions on internet
3) Paste answers received on internet into your homework and submit to tutor.

Of course, this only really works well when coursework forms a major part of the final grading, since even if accessing the internet during exams is permitted (I wouldn't be surprised), the turn-around isn't usually quick enough to prevent dismal failure to answer the questions.

What have you gotten so far? I would start to work out the relationship between students and classes, instructors and classes, students and instructor. Let us know how can we help you further.

What does third normal form mean?

I tried to understand, but I codd'nt

If you were out with a Date, I'll bet you Codd!

-PatP

That's not punny.