Spring 2018 CS346 Testl L. Ghemri Student Name: avier Wn Winters T-Number: 0053 134e nswer all questions on test, use back if necessary. Scrap paper will not be graded. Show all steps to get partial credit. Return Cheat sheet if using. Exercise 1: For the following problem: You need to design database for managing the task assignment in a work order. A work order records a set of tasks requested by a customer at a specific location: A customer has a unique customer identifier, a name, a billing address (street, city, state and zip), and a collection of submitted work orders. .A work order has a unique work order number, a creation date, a date required, a completion date, a customer, an optional supervising employee, a work address (street, city, state and zip) and a set of tasks. Each task has a unique task identifier, a task name, an hourly rate, and estimated hours. A task can be performed on many work orders. Each task on a work order has a status (not started, in progress, or completed), actual hours and a completion date. 1) Draw the E-R diagram using the Crowfoot notation. Show the minimum and maximum 2) Based on your diagram from 1) describe the relationships that cannot be implemented using 3) Propose a new design that will resolve the issues found. cardinality for each relevant entity-entity relationship and determine the possible keys for each entity. the Relational Database model