Normalising a database questions
Q1. What does normalising a database achieve?
Q2. What is meant by UNF or 0NF?
Q3. Write down exactly what you have to do to go from UNF to 1NF.
Q4. What is actually achieved when you put a database in 1NF?
Q5. Write down exactly what you have to do to go from 1NF to 2NF.
Q6. What is actually achieved when you put a database in 2NF?
Q7. Write down exactly what you have to do to go from 2NF to 3NF.
Q8. What is actually achieved when you put a database in 3NF?
Q9. What is the difference between a simple primary key and a compound primary key?
Q10. Showing the normalisation steps, normalise a student-course database. A typical record is shown below.
STUDENT RECORD
Student ID: 1232223
Surname: Patel
Initial: A
DofB: 09/06/1996
CourseNo CourseName LecturerID LecturerSurname LecturerInitial
435 Fractal Maths 23 Cooper A
200 Mechanics 18 Smith F
191 Chaos Theory 23 Cooper A
31 Random Theory 11 Mistry D