normalizing tables

  suburban train 14:09 01 Nov 03
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.

New Google phones UK release date | Pixel XL price, new features, specifications: Pixel X and…

1995-2015: How technology has changed the world in 20 years

This is the future of TV, VR and holograms

iPhone 7 review: Enhanced cameras, a refreshed design and water resistance make the iPhone 7 an…