Help normalize this into 4NF and make a diagram please? Or just explain the relations I should do. Here is the guide to do normalization * Each relation (table) represents a single subject. For example, a COURSE table will contain only data that directly pertain to courses. * Each row/column intersection contains only one value and not a group of values. * No data item will be unnecessarily stored in more than one table (tables have minimum controlled redundancy). * All nonprime attributes in a relation (table) are dependent on the primary key - the entire primary key and nothing but the primary key. * Each relation (table) has no insertion, update, or deletion anomalies, which ensures the integrity and consistency of the data.
Help normalize this into 4NF and make a diagram please? Or just explain the relations I should do.
Here is the guide to do normalization
* Each relation (table) represents a single subject. For example, a COURSE table will contain only data that directly pertain to courses.
* Each row/column intersection contains only one value and not a group of values.
* No data item will be unnecessarily stored in more than one table (tables have minimum controlled redundancy).
* All nonprime attributes in a relation (table) are dependent on the primary key - the entire primary key and nothing but the primary key.
* Each relation (table) has no insertion, update, or deletion anomalies, which ensures the integrity and consistency of the data.
![Customer
ID
Customer
bsmith1 Bob Smith
bsmith1 Bob Smith
bsmith1 Bob Smith
jthomas1 Jill Thomas
jthomas1 Jill Thomas
bsmith2 Bob Smith
bsmith2 Bob Smith
Customer Address
123 Brodway Dr;
bsmith@gmail.com
123 Brodway Dr;
bsmith@gmail.com
123 Brodway Dr;
bsmith@gmail.com
12 Kellogg Ave;
jthomas@gmail.com
12 Kellogg Ave;
jthomas@gmail.com
5 Maple Street;
smith5@gmail.com
5 Maple Street;
smith5@gmail.com
Customer Email
Subscription
Baseball, Basketball
Baseball, Basketball
Baseball, Basketball
Baseball
Baseball
Golf
Golf
Customer Customer
Mail Mail
Catalogs 1 Catalogs 2 Product ID
Basketball Golf
Basketball Golf
Basketball Golf
Baseball
Baseball
Golf
Golf
Bat-L
Product
Bastekball-SP Basketball Spaulding
Lousville
Slugger
Bastekball-SP Basketball Spaulding
Softball-R Softball Rawlings
Rawlings
Bat-R
Bat
Product
Manufacturer
Bat
Baseball Golf Balls-T Golf Balls Titleist
Baseball Bastekball-T Basketball Titleist
Product
Manufacturer Product
Product
Address
Details Cost
1 Spaulding
Drive
345 Slugger
Avenue
29.5 Inch $
$
35
29.5 Inch $ 23
1 Spaulding
Drive
23 Rawlings
Court
23 Rawlings
Court
1234 Titleist
Road
1234 Titleist
Road
33 Inch
4 Pack
32 Inch
$
1 Dozen $
$
$
1 Dozen
25
6
45
44
44
Customer
Quantity Order ID
1
1
1
2
1
2
2
Order Date Oder Total
1 8/9/2018 $ 70
1 8/9/2018 $
3 8/12/2018 $
2 8/10/2018 $
2 8/10/2018 $
4 8/12/2018 $
4 8/12/2018 $
70
23
57
57
88
88](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F659ad97f-17cb-4bb6-87df-297237f971a9%2F463d2707-6c87-4acf-abe3-dd63cdbbddc0%2Fbitieh9_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)