13. Making tServiceProvided and tTechCost available to a new query and inserting the fields TechLevel, MachineID, and Minutes results in a query with the following number of tows: a number of rows of tServicesProvided b. number of rows of tTechCost c. number of rows of tServiceProvided plus number of rows of tTechCost d. number of rows of tServiceProvided times the mamber of rows of tTechCost e. none of the above Problems 1) Tables/Normalization (14 points) You are building a database for a shoe retailer in Corvallis. Create the database tables needed to store information about the following attributes: customer name, customer address, customer telephone, names of customers children, salesperson name, salesperson address, sales department (e-g, used ears, new cars, or leases), sales department phone, department in which a salesperson works (assume that each salesperson works in only one department), shoe model, shoe color, shoe sales price, sales date, shoes purchased by each customer. Clearly indicate all primary and foreign keys in your tables. You may need to crcale some primary keys 2) Internal Control Weaknesses (12 points) For each the scenarios described below, identify 2 control procedures that could have prevented problem, and explain why each of the controls would have helped a) You manage a sales firm, and you give laptops to all salespeople. Salespeople can input orders and submit them electronically while on the road. You have had a few problems wit this system. In one instance, and order for 5 PC's was input by the salesperson as 500 Pc another case, the salesperson failed to input a delivery addes