Question: I want to make this table(the table above is called 'Assignment') in sql so I typed these kinds(below) of data types But I keep getting

I want to make this table(the table above isI want to make this table(the table above is called 'Assignment') in sql so I typed these kinds(below) of data types

I want to make this table(the table above is

I want to make this table(the table above is

But I keep getting errors when I try to make them.

So please tell me the correct way of making 'Asignment' table in SQL.

\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} CREATE TABLE ASSIGNMENT( ProjectIDEmployeeNumberHoursworkedIntIntNumeric(6,2)PRIMARYKEY,NULL,NULL, CONSTRAINT ASSIGN_PROJ_FK FOREIGN KEY(ProjectID) REFERENCES PROJECT(ProjectID), CONSTRAINT ASSIGN_EMP_FK FOREIGN KEY(EmployeeNumber) REFERENCES EMPLOYEE (EmployeeNumber) ) INSERT INTO ASSIGNMENT (ProjectID, EmployeeNumber, Hoursworked) VALUES \( \left(1000,1, \quad ' 30.00^{\prime} ight) \), \( \left(1000,6, \quad ' 50.0 \theta^{\prime} ight) \), \( \left(1000,10, \quad ' 50.00^{\prime} ight) \), (1000,16,175.00), \( \left(1000,17, \quad ' 75.00^{\prime} ight) \), \( \left(1100,1, \quad ' 30.0 \theta^{\prime} ight) \), (1100,6,75.00)

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!