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 calledI want to make this table above called 'assignment' in sql

but I keep having errors when I try to make the tables

I want to make this table above calledI want to make this table above called

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

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!