I need an answer for Q2 A) It is located at the bottom of the page Thank you. ak

Question

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.

Explanation / Answer

Segregation of duties is one of the efficient internal control. Segregation of duties help to avoid frauds occur and avoid internal failures or mistakes taken place. If segregation of duties will verify the work done by another person. In the given sales person is in a posotion to enter input also. So many mistakes will happen because of the nature of work like input while on going on the roads. If segregation happens can prevent these type of mistakes and resembles effective internal control

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.