06-24-2010, 11:53 AM
CS403 Database Management Systems Assignment No 4
Spring 2010
Total Marks: 20
Due Date: 29/06/2010
[Q1. In which normal form the following STUDENT relation is if only A,B can act as the key. Marks 10
STUDENT(A, B, C, D, E, F, G, H) Where A, B, C and so on are the attributes of the relation STUDENT.
A, B -> C, D, E
C -> F
D -> G
E -> H
Note: Also mention why the relation is in that normal form.
Q2. Examine the table shown below which is already in Second Normal Form (2NF). Marks 10
![[Image: cs403.jpg]](http://img10.imageshack.us/img10/3324/cs403.jpg)
You are required to normalize this relation into Third Normal Form (3NF).
Upload Instructions:
Please view the document related to assignment submission process provided to you by the Virtual University to upload the assignment.
Spring 2010
Total Marks: 20
Due Date: 29/06/2010
[Q1. In which normal form the following STUDENT relation is if only A,B can act as the key. Marks 10
STUDENT(A, B, C, D, E, F, G, H) Where A, B, C and so on are the attributes of the relation STUDENT.
A, B -> C, D, E
C -> F
D -> G
E -> H
Note: Also mention why the relation is in that normal form.
Q2. Examine the table shown below which is already in Second Normal Form (2NF). Marks 10
You are required to normalize this relation into Third Normal Form (3NF).
Upload Instructions:
Please view the document related to assignment submission process provided to you by the Virtual University to upload the assignment.