Question: Convert the table below to the 1NF Customer_Name Purchases Mark Smith Lenovo Yoga 7i Gen 7, Apple MacBook Air M2, Apple MacBook Air M1 Mark
Convert the table below to the 1NF
| Customer_Name | Purchases |
| Mark Smith | Lenovo Yoga 7i Gen 7, Apple MacBook Air M2, Apple MacBook Air M1 |
| Mark Jones | Apple MacBook Air M1, HP Pavilion Aero 13, Microsoft Surface Pro 8 |
| Jane Levy | HP Pavilion Aero 13, Acer Chromebook Spin 714, Microsoft Surface Pro 8 |
| Janet Jackson | Apple MacBook Air M2, Dell XPS 13, Dell G15 Gaming Laptop |
| Jenn Reed | Dell XPS 13, HP Pavilion Aero 13, Acer Chromebook Spin 714 |
2. Convert the table below to the 2NF
| Customer_ID | SKU | Price |
| 1 | 45824 | $1,300 |
| 1 | 78245 | $2,100 |
| 2 | 45824 | $1,300 |
| 2 | 21364 | $959 |
| 3 | 78245 | $2,100 |
| 3 | 14263 | $829 |
| 3 | 45824 | $1,300 |
3. Convert the table below to the 3NF
| Award | Year | Player_Name | Gender | Player_DOB |
| Ballon d'Or | 2022 | Karim Benzema | M | 19-Dec-87 |
| Ballon d'Or Fminin | 2021 | Alexia Putellas | F | 4-Feb-94 |
| Ballon d'Or | 2018 | Luka Modri | M | 9-Sep-85 |
| Socrates Award | 2022 | Sadio Man | M | 10-Apr-92 |
| Ballon d'Or | 2019 | Lionel Messi | M | 24-Jun-87 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
