search

siddhantkamra / music-management-system

DBMS Project
0 stars 0 forks source link

Task Tile #2

Open siddhantkamra opened 1 month ago

siddhantkamra commented 1 month ago

give a brief explanation of the whole project

codeautopilot[bot] commented 1 month ago

Ticket Title: Task Tile

Ticket Description:

Provide a brief explanation of the whole project.

Project Overview:

The Music Library Management System is a comprehensive application designed to manage and organize a music library efficiently. The system allows users to add, delete, and view songs and playlists through a user-friendly graphical user interface (GUI). Below is a brief explanation of the key components and functionalities of the project:

  1. Database Setup (backend.py & sqlUsed.sql):

    • The backend of the system is powered by a MySQL database, which is set up to store information about artists, albums, genres, and tracks.
    • The sqlUsed.sql file contains SQL scripts to create the necessary tables and log tables, along with triggers for insert, update, and delete operations. It also includes a stored procedure to handle track insertion with duplicate checking.

  2. Adding Songs (add.py):

    • Users can add new song records to the music library by providing details such as title, artist, album, genre, and release year.
    • The add.py script connects to the database, inserts the song details, and displays a success message upon completion.

  3. Deleting Songs (delete.py):

    • The system provides functionality to delete song records from the database using a GUI interface.

  4. Viewing Songs and Playlists (view.py, viewallsongs.py, viewedm.py, viewindie.py, viewplaylists.py, viewpop.py, viewrap.py):

    • Various scripts are available to display songs and playlists in the music library.
    • viewallsongs.py shows all songs in the database.
    • viewedm.py, viewindie.py, viewpop.py, and viewrap.py display songs from specific genres like Electronic Dance Music, Indie, Pop, and Rap, respectively.
    • viewplaylists.py provides buttons to view different curated playlists such as Electronic Dance Music, Ultimate Indie, Make Me Pop, and Chill Rap.

  5. Main GUI (main.py):

    • The main.py file creates the main graphical user interface for the Music Library Management System.
    • It integrates functionalities to add, delete, and view tracks, providing a seamless user experience.

Installation:

To set up the project, follow the installation instructions provided in the README.md file, which includes the necessary Python packages required for the system to function.

This project aims to offer a robust and user-friendly solution for managing a music library, making it easy for users to organize and access their music collection.