The table below violates the Normal Form(s). Which normal form does it violate? Tournament Winners Tournament Year Winner Winner Date of Birth…

The table below violates the Normal Form(s). Which normal form does it violate?

Tournament Winners

TournamentYearWinnerWinner Date of Birth
Indiana Invitational1998Al Fredrickson21 July 1975
Cleveland Open1999Bob Albertson28 September 1968
Des Moines Masters1999Al Fredrickson21 July 1975
Indiana Invitational1999Chip Masterson14 March 1977
  1. a) All of normal forms listed here
  2. b) 3NF
  3. c) 2NF
  4. d) 1NF

From the Combined Bank Assistant Programmer (CSE) 2020 – Preliminary (DU) exam, question 8 of 47.

More from this paper