7,540
edits
Changes
→Third normal form
===Third normal form===
https://en.wikipedia.org/wiki/Third_normal_form#%22Nothing_but_the_key%22<br>
Third normal form (3NF) is a normal form that is used in normalizing a database design to reduce the duplication of data and ensure referential integrity by ensuring that:-
# the entity is in second normal form
Update anomalies cannot occur in these tables, because unlike before, '''Winner''' is now a primary key in the second table, thus allowing only one value for '''Date of Birth''' for each '''Winner'''.
==Database Normalization==