SQL

Due: 12:00pm (noon), Friday March 11, 2022

Description

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

CREATE TABLE report (
    id INTEGER,
    last_name TEXT,
    first_name TEXT,
    course TEXT,
    section TEXT,
    category TEXT,
    item INTEGER,
    grade REAL
);

The values for some of the columns in the database are: - id: unique student ID - course: CSC125, CSC135, CSC136, CSC223, CSC237, CSC242, CSC253 - section: 010, 020, 030 - category: exam, homework, project, quiz

There is also a file named queries.sql that contains twenty questions about the data. These questions must be answered using SQL SELECT statements.

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

.read queries.sql

from within the SQLite REPL when connected to the students.db database file.

Turning in the Assignment

For this assignment, you must turn in a zip file of a directory named assignment5 containing the queries.sql file. Submit the zip file to the appropriate folder on D2L.

Grading Criteria

Grading (out of 100 points):