Skip to content

A simple CD library management project using Python and MySQL

Notifications You must be signed in to change notification settings

Saiesh-Agre/CD-Library-Management-System

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 

Repository files navigation

CD-Library-Management-System A simple CD library management system to manage CDs and DVDs, made with Python. I have used PyQt5 for User Interface (GUI), MySQL as database to organize, store and retrieve data about CDs, Customers and Staff, and Twilio to send OTP. Other modules like subprocess, Tkinter, random and sys are used to support the application.

Technical Specifications
Minimum Hardware Requirements
-Intel Core i3 Processor -CPU T6670 @ 2.20 GHz
-Color CRT/TFT 15.5” Monitor
-64-bit Operating System
-4.00 GB Installed Memory (RAM) -500 GB DDR3/DDR4 Hard Disk

Minimum Software Requirements
-Python IDLE 3.5 or higher
-MySQL Server 5.0 or higher
-Windows 7 or higher or MacOS

User Characteristics The users are categorized as:
-Admin or Manager
Authorized to update, alter, change or modify Staff and Customer tables, and responsible for System Maintenance.
-Staff
Authorized to update, alter, change, or modify Movies, Music, Games, and Software tables. Do not have access to Staff’s or Customer’s personal details.
-Client
Authorized to access CD’s collection, and Buy them.

Additional Requirements:
-Libraries:
1. PyQt5
2. Twilio
3. Tkinter
-Databases:
1. MySQL database
-Accounts:
1. Requires Twilio API key.

Screenshot 2023-06-14 at 20 11 03

Screenshot 2023-06-14 at 20 11 46

Screenshot 2023-06-14 at 20 12 08

Screenshot 2023-06-14 at 20 12 35

About

A simple CD library management project using Python and MySQL

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published