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):
- 5 points per query