DatabaseGradebook

Database group project (Kamryn, Gerald, Joëd)

Instructions:

Web

1. Visit the online SQL environment
2. Click the green "Run" button
3. Observe output of the code. If you'd like to comment out certain parts, feel free to do so and run accordingly.

Local

1. Clone this repository or download the database.sql file.
2. Execute the code using your SQL Engine. For example, run sqlite database.sql if your engine is SQLite.

Roles:

Gerald: Worked on code and slide show Kamryn: Worked on code and slide show Joed: Worked on Readme and slide show

Test Cases

1. If Student ID is less than 1000

• expected to add the padded 0 the the ID
• actuakky prints the absolute value of the number

2. Declaring SQL in the Schema Build

• expected to throw a build error
• actually throws a build erro

3. Queries that have undefined table names

• expected to throw an error
• actually throws an error