Question: I want to make this table above called 'assignment' in sql but I keep having errors when I try to make the tables These are
I want to make this table above called 'assignment' in sql
but I keep having errors when I try to make the tables


These are the data typed I wrote
the errors say that
'Msg 1767, Level 16, State 0, Line 36 Foreign key 'ASSIGN_PROJ_FK' references invalid table 'PROJECT'. Msg 1750, Level 16, State 1, Line 36 Could not create constraint or index. See previous errors.'
Please tell me how I can make the tables properly without errors
\begin{tabular}{lcc} ProjectID & EmployeeNumber & HoursWorked \\ \hline 1000 & 1 & 30.00 \\ 1000 & 6 & 50.00 \\ 1000 & 10 & 50.00 \\ 1000 & 16 & 75.00 \\ 1000 & 17 & 75.00 \\ 1100 & 1 & 30.00 \\ 1100 & 6 & 75.00 \end{tabular} INSERT INTO ASSIGNMENT (ProjectID, EmployeeNumber, HoursWorked) VALUES \( \left(1000,1, \quad ' 30.00^{\prime} ight) \), \( \left(1000,6, \quad ' 50.00^{\prime} ight) \), (1000,(1000,10,16,50.00), (1000,17,15.00), \( \left(1100,1, \quad ' 30.00^{\prime} ight) \)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
