Music Store Management System

This Python script creates and manages a music store database. It allows users to add, search, modify, and delete customer and music records.

Features

1. Creates a database named "python" with two tables: "customer_details" and "music".
2. Manages customer details including code, name, phone number, issue date, and return date.
3. Manages music details including code, name, artist, genre, release year, price, and quantity.
4. Provides functionalities for adding, searching, modifying, and deleting customer and music records.

Requirements

• Python 3.x
• mysql.connector library (you can install it using pip install mysql-connector-python)

Installation

• Make sure you have Python 3 and mysql.connector installed.
• Save the script as music_store.py.

Usage

1. Run the script from your terminal: python music_store.py
2. The script will prompt you to choose an action from a menu.
3. Follow the on-screen instructions to add, search, modify, or delete customer and music records.