• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Normailsation Question in DB

 
Siddhesh Khedekar
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic