$1.$ Design a database to help a consulting organization keep track of employees, projects, and

customers.

For each employee, the organization keeps track of an EmployeeID $($primary key$),$ name, phone number,

and birthdate. For each project, the organization keeps track of a ProjectID $($primary key$),$ project name,

date that the project started, and date that the project is completed.

A project is contracted for by a customer of the consulting organization. For each customer, the

organization keeps track of the CustomerID $($primary key$),$ the name, address, and phone number. Each

project is contracted for by one and only one customer, but a customer may have multiple projects with

the consulting organization.

The organization keeps track of customers whether or not that customer has a current project with the

organization. Each project is managed by one and only one employee, but an employee can manage

more than one project. It is also possible that an employee does not manage any projects.

The organization also wants to keep track of employees assigned to work on projects. A project must

have at least one employee assigned to it$,$ but can have multiple employees assigned to it$.$ An employee

does not have to be assigned to a project, but can be assigned to multiple projects. The organization

wants to keep track of the date when an employee is initially assigned to work on a project, and the

dollar billing rate that the employee charges for a particular project. An employee's billing rate may be

different for each project that he$/$she is assigned to work on$.$