Data Manipulation

Due: 11:00pm, Thursday, December 7, 2023

Get the Assignment Code

Login to your university Unix account and copy the assignment code to a location under your home directory:

  cp -r /export/home/public/schwesin/csc256/assignments/project10 LOCATION

where LOCATION is a directory of your choosing.

Description

The project10 directory contains a file named project10.sql that contains comments describing the SQL statements that you must write. Note: make sure that all of your code is inside the transaction.

Turning in the Assignment

To turn in the assignment, execute the submit script by running the command

  make submit

from within the project10 directory.

Grading Criteria

• Correct implementation of the specification

• Style: a query must have the start of each clause at the beginning of a new line.

• If the code has syntax errors or does not execute properly, you will receive a failing grade for this assignment.