Need help designing a database using SQL Server Management Studio 18.6. The database is for a consulting company and the work they do for clients. Must be in 3rd Normal Form with all Primary and Foreign Keys labeled. The information the database design needs to have is as follows:

Services Offered (Database Administration, Web Development, Software Development)

Employee Name

Employee Address

Employee Hourly Pay Rate

Role Name (Database Administrator, Project Manager, Software Developer)

Role Level (1,2, 3, 4 --> 4 being the most Experienced/Senior Role)

Client name

Client address

Project name (a company/client can have multiple projects going on at the same time)

Project Start Date

Project End Date

Total Project Hours

Average Project Hourly Billing Rate

Employees Working On Project

Services Utilized On Project

If you could include a database diagram for all of this I would greatly appreciate it.

Here is some queries to better explain what the database should be able to perform:

1. Given a client show all the on-going projects.

2. Given a service show all the clients that have used or are using the service.

3. Given a project show the all services used, the employees working on the project, different roles being used, project start date and the agreed upon project end date.

4. Given an employee show all the project they have worked on and are currently working on and the clients they have worked on and are currently working on.

5. Given a role, show all the clients and the projects using that role.

6. For a Time period for example a month or a quarter Show all the clients and project information for the projects that have either started, on-going or have ended.