For this homework assignment you will create an Entity Relationship model for a business case and then convert the model to a set of relations. Questions 2, 3, and 4 need to be on separate pages. (points will be taken off otherwise) 1) Read through the following business case for the "Custom Cabinet Company" 2) Create an Entity relationship model diagram with the necessary entities, attributes, identifiers, and relationships to capture the data. - All relationships should be labeled with verb phrases. - Use UML notation for this work. (See this tutorial) - Relationship lines should be straight and should not cross. 3) On a new page write ot two "relationship sentences" for each relationship using the format: 4) Once your ER model is completed, on a new page convert the ER model to a set of Relations. - Clearly indicate a key (key) and any foreign keys (fk) for each Relation. Each relation should only be shown one time. This is an individual assignment. Collaboration or copying of another student's work is not permitted. The Custom Cabinet Company The Custom Cabinet Company is creating a database to track the workflow of orders and The Custom Cabinet Company is creating a database to track the workflow of orders and projects. Customers will be able to sign up and provide their contact information (First name, Last name, Address, Phone number, e-mail). Customer orders will be separated into two types. The first choice is ordering custom cabinets by giving the measurements to the company and picking up the cabinets after they are completed. The second-choice customers have is scheduling a measurement and having the company install the custom cabinets. The company has a factory that creates custom cabinets based on customer cabinet preferences, i.e. (length width, height, color, style). The custom cabinet company has a branch with staff that processes customer orders and schedules a company representative to get cabinet measurements at the customer's address. After measurements are taken, project managers at the company ensure custom cabinet projects are completed and installed. Project managers supervise the contractors that will install cabinets and complete the project. Project managers can supervise multiple job's but each project will have one project manager. Each project/ task will have an assigned start date and an expected completion date, the approximate number of working hours required, a description of the work to be done, and a quantity of cabinets. Finally, there should be a way to indicate the next task to be done once the current task is completed (hint, a status attribute)