SQL Queries

Due: 11:00pm, Thursday, November 10, 2022

Assignment Description

The project7-handout directory contains a SQLite database file named grade_report.db that contains data about student grades. The following SQL data definition statement was used to create the table:

CREATE TABLE grade_report (
  student_id INTEGER,
  last_name TEXT,
  first_name TEXT,
  course TEXT,
  section TEXT,
  category TEXT,
  grade_item INTEGER,
  grade REAL
);

The values for some of the columns in the database are:

The project7-handout directory contains two more files: project7.sql that contains twenty questions about the data and answers.txt. The questions in the project7.sql file must be answered using SQL SELECT statements. The answers.txt is the expected result of running the project7.sql script.

Instructions

To start the assignment, login to your university Linux account and copy the assignment code to a location somewhere under your home directory. The assignment code is located at:

/export/home/public/schwesin/csc242/projects/project7-handout

You need to edit the project7.sql file. Do not change the names of the file.

The SQL script can be run on the database by executing the following command:

    sqlite3 grade_report.db < project7.sql

To submit your assignment, execute the following command from within your project7-handout directory:

    ~schwesin/bin/submit csc242 project7

Grading Criteria

Note: If the code has syntax errors or does not execute properly, you will receive a failing grade for this assignment. If the submission includes material that was not covered in class and the material is not properly cited, then you will receive a failing grade for his assignment.