Monday, March 26, 2012

Normalisation question?Help

I have an unnormalised data, and i would like to know if im normalizing the data correctly. It my homework, and its my first time doing normalisation as its so hard to understand. Thanks in advance.

UNF

Course code

Course title

Student Code

Student Name

Address

DOB

Telephone number

Module code

Module title

Tutor code

Tutor name

1NF

Student Code (Primary key)

Student Name

Address

DOB

Telephone number

-

Student Code( Foreign key)

Course code (Primary key)

Course title

Module code

Module title

Tutor code

Tutor name

2NF

Student Code (Primary key)

Student Name

Address

DOB

Telephone number

-

Course code (Primary key)

Student Code (Foreign key)

Course title

--

Module code (Primary key)

Module title

Tutor code

Tutor name

3NF

Student Code (Primary key)

Student Name

Address

DOB

Telephone number

-

Course code (Primary key)

Student Code (Foreign key)

Course title

Module Code(Primary key)

Student code (Foreign key)

Module title

--

Tutor code

Student code

Tutor name

In addition,

1. each course is taken by one or more studetns

2.each coruse is made up of one or more modules

3.a tutor may be teaching on one or more modules

4.each module must be delivered by one and only one tutor.

help pls..... :( im stuck

No comments:

Post a Comment