SQL Database

Soundgood Music School

Database designed for the Soundgood Music School to store and keep track of scheduled classes, instruments and students.
Combined with a JDBC (Java-Database Connectivity) linking the database to a smaller interface command program.

• SQLDATABASE.sql refers to main database with tables and hardwired trigger functions.
• QUERIES.sql shows prewritten queries to retrieve certain sets of data from the database.
• historicaldatabase.sql extends the main database by implementing further tables for archiving older data.

The interface command program is a Java program constructed using Maven Build Tools that acts as an API for the database and utilizes the prewritten SQL queries along with insert and update operations of data.

Data Storage & Paradigms IV1351

This project was made for the course Data Storage & Paradigms IV1351 (held by prof. Carbone & prof. Lindbäck) and was created together with Elias Gaghlasian & Ammar Alzeno.