🌶️ Chillify DataBase Project

A comprehensive database schema design for a music platform.

🎵 The Story Behind Chillify

What started as a simple database class project was meant to be built quickly using Python and React. This project marked my first encounter with React (and HeroUI) – and while the initial attempts weren't exactly smooth sailing, I managed to grasp the framework in just a few days. The irony wasn't lost on me: building a platform called "Chillify" while being anything but chill about those looming deadlines.

We didn't give up and decided to reuse this project in the Database Lab project. This time, I focused on designing a robust and efficient database schema using MySQL Workbench.

The result? A fully functional music platform database schema.

just for fun and learning :)

📚 Repository Overview

• master - Database Lab Project
• dd392e2 - Database 1 Course Project

⚠️ Warning: The project was completely rebooted after commit dd392e2. The first version is no longer supported or maintained. If you need access to the original implementation, checkout to that specific commit at your own risk.

📁 Project Structure

├── diagram/
│   └── diagram.dbml       # Database diagram (DBML format)
│   └── diagram.png        # Database diagram (PNG format)
├── scripts/
│   ├── tables.sql         # Table definitions
│   ├── procedures.sql     # Stored procedures
│   ├── views.sql          # Database views
│   ├── functions.sql      # Custom functions
│   └── data.sql           # Sample data
├── Dockerfile             # Docker configuration
├── LICENSE
└── README.md

🚀 Getting Started

Prerequisites

• Docker installed on your machine
• Sql Server Management Studio (SSMS) or any SQL client to connect to the database

Running with Docker

1. Clone the repository

   git clone https://github.com/Mr-MRF-Dev/Chillify-DataBase-Project.git
   cd Chillify-DataBase-Project

2. Build the Docker image

   docker build -t chillify-db .

3. Run the container

   docker run -d -p 1433:1433 --name chillify-database chillify-db

4. Connect to the database

   • Server: localhost,1433
   • Username: sa
   • Password: Admin@Pass
   • Database: Chillify

📜 Database Scripts

The database is automatically initialized with the following scripts (in order):

• tables.sql - Creates all database tables
• procedures.sql - Sets up stored procedures
• views.sql - Creates database views
• functions.sql - Defines custom functions
• data.sql - Populates initial data

📊 Database Structure

The Chillify database schema includes:

• User Management - User accounts, profiles, and authentication
• Music Library - Songs, albums, artists, and genres
• Playlists - User-created playlists and favorites

🛠️ Technologies Used

• Database: Microsoft SQL Server 2022
• Containerization: Docker
• Design Tool: MySQL Workbench (for schema design)
• Diagram Format: DBML (Database Markup Language)
• Scripting: SQL
• Version Control: Git & GitHub
• Diagram Visualization: dbdiagram.com

🤝 Contributing

We welcome any contributions you may have. If you're interested in helping out, please fork the repository and create an Issue or Pull Request. We'll be happy to review your contributions.

📝 License

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