he goal is to design a relational database that allows Company X to track the data related to their projects. The details of the database are explained next.

Tables:

Clients: clients are individual people, so the table needs to have columns to keep track of personal data such as name and contact data $($address$,$ phone, and email$).$

Projects: Projects have a name, a starting date, a planned end date, and an actual end date. We also need information about the location $($address of the construction site$).$

Employees: This table keeps track of employees$$ personal information, such as name, contact $($address$,$ phone, and email$),$ and job title.

Jobs: this table simply keeps track of the kinds of jobs, and is the following:

JobCode

Description

J$01$

Structure

J$02$

Plumbing

J$03$

Electrical

J$04$

Heating and Ventilation

Assignments: For each assignment, we need to keep track of the start date and time and number of hours. We also need to know who performed the assignment, which project it is for, and the kind of job it consists of $($more on this below$).$

Do not forget that a primary key is necessary for every table.

Recall: $$The company charges its clients by billing the hours spent on each assignment. The hourly billing varies per assignment, and is independent of the project, employee, or job.$$ Which table should we put the $$Charge$/$hour