Hi, I have to make a very simple database to record student details and the modules they take for a side line university module.
I have read countless tutorials on Normalization but can't seem to get my head round it.
I would really apprieciate a bit of help.
The database basically records Students details, which modules they have chosen and which topics within each module they have chosen. There is a choice of 7 modules each containing 6 topics. A student can choose a total of 9 topics from any of the modules.
This is how my normalization has progressed so far:
Student ID*
Last name - text
First name - text
E-mail - text
Date profiled - date
Date accepted - date
Email sent requesting topics - date
Email received - date
Payment method - text
Fee form sent - date
Fee received - date
Profile to faculty office - date
On ISIS & User details sent - date
UWE user ID - number
UWE Password - text
CPD or MA - text
Module 1 ID -text
Topic 1 - text
Topic 2 - text
Module 2 ID - text
Topic 1 - text
Module 3 ID - text
Topic 1 - text
Topic 2 - text
Topic 3 - text
Notes - text
That's all the fields, I then tried to do 1NF and ended up with:
tblStudent
Student ID*
Last name
First name
Date profiled
Date accepted
Email sent requesting topics
Email received
Payment method
Fee form sent
Fee received
Profile to faculty office
On ISIS & User details sent
UWE user ID & Password
CPD or MA
Notes
tblModule 1
Student ID*
Module 1 ID
Topic 1
Topic 2
tblModule 2
Student ID*
Module 2 ID
Topic 1
Topic 2
tblModule 3
Student ID*
Module 2 ID
Topic 1
Topic 2
tblModule 1 topics
Topic 1
Topic 2
Topic 3
Topic 4
Topic 5
Topic 6
Topic 7
Topic 8
Topic 9
tblModule 2 topics
Topic 1
Topic 2
Topic 3
Topic 4
Topic 5
Topic 6
Topic 7
Topic 8
Topic 9
tblModule 3 topics
Topic 1
Topic 2
Topic 3
Topic 4
Topic 5
Topic 6
Topic 7
Topic 8
Topic 9
I'm pretty sure I have not grasped the concept of the Normalization proceedure!
Any advice would be really appreciated!
Regards,
David