Soundgood Music School Database Development Project

Course and Project Overview

This repository documents the development of Soundgood Music School's database, as part of the Data Storage Paradigms (IV1351) course offered by KTH. The project involves three key tasks: designing a conceptual model, transitioning to a logical and physical model, and implementing SQL queries for analysis and reporting.

Task 1: Conceptual Model

• Objective: Create a conceptual model based on the organization's needs.
• Deliverables: Conceptual_Model.pdf

Task 2: Logical and Physical Model

• Objective: Convert the conceptual model into a logical and physical model for database creation.
• Deliverables: Logical_Model.pdf, data.sql, sms.sql

Task 3: SQL

• Objective: Develop SQL queries for Online Analytical Processing (OLAP).
• Deliverables: SQL.pdf, data.sql, SMS.sql, query_*.sql

The project showcases the process of database design, from conceptualization and physical implementation to SQL query development for data analysis.