• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Normailsation Question in DB

 
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Why does your bag say "bombs"? The reason I ask is that my bag says "tiny ads" and it has stuff like this:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic