posted 9 years ago
HI Experts,
Preparing for db exam, can anyone help with following qns -
1) What is true about following table -
Tournament Year Winner Captain
Sports1 1998 County1 Captian1
Sports2 1999 County2 Captian2
Sports3 2000 County1 Captian1
A above table is in 2nd Normal form.
B above table is in 3rd Normal form.
C Table is not free from update anomalies
D Table is in 2nd normal form and has no update anomalies
(I think answer is d as you can take Tournament and year as composite (primary) key )
2) A table with following column-
Project Lead
Team Lead
where Team Lead has single entry pt. but project lead may have multiple entry is -
A. 1st normal form
b. 1st normal form provided team lead can be mapped to only 1 project lead
c. 2nd normal form provided team lead can be mapped to only 1 project lead
d. None of above
(I think answer is c, I made table like this -
PL TL
P1 T1
P1 T2
P2 T3
P2 T4
P3 T5)
Can anyone suggest