Page 199 - SQL
P. 199
A badly designed table:
Id Name DOB Name
1 Fred 11/02/1971 3
1 Fred 11/02/1971 3
3 Sue Friday the 18th July 1975 2, 1
• Rule 1: The second name field contains two values - 2 and 1.
• Rule 2: The DOB field contains dates and text.
• Rule 3: There's two fields called 'name'.
• Rule 4: The first and second record are exactly the same.
• Rule 5: This rule isn't broken.
Read Table Design online: https://riptutorial.com/sql/topic/2515/table-design
https://riptutorial.com/ 181
