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 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
Get step-by-step solutions from verified subject matter experts
