Skip to content

Latest commit

 

History

History
42 lines (31 loc) · 1.57 KB

README.md

File metadata and controls

42 lines (31 loc) · 1.57 KB
Raw

Music Studio Database Management System (MusicStudioDBMS)

This project aims to create a database management system for a music studio using Java and PostgreSQL. It includes tables and relationships to manage the studio's courses, customers, reservations, and payments.

Project Structure

  • sql/: Directory containing SQL files.
    • createdb.sql: Initializes the database schema and initial data.
    • musicstudio.sql: Defines the database schema specific to the music studio.
    • queries.sql: Contains sample queries.

Usage Guide

Cloning the Project

To clone the project to your local machine, use the following command:

git clone https://github.com/sancakerkan/MusicStudioDBMS.git

Setting Up the Database

  1. Install PostgreSQL: If not already installed, download and install the latest version of PostgreSQL.
  2. Create the Database: Use createdb.sql to create a new database in PostgreSQL and load initial data: 
    psql -U username -d database_name -a -f createdb.sql
  3. Load Database Schema and Sample Data: Use musicstudio.sql to load the music studio database schema and sample data: 
    psql -U username -d database_name -a -f musicstudio.sql
  4. Insert Sample Data: If needed, insert sample data using queries.sql. 
    psql -U username -d database -a -f queries.sql

Contributing

For any feedback, questions, or contributions, please use the issues section.

License

This project is licensed under the MIT License - see the LICENSE file for details.