I need an answer for Q2 A)

It is located at the bottom of the page

Thank you.

aking tServiceProvided and tTechCost available to a new query and inserting the fields Level, MachinelD, and Minutes results in a query with the following number of rows: number of rows of tServicesProvided , number of rows of tTechCost . number of rows of tServiceProvided plus number of rows of tTechCost d. number of rows of tServiceProvided times the number of rows of tTechCost e. none of the above roblems 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 cars, 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 create some primary keys 2) Internal Control Weaknesses (12 points) For each the scenarios described below, identify 2 contrel procedures that could have prevented the problem, and explain why each of the controls would have helped. a) You manage a sales firm, and you give laptops to all salespeople. Salespeopleipt orders and submit them electronically while on the road. You have had a few problems with this system. In one instance, and order for S PC's was input by the salesperson as 500 PC's. 1 another case, the salesperson failed to input a delivery address