Explain it

Problem 2: Simulation Questions Answet the following questions with reference to the following relational database tbles shown on the belou The assumptions pertaining to these tables ate (1) a customer can place many orders and (Q) an order can have many inventory items. The primary key is underlined, whereas the foreign key is marked by an asterisk. Questions: (1) Identify violations of entity integity and mark these violations with an "E." (all occurrences) and (2) Identify violations of referential integrity and mark these violations with an "R". Identify only violations based on the tables that are presented below! Customer Table Order Table OrderDate FirstName LastName 2/1/3015 1/6/2015 C31004 2/1/2015 1/8/2015 2/1/2015 1/12/2015 C31011 Stonesifcr 5555193 014010 014011 0140122 0140292/1/30151/22/3015 C3100 014014 0140102/2/2015 1/8/2015 C31005 C31001 C31002 C31003 C31004 C31008 C31003 5555876 Nagaski 5555021 Sharon Stoncly5555602 Helen Hunter 5558018 Ted 2/1/2015 1/27/3015 014016 2/2/2015 1/8/2015 C31009 Inventory Table Inventory-Order Table 1,512 $496.90 $913.30 $10.90 $127.10 Notebook $995 30 $31.90 Monitor $105.30 11101 014011 014011 014010 014012 014012 014012 O14013 014013 014012 014016 014016 11102 11192 11105 11103 11104 1124) 1101 11305 1104 11133 11184 11102 1105 11103 11205 11102 TV 0 Clock 11104 1105 11203 14 32 10 14 1,315 11104 Printer- $218.10 11203 Scanner $14450 15 014029 12 014014 014014 23 Problem 2: Simulation Questions Answet the following questions with reference to the following relational database tbles shown on the belou The assumptions pertaining to these tables ate (1) a customer can place many orders and (Q) an order can have many inventory items. The primary key is underlined, whereas the foreign key is marked by an asterisk. Questions: (1) Identify violations of entity integity and mark these violations with an "E." (all occurrences) and (2) Identify violations of referential integrity and mark these violations with an "R". Identify only violations based on the tables that are presented below! Customer Table Order Table OrderDate FirstName LastName 2/1/3015 1/6/2015 C31004 2/1/2015 1/8/2015 2/1/2015 1/12/2015 C31011 Stonesifcr 5555193 014010 014011 0140122 0140292/1/30151/22/3015 C3100 014014 0140102/2/2015 1/8/2015 C31005 C31001 C31002 C31003 C31004 C31008 C31003 5555876 Nagaski 5555021 Sharon Stoncly5555602 Helen Hunter 5558018 Ted 2/1/2015 1/27/3015 014016 2/2/2015 1/8/2015 C31009 Inventory Table Inventory-Order Table 1,512 $496.90 $913.30 $10.90 $127.10 Notebook $995 30 $31.90 Monitor $105.30 11101 014011 014011 014010 014012 014012 014012 O14013 014013 014012 014016 014016 11102 11192 11105 11103 11104 1124) 1101 11305 1104 11133 11184 11102 1105 11103 11205 11102 TV 0 Clock 11104 1105 11203 14 32 10 14 1,315 11104 Printer- $218.10 11203 Scanner $14450 15 014029 12 014014 014014 23