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-
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 -
Can anyone suggest
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads