Using MS-Access create the database's prototype that is including all relationships between tables. Enter all corresponding records for each table.

First image is the original data table. Second, is the crow foot notation of the tables gotten after transforming the original table to 4NF

Customer ID Product Cost Customer Quantity Order ID Customer Order Date Oder Total bsmith1 Bob Smith $ 25 1 1 8/9/2018 $ 70 bsmith1 Bob Smith $ 35 1 1 8/9/2018 $ 70 bsmithi Bob Smith $ 23 1 3 8/12/2018 $ 23 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 Mail Mail Product Manufacturer Product Subscription Catalogs 1 Catalogs 2 Product ID Product Manufacturer Address Details 1 Spaulding Baseball Basketball Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch Lousville 345 Slugger Baseball, Basketball Basketball Golf Bat-L Bat Slugger Avenue 33 Inch 1 Spaulding Baseball Basketball Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch 23 Rawlings Baseball Baseball Softball-R Softball Rawlings Court 4 Pack 23 Rawlings Baseball Baseball Bat-R Bat Rawlings Court 32 Inch 1234 Titleist Golf Golf Baseball Golf Balls-T Golf Balls Titleist Road 1 Dozen 1234 Titleist Golf Golf Baseball Bastekball-T Basketball Titleist Road 1 Dozen jthomas1 Jill Thomas $ 6 2 2 8/10/2018 $ 57 jthomas1 Jill Thomas $ 45 1 2 8/10/2018 $ 57 bsmith2 Bob Smith $ 44 2 4 8/12/2018 $ 88 bsmith2 Bob Smith $ 44 2 4 8/12/2018 $ 88 Customer_Email_Subscriptions PK FK Customer ID Subscription PK HPK Prod Manufacturer Product Manufacturer Manfucaturer Address Product Product ID Product Name Product Manufacturer Product Details Product Cost FK PK Customer Customer ID Customer Name Customer Address Customer Emailid Orders FK Customer ID PK Order ID Order Total Order Details PK Order Details ID EK Order ID FK Product ID Quantity Order Date Customer_Mail_Catalogs PK FK Customer ID Mail Catalog Customer ID Product Cost Customer Quantity Order ID Customer Order Date Oder Total bsmith1 Bob Smith $ 25 1 1 8/9/2018 $ 70 bsmith1 Bob Smith $ 35 1 1 8/9/2018 $ 70 bsmithi Bob Smith $ 23 1 3 8/12/2018 $ 23 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 Mail Mail Product Manufacturer Product Subscription Catalogs 1 Catalogs 2 Product ID Product Manufacturer Address Details 1 Spaulding Baseball Basketball Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch Lousville 345 Slugger Baseball, Basketball Basketball Golf Bat-L Bat Slugger Avenue 33 Inch 1 Spaulding Baseball Basketball Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch 23 Rawlings Baseball Baseball Softball-R Softball Rawlings Court 4 Pack 23 Rawlings Baseball Baseball Bat-R Bat Rawlings Court 32 Inch 1234 Titleist Golf Golf Baseball Golf Balls-T Golf Balls Titleist Road 1 Dozen 1234 Titleist Golf Golf Baseball Bastekball-T Basketball Titleist Road 1 Dozen jthomas1 Jill Thomas $ 6 2 2 8/10/2018 $ 57 jthomas1 Jill Thomas $ 45 1 2 8/10/2018 $ 57 bsmith2 Bob Smith $ 44 2 4 8/12/2018 $ 88 bsmith2 Bob Smith $ 44 2 4 8/12/2018 $ 88 Customer_Email_Subscriptions PK FK Customer ID Subscription PK HPK Prod Manufacturer Product Manufacturer Manfucaturer Address Product Product ID Product Name Product Manufacturer Product Details Product Cost FK PK Customer Customer ID Customer Name Customer Address Customer Emailid Orders FK Customer ID PK Order ID Order Total Order Details PK Order Details ID EK Order ID FK Product ID Quantity Order Date Customer_Mail_Catalogs PK FK Customer ID Mail Catalog