December
1998 QUESTION 2 Total Marks: 20 Marks |
Click here to access other
questions
Click to access
|
| (a) | Give three reasons why normalization is carried
out.
|
[3] |
| (b) | What is denormalization? Give two situations
where it might be considered, and explain carefully why it might be useful in each case.
|
[7] |
| (c) | Apply the normalization rules to the
following data structures, which show the data to be recorded in a database of student
records. All of your intermediate steps (UNF, INF, 2NF, 3NF) should be shown in detail.. student record = student number + student name + contact phone number + major + {course number + course title + instructor name + instructor location + grade} |
[10] |