Case Background

ALEK, located in Baltimore, Maryland, started in $2021$ after five high$-$level executives left their jobs at large consulting firms to start a small boutique firm. Now, after a few years, they expanded their business to meet the demand for their consulting services. The first batch of new consultants was hired in June $2022,$ and data was collected for their first three months of work $($June$,$ July, and August$).$ You were recruited as an intern for ALEK to create a database that tracks all information about their project work, clients, and employees.

ALEK$$s business model is built upon billable hours, which are the hours they can bill their corporate clients for work. Billable hours can either be through direct contact with the client or preparation hours, where the employee will work on a client project without the client present. Your database will keep track of billable hours and ignore the invoicing of clients for payment, which will be handled by the office administrator.

You will start by entering information about each corporate client to track the name of the company and the company contact. In addition to the company name, you will also need the company contact$$s first name, last name, office street address, city, state, zip code, work email, and work phone number. You also need information about the services that are offered to clients and their hourly rates. The five service types and hourly rates are Financial Planning for $$250/$hour$,$ Business Strategy for $$300/$hour$,$ Project Management for $$250/$hour$,$ Marketing for $$200/$hour$,$ and Technology for $$225/$hour$.$

Next, you will need to keep track of information for each consulting employee. You will need to know their first name, last name, years of service, home street address, city, state, zip code, work email, and work phone number. You$$ll also need to track the work of each employee, the company they worked for on each project, the start date of the work, the total number of contact hours, and the total number of preparation hours. Keep in mind that a client may need help with different services, so your database design should account for multiple services per project work request.

Instructions

Using the information in the background, determine the names of each table $($entities$)$ and the fields in each table $($attributes$).$ When designing the database, observe the following guidelines:

First, determine the tables you will need by listing the name of each table and the fields it should contain. Avoid data redundancy. Do not create a field if it can be created by a calculated field in a query.

Clients may need help with multiple services in a single work request, so your database design should account for this.

You must mark the appropriate Primary Key field$($s$)$ by entering an asterisk $(*)$ next to the field name and Foreign Key field$($s$)$ by entering two asterisk symbols $(**)$ next to the field name.

In the text box, write out the name of each of the tables and the fields required in each table in the format below.

Table $1$ Name: Field$\_1(*),$ Field$\_2,...$

Table $2$ Name: Field$\_1(*),$ Field$\_2,...$

Table $3$ Name: Field$\_1(*),$ Field$\_2,...$

And so on for all tables...