Question 13 (5 points) Select the line that accurate describes the following Table Text definition: MYTABLE (FIELD1, FIELD2, FIELD3, FIELD4) The table is named MYTABLE, there are four attributes, FIELD2 is a Foreign Key, and FIELD3 is the Primary Key. The table is named MY, there are four attributes, FIELD1 is a Primary Key, and FIELD2 is the Foreign Key. The table is named MYTABLE, there are four attributes, FIELD1 is a Primary Key, and FIELD2 is the Foreign Key. The table is named MYTABLE, there are two attributes, FIELD1 is a Primary Key, and FIELD2 is the Foreign Key. Question 14 (10 points) Referencing the Wedgewood Products ERD document select ALL the working commands that would display the employee's information including their OfficePhone that work for a Supervisor value of 4 : SELECT FROM EMPLOYEE WHERE Supervisor = 'Four'; SELECT FROM EMPLOYEE WHERE Supervisor =4; None of these commands will meet the requirements of the question. SELECT FirstName, LastName WHERE Supervisor = 4; SELECT FirstName, LastName WHERE Supervisor ==4 Referencing the Wedgewood Products ERD document select ALL the working commands that would insert a row in the PROJECT table (you should assume the department of Engineering is already a valid entry in the DEPARTMENT table and the order of the attributes listed in the ERD matches the database): INSERT INTO PROJECT (2000, 'Engineering' , 'New Project' , 150.125, '01/01/2021', '01/01/2022'); INSERT INTO PROJECT (ProjectID , ProjectName, Department, MaxHours, StartDate, EndDate) VALUES (2000, 'Engineering' , 'New Project' , 150.125, '01/01/2021', '01/01/2022'); SELECT (2000 , 'Engineering' , 'New Project' , 150.125 , '01/01/2021', '01/01/2022') INSERT INTO PROJECT; INSERT INTO PROJECT (2000, 'Engineering' , 'New Project' , 150.125, '01/01/2021'); None of these commands will meet the requirements of the question. Question 16 (10 points) Referencing the Wedgewood Products ERD document select ALL the working commands that would display only the employees names: None of these commands will meet the requirements of the question. SELECT FROM EMPLOYEE; SELECT FirstName + LastName FROM EMPLOYEE; SELECT FirstName, LastName FROM EMPLOYEE; SELECT EMPLOYEE.FirstName, EMPLOYEE.LastName; Referencing the Wedgewood Products ERD document select ALL the working commands that would display only the Assignments for the Projects with the following IDs: 1200,1300 , and 1400 (you should assume that ProjectID starts at 1000 and goes up by increments of 100). SELECT EmployeeNumber, ProjectID, MaxHours FROM ASSIGNMENT WHERE ProjectID > =1200; SELECT FROM ASSIGNMENTS WHERE ProjectID IN (1200, 1300, 1400); None of these commands will meet the requirements of the question. SELECT FROM ASSIGNMENTS WHERE ProjectID > > 1200 ; SELECT FROM ASSIGNMENT WHERE ProjectID IN (1200,1300,1400); Question 18 (10 points) Referencing the Wedgewood Products ERD document select ALL the working commands that would insert a row in the DEPARTMENT table (you should assume the order of the attributes listed in the ERD matches the database): INSERT INTO DEPARTMENT ('Engineering' , 'BD-12' , 'OF-12'); SELECT 'Engineering' , 'BD-12' , 'OF-12', '123-456-7890' INSERT INTO DEPARTMENT; None of these commands will meet the requirements of the question. SELECT 'Engineering' , 'BD-12' , 'OF-12' , '(123) 456-7890' INTO DEPARTMENT; INSERT INTO DEPARTMENT (OfficeNumber, DepartmentPhone, DepartmentName, BudgetCode) VALUES ('OF-12' , '123-456-7890', 'Engineering','BD-12'); Question 13 (5 points) Select the line that accurate describes the following Table Text definition: MYTABLE (FIELD1, FIELD2, FIELD3, FIELD4) The table is named MYTABLE, there are four attributes, FIELD2 is a Foreign Key, and FIELD3 is the Primary Key. The table is named MY, there are four attributes, FIELD1 is a Primary Key, and FIELD2 is the Foreign Key. The table is named MYTABLE, there are four attributes, FIELD1 is a Primary Key, and FIELD2 is the Foreign Key. The table is named MYTABLE, there are two attributes, FIELD1 is a Primary Key, and FIELD2 is the Foreign Key. Question 14 (10 points) Referencing the Wedgewood Products ERD document select ALL the working commands that would display the employee's information including their OfficePhone that work for a Supervisor value of 4 : SELECT FROM EMPLOYEE WHERE Supervisor = 'Four'; SELECT FROM EMPLOYEE WHERE Supervisor =4; None of these commands will meet the requirements of the question. SELECT FirstName, LastName WHERE Supervisor = 4; SELECT FirstName, LastName WHERE Supervisor ==4 Referencing the Wedgewood Products ERD document select ALL the working commands that would insert a row in the PROJECT table (you should assume the department of Engineering is already a valid entry in the DEPARTMENT table and the order of the attributes listed in the ERD matches the database): INSERT INTO PROJECT (2000, 'Engineering' , 'New Project' , 150.125, '01/01/2021', '01/01/2022'); INSERT INTO PROJECT (ProjectID , ProjectName, Department, MaxHours, StartDate, EndDate) VALUES (2000, 'Engineering' , 'New Project' , 150.125, '01/01/2021', '01/01/2022'); SELECT (2000 , 'Engineering' , 'New Project' , 150.125 , '01/01/2021', '01/01/2022') INSERT INTO PROJECT; INSERT INTO PROJECT (2000, 'Engineering' , 'New Project' , 150.125, '01/01/2021'); None of these commands will meet the requirements of the question. Question 16 (10 points) Referencing the Wedgewood Products ERD document select ALL the working commands that would display only the employees names: None of these commands will meet the requirements of the question. SELECT FROM EMPLOYEE; SELECT FirstName + LastName FROM EMPLOYEE; SELECT FirstName, LastName FROM EMPLOYEE; SELECT EMPLOYEE.FirstName, EMPLOYEE.LastName; Referencing the Wedgewood Products ERD document select ALL the working commands that would display only the Assignments for the Projects with the following IDs: 1200,1300 , and 1400 (you should assume that ProjectID starts at 1000 and goes up by increments of 100). SELECT EmployeeNumber, ProjectID, MaxHours FROM ASSIGNMENT WHERE ProjectID > =1200; SELECT FROM ASSIGNMENTS WHERE ProjectID IN (1200, 1300, 1400); None of these commands will meet the requirements of the question. SELECT FROM ASSIGNMENTS WHERE ProjectID > > 1200 ; SELECT FROM ASSIGNMENT WHERE ProjectID IN (1200,1300,1400); Question 18 (10 points) Referencing the Wedgewood Products ERD document select ALL the working commands that would insert a row in the DEPARTMENT table (you should assume the order of the attributes listed in the ERD matches the database): INSERT INTO DEPARTMENT ('Engineering' , 'BD-12' , 'OF-12'); SELECT 'Engineering' , 'BD-12' , 'OF-12', '123-456-7890' INSERT INTO DEPARTMENT; None of these commands will meet the requirements of the question. SELECT 'Engineering' , 'BD-12' , 'OF-12' , '(123) 456-7890' INTO DEPARTMENT; INSERT INTO DEPARTMENT (OfficeNumber, DepartmentPhone, DepartmentName, BudgetCode) VALUES ('OF-12' , '123-456-7890', 'Engineering','BD-12')