Assignment 4 Download Assignment 4 provides experience with the formulation of advanced matching problems involving the outer join operator, difference operator, and nested queries in Chapter 9. Assignment 4 also contains problems involving the CREATE VIEW statement and SELECT statements that use views from Chapter 10. You should use the populated tables from assignment 1. In the attachment, you will find a clean version of the CREATE statements, send a message to me.
To facilitate grading, please number the SQL statements and format them neatly. Show the SQL statement for each problem. Each SQL statement should be in text format so that it can be copied to the Query Editor. Generate a screen snapshot for each statement to demonstrate execution. The snapshot should show some or all rows. All statements and snapshots should be in a single file. Name your file as “LastNameFirstNameA4.docx” where LastName and FirstName are your last and first name, respectively.
0 comments