inting Information Systems Instructions: nower 40 multiple choice m contains mauired to answer able ... the answers on your questions and marl SCANTRON will ! Part I Part II. PROBLEMS (Pick Three out of Four) Part II TOTAL Consider the following tables in a relational database which are in t appropriate "SELECT" SQL I SOL statement pe underlined and foreign key fields have wen are in third normal form. Provide the atement necessary to answer the queries that follow. Primary keys are Part I. Choose th have an asterisk at the end of the field. A file can ha VENDORS (VENDOR-NO NAME, ADDRESS, BALANCE-OWED) primary ke nique ide PARTS (PART-NO, DESC, COLOR, WEIGHT, TOTAL-QUANTITY-ON-HAND, EOQ) mary k VENDOR-PART (VENDOR-NO,* PART-NO,* PRICE-OFFERED) tosit WAREHOUSES (WAREHOUSE-NO, NAME, LOCATION, CAPACITY) Required: PART-WAREHOUSE (PART-NO,* WAREHOUSE-NO,* QUANTITY-STORED) the purchases from this vendor. List the address of a vendor named Duck Danould and the location of warehouse(s) that stores DM SQL d. OOP e. VB - nsic 2. Find out which vendor(s) provides Parts that weigh more than 50 pounds. 11-1