ICT - Normalisation

Okay, we've a question here, I've done it - I'd like to see if I got it right.

We have to normalise this table, first in 1NF then 2NF then 3NF.

Student ID, Forname, Surname, DOB, Courses Studied, Course ID, Course Title, Tutor ID, Tutor Forname, Tutor Surname

Thanks to anyone who has a go!

Reply 1

mike543406

Or your pretending to have done it but you just want other people to do it for you...

Reply 2

iainmacn

10

PhilMc

Okay, we've a question here, I've done it - I'd like to see if I got it right.

We have to normalise this table, first in 1NF then 2NF then 3NF.

Student ID, Forname, Surname, DOB, Courses Studied, Course ID, Course Title, Tutor ID, Tutor Forname, Tutor Surname

Thanks to anyone who has a go!

well I could just give you the answer, but why not post your solution and I'll tell you if it's ok :smile:

Reply 3

gnpatterson

Ha ha! If anyone really believed that cheats only cheat them selves then they would punish them by letting them cheat! And so ...

STUDENT (Student ID, Forname, Surname, DOB)

ENROLLED (Student ID, Course ID)

COURSE (Course ID, Course Title, Tutor ID)

TUTOR (Tutor ID, Tutor Forname, Tutor Surname)

by giving you the answer, I am being wicked or helpful, you decide.

ICT - Normalisation

Related discussions

Latest

Trending

Trending

Articles for you