J
Jaffa
Hi everyone.
I'm taking an IT exam shortly and I need to know how to do normalisation.
I'm not sure if this is the correct place to post, but I thought I'd give it
a go. So if anyone can help, the following is the data I'm attempting to
normalise, I've managed to progress through with it to third normalisation
form but I've no way of checking to see if it's correct.
Thanks for reading this and thanks for any help,
Student Records
Student Number:
C1231234
Student Name:
Andrew Phillips
Student Address:
12 Rectory Road, Liverpool
Module Code
Module Name
Module Level Cat Points
COM
Communications
1
12
VP1
Visual Programming 1
1
12
IT1
Information Technology Applications 1
1
12
EIN
Exploiting the internet
1
12
IMU
Introduction to Multimedia
1
12
Credits to Date:
60
Student Number:
B1234567
Student Name:
Carol Jones
Student Address:
3 Grange Road, Bristol
Module Code
Module Name
Module Level Cat Points
COM
Communications
1
12
VP1
Visual Programming 1
1
12
IT1
Information Technology Applications 1
1
12
EIN
Exploiting the internet
1
12
IMU
Introduction to Multimedia
1
12
BOR
Business Organisations
1
12
VP2
Visual Programming 2
1
12
IT2
Information Technology Applications 2
1
12
SDV
Systems Development
1
12
MAU
Multimedia Authoring
1
12
Credits to Date:
120
Student Number:
A3434567
Student Name:
James Black
Student Address:
25 The Grove, Stockton-on-Tees
Module Code
Module Name
Module Level Cat Points
COM
Communications
1
12
VP1
Visual Programming 1
1
12
IT1
Information Technology Applications 1
1
12
EIN
Exploiting the internet
1
12
IMU
Introduction to Multimedia
1
12
BOR
Business Organisations
1
12
VP2
Visual Programming 2
1
12
IT2
Information Technology Applications 2
1
12
SDV
Systems Development
1
12
MAU
Multimedia Authoring
1
12
DBS
Database Systems
2
12
NNM
Networks and Net Management
2
12
UIN
User Interfaces
2
12
ISM
Information Systems Management
2
12
AWW
Advanced World Wide Web
2
12
GPR
Group Project
2
12
CSE
Computer Security
2
12
AWW
Advanced World Wide Web
2
12
VRW
Virtual Reality for the Web
2
12
EXP
Expert Systems
2
12
Credits to Date:
240
I'm taking an IT exam shortly and I need to know how to do normalisation.
I'm not sure if this is the correct place to post, but I thought I'd give it
a go. So if anyone can help, the following is the data I'm attempting to
normalise, I've managed to progress through with it to third normalisation
form but I've no way of checking to see if it's correct.
Thanks for reading this and thanks for any help,
Student Records
Student Number:
C1231234
Student Name:
Andrew Phillips
Student Address:
12 Rectory Road, Liverpool
Module Code
Module Name
Module Level Cat Points
COM
Communications
1
12
VP1
Visual Programming 1
1
12
IT1
Information Technology Applications 1
1
12
EIN
Exploiting the internet
1
12
IMU
Introduction to Multimedia
1
12
Credits to Date:
60
Student Number:
B1234567
Student Name:
Carol Jones
Student Address:
3 Grange Road, Bristol
Module Code
Module Name
Module Level Cat Points
COM
Communications
1
12
VP1
Visual Programming 1
1
12
IT1
Information Technology Applications 1
1
12
EIN
Exploiting the internet
1
12
IMU
Introduction to Multimedia
1
12
BOR
Business Organisations
1
12
VP2
Visual Programming 2
1
12
IT2
Information Technology Applications 2
1
12
SDV
Systems Development
1
12
MAU
Multimedia Authoring
1
12
Credits to Date:
120
Student Number:
A3434567
Student Name:
James Black
Student Address:
25 The Grove, Stockton-on-Tees
Module Code
Module Name
Module Level Cat Points
COM
Communications
1
12
VP1
Visual Programming 1
1
12
IT1
Information Technology Applications 1
1
12
EIN
Exploiting the internet
1
12
IMU
Introduction to Multimedia
1
12
BOR
Business Organisations
1
12
VP2
Visual Programming 2
1
12
IT2
Information Technology Applications 2
1
12
SDV
Systems Development
1
12
MAU
Multimedia Authoring
1
12
DBS
Database Systems
2
12
NNM
Networks and Net Management
2
12
UIN
User Interfaces
2
12
ISM
Information Systems Management
2
12
AWW
Advanced World Wide Web
2
12
GPR
Group Project
2
12
CSE
Computer Security
2
12
AWW
Advanced World Wide Web
2
12
VRW
Virtual Reality for the Web
2
12
EXP
Expert Systems
2
12
Credits to Date:
240