15 points) Using the following tables to answer the below query: ID 1 mah W 24 ON MANIS 201 5600 200 55500 200 110 $100.00 24 1100 SO 205 1102 55 200 $109.00 1100 57.00 1) (10 points)SELECT Insurence Company ID and coverage, FROM Insurence Company Table , WHERE Insurence Company name is DKI. 2) (5 points) Give your reasons regards how many records does your answer include? Give your reasons Question 1: (15 points). Normalization is a data analysis technique to design a database system. It allows the database designer to understand the current data structures in an organization. Normalization is a technique for producing relational schema with no information redundancy and no update anomalies. Item ID Item Name Item Uritttem Supplier Lead Time Inventory Level Reorder Point Supplier ID Supplier Country Minimum Order 1212GHG Garden Shed Units AAA Company 20 days 120 50 30 5533 USA 1212PHP Painted Garden Shed Units BBB Company 15 days 50 5 15 S522 UK 1212THT Tools Shed Units CCC Company 45 days 255 100 40 5544 UAE RM30 Wood M2 BBB Company 5 days 10 5 20 5522 UK RM50 Inch Screws Bag AAA Company 15 days 100 60 25 5533 USA RM60 Glass M2 BOB Company 10 days 35 10 15 S522 UK RM70 Filer Bag AAA Company 35 days 45 10 20 5533 USA After investigating the above Table, please normalize it using Iter, Supplier. Order, Supplier Item tables. Draw an entity-relationship diagram of the normalized database (specify the primary key in each Table and specify the type of the relationship). 15 points) Using the following tables to answer the below query: ID 1 mah W 24 ON MANIS 201 5600 200 55500 200 110 $100.00 24 1100 SO 205 1102 55 200 $109.00 1100 57.00 1) (10 points)SELECT Insurence Company ID and coverage, FROM Insurence Company Table , WHERE Insurence Company name is DKI. 2) (5 points) Give your reasons regards how many records does your answer include? Give your reasons Question 1: (15 points). Normalization is a data analysis technique to design a database system. It allows the database designer to understand the current data structures in an organization. Normalization is a technique for producing relational schema with no information redundancy and no update anomalies. Item ID Item Name Item Uritttem Supplier Lead Time Inventory Level Reorder Point Supplier ID Supplier Country Minimum Order 1212GHG Garden Shed Units AAA Company 20 days 120 50 30 5533 USA 1212PHP Painted Garden Shed Units BBB Company 15 days 50 5 15 S522 UK 1212THT Tools Shed Units CCC Company 45 days 255 100 40 5544 UAE RM30 Wood M2 BBB Company 5 days 10 5 20 5522 UK RM50 Inch Screws Bag AAA Company 15 days 100 60 25 5533 USA RM60 Glass M2 BOB Company 10 days 35 10 15 S522 UK RM70 Filer Bag AAA Company 35 days 45 10 20 5533 USA After investigating the above Table, please normalize it using Iter, Supplier. Order, Supplier Item tables. Draw an entity-relationship diagram of the normalized database (specify the primary key in each Table and specify the type of the relationship)