please make answer a copiable file not image.

Scenario As a data analyst, you are now working with a group of database developers to design a database for a business consulting firm. You have investigated key business activities of the consulting firm and collected the key business requirements for the database. Based on the following business requirements, develop a data model by completing the tasks from 1. to 4. below. [Business Requirements] A database is required to keep track of all consultants, projects assigned, and client companies. Every consultant has a unique number assigned by the firm and is required to store his or her name and date of birth. Each consultant is given a job title (e.g., assistant consultant, senior consultant, etc.) and a consultant does only one type of job at any given time. A consultant can work on many projects, and the hourly rate of each consultant may vary over different projects. Also, there are different minimum work hours assigned to each consultant for each project Projects are distinguished by project numbers, and we must store the contract amount, the estimated cost of each project, its start date and expected completion date. Each project is launched for a single client company. We want to keep track of the client company's name, size, industry, and year of establishment [Database Design) Based on the business requirements above, complete the following tasks: 1. (30 points) Prepare business rules and identify ERD Constructs. State any assumptions you believe you have to make in order to complete database design. Also, think of extra entities that you think the consulting company may need to add to the database, and add one entity of your choice in the data model. Of course, the extra entity of your choice should have some attributes and should be linked to at least one other entity. Scenario As a data analyst, you are now working with a group of database developers to design a database for a business consulting firm. You have investigated key business activities of the consulting firm and collected the key business requirements for the database. Based on the following business requirements, develop a data model by completing the tasks from 1. to 4. below. [Business Requirements] A database is required to keep track of all consultants, projects assigned, and client companies. Every consultant has a unique number assigned by the firm and is required to store his or her name and date of birth. Each consultant is given a job title (e.g., assistant consultant, senior consultant, etc.) and a consultant does only one type of job at any given time. A consultant can work on many projects, and the hourly rate of each consultant may vary over different projects. Also, there are different minimum work hours assigned to each consultant for each project Projects are distinguished by project numbers, and we must store the contract amount, the estimated cost of each project, its start date and expected completion date. Each project is launched for a single client company. We want to keep track of the client company's name, size, industry, and year of establishment [Database Design) Based on the business requirements above, complete the following tasks: 1. (30 points) Prepare business rules and identify ERD Constructs. State any assumptions you believe you have to make in order to complete database design. Also, think of extra entities that you think the consulting company may need to add to the database, and add one entity of your choice in the data model. Of course, the extra entity of your choice should have some attributes and should be linked to at least one other entity