Description This project "Soundgood Music School" on KTH-Data Storage Paradigms(IV1351). The purpose is to facilitate information handling and business transactions for the Soundgood music school company, by developing a database which handles all the school's data and also an application that can handle some of the transactions.

• SQL
• JAVA

This tools was helpeing to built this project.You can download them from here:

• Visual Studio
• SQL Shell(psql) 'terminal'
• PostgresSQL
• PgAdmin 4
• Lucidchart
• Astah

We used Eclipse to build a Maven-project and connected a database with JAVA using JDBC.

You need to add the JDBC file to your project on Eclipse.You can download them from here:

• JDBC
• Eclipse
• Maven

PostgreSQL JDBC Driver Postgresql JDBC

1. Clone this git repository. git clone https://github.com/mhaao/Soundgood-Music-School.git
2. Change to the newly created directory cd soundgood-music-school. cd "soundgood-music-school"
   1. Change the url to match your database. You can find that in <SchoolDAO>
3. Create a database that can be reached with postgres database.sql and insert.sql. That all tables and data you need to a database called soundgood-music-school.
4. Build the project with the command mvn install
5. Run the program with the command mvn exec:java

• help displays all commands.
• list lists all instruments that are available to rent. The listing shall show brand and price for each listed instrument.
• ensembles List all ensembles held during the next week. For each ensemble tell whether it's full booked.
• rent Shows the all rented and terminate instruments.
• rent <student_id> <instrument_id> Student can rent specify instrument. Remember that a student is not allowed to rent more than two instruments at the same time.
• terminate <student_id> <instrument_id> Terminate an ongoing rental.
• quit quits the application.

• Murtadha Alobaidi mhaao@kth.se
• Abdullah Trabulsiah abdtra@kth.se