Please turn in your SQL for these statements. [You can practice these in Oracle through SQL Developer or the command line. You can also use these in the SQL view in Access under the queries menu. –However, in Access some of the constraint commands do not work.]
Also note that Access provides a GUI interface so in practice, when using Access, you don’t type in the SQL commands. But, for this assignment, you will need to turn in the appropriate SQL commands.
Please use this file and enter your answers following the questions.
Use the following three tables for questions 1- 12:
EMPLOYEE (EmpNumber, Name, Email)
PROJECT (ProjectName, Description, StartDate, EndDate)
ASSIGNMENT (EmpNumber, ProjectName, TotalHoursWorked)
Assume that the relationship from EMPLOYEE to ASSIGNMENT is 1:N, M-O and that the relationship from PROJECT to ASSIGNMENT is 1:N, M-O.