Question: The first two datas at the top The top two datas at the top(datas with employee number) are data called 'Employee' and the data at

The first two datas at the top The top two datasThe first two datas at the top The top two datas

The first two datas at the topThe first two datas at the top The top two datas

The top two datas at the top(datas with employee number) are data called 'Employee' and the data at the bottom is called 'Project'.

I have to use SQL code to INSERT the data in each table.

So please tell me the data type of both of the tables, and how I should insert data in each table.

\begin{tabular}{llllll} \hline ProjectID & ProjectName & Department & MaxHours & StartDate & EndDate \\ \hline 1000 & 2019 Q3 Production Plan & Production & 100.00 & 05/10/19 & 06/15/19 \\ 1100 & 2019 Q3 Marketing Plan & Sales and Marketing & 135.00 & 05/10/19 & 06/15/19 \\ 1200 & 2019 Q3 Portfolio Analysis & Finance & 120.00 & 07/05/19 & 07/25/19 \\ 1300 & 2019 Q3 Tax Preparation & Accounting & 145.00 & 08/10/19 & 10/15/19 \\ 1400 & 2019 Q4 Production Plan & Production & 100.00 & 08/10/19 & 09/15/19 \\ 1500 & 2019 Q4 Marketing Plan & Sales and Marketing & 135.00 & 08/10/19 & 09/15/19 \\ 1600 & 2019 Q4 Portfolio Analysis & Finance & 140.00 & 10/05/19 & \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!