Once you have created the ER diagram for Application 3, answer the questions below:

12. Modify the design to include a customer for a project. The consulting company has one customer per project, and wants to store a customer name, address, city, state, zip code, and phone numberfor each customer.

13. The consulting company wants to store an estimated total amount of time for each project. Where would that data be stored in your database?

14. The consulting company wants to store an estimated total amount of time that an employee will work on a project. Where would that data be stored in your database?

Application 3 This database will be used by a consulting company. An employee can work on many differe project may have many different employees assigned to a project. Each project is categorized "project type" that is stored in the system. The company has about 10 different project types tha When an employee joins a project, the system should store the date that the employee is assigne employee leaves a project, the system should store the date that the employee is released from the project. A sample list of the data to be stored for this application is provided below. nt projects, and a with one standaro t they track d. When an Date Employee ID Project Type Date Assigned Released Project Name A123Web Design for Hotel/Casino development A123Web Design for Hotel/Casino development FirstName LastName ProjectI Web-based systems 8/12/2018 7/12/2018 8/18/2018 9/12/2018 9/19/2018 7/12/2018 8/19/2018 100 Tiffany Springfield Web-based systems 200Steven Krautz Web-based systems development Web-based systems Inventory Control for 100 Tiffany Springfield A782 Logistics Company 300 Roberta ickham A123 Web Design for Hotel/Casino development Online learning evaluation for college Online learning evaluation 200Steven Krautz A912 Feasibility Analysis 9/5/2018 100 Tiffany Springfield A912 for college Feasibility Analysis 9/18/2018 6