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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!