Use the data files below to create the database as shown in Figure P7.9

Q6. Find the total value of the product inventory. Query: Screenshot of results:

FIGURE P7.9 THE CH07_SALECO DATABASE Table name: CUSTOMER Table name: VENDOR Table name: INVOICE Table name: IINE Table name: PRODUCT INSERT INTO EMP VALUES (100,Mr, ', 'Kolmycz', 'George', 'D', '1942-0615,19850315,615,3245456, NULL) ; INSERT INTO EMP VALUES (101,Ma, ', ', 'Lewis', 'Rhonda', 'G', '1965-0319,19860425,615,3244472,100); 14 ', '1998-11-08','615','890-3220', NULL ); INSERT INTO EMP VALUES (106, 'Mr3,','Smith', 'Jeanine', 'K', '1968-02- INSERI INTO EMP VALUES (106,' Mr3,',' SmIt INSERT INTO EMP VALUES (110, 'Mr3,','Genk 19,199012011,901,5690093,108); INSERT INTO EMP VALUES (111,' 'Mr,',' 'Washington', 'Rupert', 'E', '1966-01- 0319930621,615,8904925,105); INSERT INTO EMP VALUES(112, 'Mr,',' Johnson', 'Edward', 'E', '1961-05- 14',' '1983-12-01','615','898-4387', 100); INSERT INTO EMP VALUES (113, 'Ma.', 'Smythe', 'Melanie', 'P', '1970-09- 15,19990511,1615,13249006,105); INSERT INTO EMP VALUES (114,' 'M3.',' 'Brandon', 'Marie', 'G', '1956-11- 02',' '1979-11-15',' 901,8820845,108); INSERT INTO EMP VALUES (115, 'Mr3,','Saranda', 'Hermine', 'R', '1972-07- 25r19930423,615,3245505,105); * EMPLOYEE rOwB INSERT INTO EMPLOYEE VALUES (100, 'Mr.','Kolmycz', 'George', 'D', '1942- 0615,19850315,18,1615,3245456); INSERT INTO EMPLOYEE VALUES (104,' 'Hr.' INSERT INTO EMPLOYEE VALUES (105, 'Mr.',' 'Williams', 'Robert', 'D', '1975- 0314,19981108,4,615,8903220); INSERT INTO EMPLOYEE VALUES (106, 'Mrs,','Smith', 'Jeanine', 'K', '1968- 0212,19890105,14,,615,3247883); INSERT INTO EMPLOYEE VALUES (107, 'Mr.','Diante', 'Jorge', 'D', '1974- 0821,19940702,8,615,8904567); INSERT INTO EMPLOYEE VALUES (109, 'Mr,',' 'Wiesenbach','Paul', ''R', '1966- INSERT INTO EMPLOYEE VALUES (109,'Mr,','Smith', 'George', 'K', '19610618,19890414,13,901,5043339); INSERT INTO EMPLOYEE VALUES (110, 'Mrs,',' Genkazi', 'Leighla', 'W', '19700519,19901201,12,901,5690093); INSERT INTO EMPLOYEE VALUES (111,'Mr,', 'Washington', 'Rupert', 'E', '19660103,19930621,9,615,8904925); INSERT INTO EMPLOYEE VALUES (112, 'Mr.', 'Johnson', 'Edward', 'E', '19610514,19831201,19,615,8984387); INSERT INTO EMPLOYEE VALUES (113, 'Ms.', 'Smythe', 'Melanie', 'P', '1970- 0915,19990511,3,615,3249006); INSERT INTO EMPLOYEE VALUES (114,'Ma,','Brandon', 'Marie', 'G', '1956- 1102,19791115,23,901,8820845); INSERT INTO EMPLOYEE VALUES (115, 'Mrs.',' Saranda', 'Hermine', 'R ', '1972- 0725,19930423,9,615,3245505); INSERT INTO EMPLOYEE VALUES (116, Mr.' ' 'Smith', 'George', 'A', '1965- 1108,19881210,14,615,18902984); FIGURE P7.9 THE CH07_SALECO DATABASE Table name: CUSTOMER Table name: VENDOR Table name: INVOICE Table name: IINE Table name: PRODUCT INSERT INTO EMP VALUES (100,Mr, ', 'Kolmycz', 'George', 'D', '1942-0615,19850315,615,3245456, NULL) ; INSERT INTO EMP VALUES (101,Ma, ', ', 'Lewis', 'Rhonda', 'G', '1965-0319,19860425,615,3244472,100); 14 ', '1998-11-08','615','890-3220', NULL ); INSERT INTO EMP VALUES (106, 'Mr3,','Smith', 'Jeanine', 'K', '1968-02- INSERI INTO EMP VALUES (106,' Mr3,',' SmIt INSERT INTO EMP VALUES (110, 'Mr3,','Genk 19,199012011,901,5690093,108); INSERT INTO EMP VALUES (111,' 'Mr,',' 'Washington', 'Rupert', 'E', '1966-01- 0319930621,615,8904925,105); INSERT INTO EMP VALUES(112, 'Mr,',' Johnson', 'Edward', 'E', '1961-05- 14',' '1983-12-01','615','898-4387', 100); INSERT INTO EMP VALUES (113, 'Ma.', 'Smythe', 'Melanie', 'P', '1970-09- 15,19990511,1615,13249006,105); INSERT INTO EMP VALUES (114,' 'M3.',' 'Brandon', 'Marie', 'G', '1956-11- 02',' '1979-11-15',' 901,8820845,108); INSERT INTO EMP VALUES (115, 'Mr3,','Saranda', 'Hermine', 'R', '1972-07- 25r19930423,615,3245505,105); * EMPLOYEE rOwB INSERT INTO EMPLOYEE VALUES (100, 'Mr.','Kolmycz', 'George', 'D', '1942- 0615,19850315,18,1615,3245456); INSERT INTO EMPLOYEE VALUES (104,' 'Hr.' INSERT INTO EMPLOYEE VALUES (105, 'Mr.',' 'Williams', 'Robert', 'D', '1975- 0314,19981108,4,615,8903220); INSERT INTO EMPLOYEE VALUES (106, 'Mrs,','Smith', 'Jeanine', 'K', '1968- 0212,19890105,14,,615,3247883); INSERT INTO EMPLOYEE VALUES (107, 'Mr.','Diante', 'Jorge', 'D', '1974- 0821,19940702,8,615,8904567); INSERT INTO EMPLOYEE VALUES (109, 'Mr,',' 'Wiesenbach','Paul', ''R', '1966- INSERT INTO EMPLOYEE VALUES (109,'Mr,','Smith', 'George', 'K', '19610618,19890414,13,901,5043339); INSERT INTO EMPLOYEE VALUES (110, 'Mrs,',' Genkazi', 'Leighla', 'W', '19700519,19901201,12,901,5690093); INSERT INTO EMPLOYEE VALUES (111,'Mr,', 'Washington', 'Rupert', 'E', '19660103,19930621,9,615,8904925); INSERT INTO EMPLOYEE VALUES (112, 'Mr.', 'Johnson', 'Edward', 'E', '19610514,19831201,19,615,8984387); INSERT INTO EMPLOYEE VALUES (113, 'Ms.', 'Smythe', 'Melanie', 'P', '1970- 0915,19990511,3,615,3249006); INSERT INTO EMPLOYEE VALUES (114,'Ma,','Brandon', 'Marie', 'G', '1956- 1102,19791115,23,901,8820845); INSERT INTO EMPLOYEE VALUES (115, 'Mrs.',' Saranda', 'Hermine', 'R ', '1972- 0725,19930423,9,615,3245505); INSERT INTO EMPLOYEE VALUES (116, Mr.' ' 'Smith', 'George', 'A', '1965- 1108,19881210,14,615,18902984)