Normalizing it into 4NF. The store sells baseballs, basketballs, and golf equipment. Remember to follow the normalization process described in the textbook, which includes:

* 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.

B D M N P O R S U Customer 1 ID Customer Email Subscription Product Cost Customer Orde Order ID Date Oder Total Customer Quantity 2 bsmith1 Bob Smith Baseball Basketball $ 25 1 1 2018/8/9 $ 70 - + 3 bsmith1 Bob Smith Baseball, Basketball Bat- $ 35 1 1 2018/8/9 $ 70 E F G H Customer Customer Product Mail Mail Product Manufacturer Product Catalogs 1 Catalogs 2 Product ID Product Manufacturer Address Details 1 Spaulding Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch Lousville 345 Slugger Basketball Golf Bat Slugger Avenue 33 Inch 1 Spaulding Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch 23 Rawlings Baseball Softball-R Softball Rawlings Court 4 Pack 23 Rawlings Baseball Bat-R Bat Rawlings Court 32 Inch 1234 Titleist Baseball Golf Balls-T Golf Balls Titleist Road 1 Dozen 1234 Titleist Golf Baseball Bastekball-T Basketball Titleist Road 1 Dozen 4 bsmith1 Bob Smith Baseball, Basketball $ 23 1 3 2018/8/12 $ 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 23 5 jthomas1 Jill Thomas Baseball 6 2 2 2018/8/10 $ 57 6 jthomas1 Jill Thomas Baseball $ 45 1 2 2018/8/10 $ 57 7 bsmith2 Bob Smith Golf Golf $ 44 2 4 2018/8/12 $ 88 Bob Smith Golf 44 2 4 2018/8/12 $ 88 8 bsmith2 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Sheet1 + B D M N P O R S U Customer 1 ID Customer Email Subscription Product Cost Customer Orde Order ID Date Oder Total Customer Quantity 2 bsmith1 Bob Smith Baseball Basketball $ 25 1 1 2018/8/9 $ 70 - + 3 bsmith1 Bob Smith Baseball, Basketball Bat- $ 35 1 1 2018/8/9 $ 70 E F G H Customer Customer Product Mail Mail Product Manufacturer Product Catalogs 1 Catalogs 2 Product ID Product Manufacturer Address Details 1 Spaulding Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch Lousville 345 Slugger Basketball Golf Bat Slugger Avenue 33 Inch 1 Spaulding Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch 23 Rawlings Baseball Softball-R Softball Rawlings Court 4 Pack 23 Rawlings Baseball Bat-R Bat Rawlings Court 32 Inch 1234 Titleist Baseball Golf Balls-T Golf Balls Titleist Road 1 Dozen 1234 Titleist Golf Baseball Bastekball-T Basketball Titleist Road 1 Dozen 4 bsmith1 Bob Smith Baseball, Basketball $ 23 1 3 2018/8/12 $ 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 23 5 jthomas1 Jill Thomas Baseball 6 2 2 2018/8/10 $ 57 6 jthomas1 Jill Thomas Baseball $ 45 1 2 2018/8/10 $ 57 7 bsmith2 Bob Smith Golf Golf $ 44 2 4 2018/8/12 $ 88 Bob Smith Golf 44 2 4 2018/8/12 $ 88 8 bsmith2 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Sheet1 +