write Basic Access SQL commands

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.

Skills: Database Programming, Microsoft Access, Oracle, SQL

See more: practice oracle sql, need sql developer, need of sql developer, sql bulk insert write text file, sql server read write database file, visual basic script read write xml file, convert access database sql visual basic, write xml file sql aspnet, access visual basic create xml file, read write excel file visual basic, write xml file access, excel visual basic write xml file, convert text file html vba sql access

About the Employer:
( 14 reviews ) kennesaw, United States

Project ID: #9862653

Awarded to:


Hello, My self [login to view URL] Baraiya working as a Software Developer. Provide IT services: - SQL, SQLite, MySQL, MS Access Database developments - Static website - web Portals on ASP.NET C# - Windows Software C#.NE More

$30 USD in 1 day
(16 Reviews)

2 freelancers are bidding on average $40 for this job

$50 USD in 1 day
(16 Reviews)