normalizing tables

  suburban train 14:09 01 Nov 2003
Locked

I need help normalizing the following

I need to normalize the following in to 1nf, 2nf and 3nf

as I am linking java with databases design

Learner-driver-id
Learner-driver-surname
Learner-driver-first-name
Date-of-first-lesson
Theory-Test
Practical-Exam-Date
Date-pass-practical-exam
Driving-Instructor-Id
Driving-Instructor-surname
Driving-Instructor-first-name
Lesson-Date
lesson time
notes

This is how ive done it. Could some one tell me whether i have done it right?

1nf
Learner-driver-id (Primary Key)
Learner-driver-surname
Learner-driver-first-name
Date-of-first-lesson
Theory-Test
Practical-Exam-Date
Date-pass-practical-exam


Learner-driver-id
Driving-Instructor-Id
Lesson-Date
lesson time
notes


2nf
Learner-driver-id
Learner-driver-surname
Learner-driver-first-name
Date-of-first-lesson
Theory-Test
Practical-Exam-Date
Date-pass-practical-exam

Learner-driver-id
Driving-Instructor-Id
Lesson-Date
lesson time
notes

Driving-Instructor-Id
Driving-Instructor-surname
Driving-Instructor-first-name



3nf
Learner-driver-id
Theory-Test
Practical-Exam-Date
Date-pass-practical-exam

learner driver id
Learner-driver-surname
Learner-driver-first-name

learner driver id
Driving-Instructor-Id
Lesson-Date
lesson time
notes

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Comment afficher des fichiers cachés sur Mac ?