Entertainment-Rating-Database-ERDb

所属分类:数据库系统
开发工具:Others
文件大小:0KB
下载次数:0
上传日期:2023-08-29 17:46:56
上 传 者sh-1993
说明:  一种娱乐评分数据库管理系统,使用Python作为前端,MySQL作为后端来管理数据库。,
(An Entertainment Rating Database Management System developed using Python as front-end and MySQL at the backend for managing the database.,)

文件列表:
.idea/ (0, 2023-08-30)
.idea/CS Project.iml (284, 2023-08-30)
.idea/dbnavigator.xml (22502, 2023-08-30)
.idea/inspectionProfiles/ (0, 2023-08-30)
.idea/inspectionProfiles/profiles_settings.xml (174, 2023-08-30)
.idea/misc.xml (185, 2023-08-30)
.idea/modules.xml (272, 2023-08-30)
Extras/ (0, 2023-08-30)
Extras/image(3).png (64276, 2023-08-30)
Extras/logoblack.png (64109, 2023-08-30)
Extras/logowhite.png (58741, 2023-08-30)
Extras/mysql connector.png (214405, 2023-08-30)
Extras/tabulate module.png (11933, 2023-08-30)
How to Install MySQL Connector and tabulate module using pip.txt (731, 2023-08-30)
MySQL Prerequisites/ (0, 2023-08-30)
MySQL Prerequisites/CS Project Tables.xlsx (23058, 2023-08-30)
MySQL Prerequisites/SQL Commands.txt (6683, 2023-08-30)
MySQL Prerequisites/~$CS Project Tables.xlsx (165, 2023-08-30)
Prerequisites.txt (504, 2023-08-30)
Python Programs/ (0, 2023-08-30)
Python Programs/Display.py (1712, 2023-08-30)
Python Programs/ERDB final.py (30825, 2023-08-30)
Python Programs/LOGO.png (60115, 2023-08-30)
Python Programs/Search.py (6775, 2023-08-30)
Python Programs/Update.py (6356, 2023-08-30)
What is ERDb.txt (844, 2023-08-30)

# ERDb - Entertainment Rating Database ![alt text](https://github.com/anujeshify/Entertainment-Rating-Database-ERDb/blob/master/Extras/logowhite.png) This software project is developed to automate the functionalities of a ENTERTAINMENT RATING MANAGEMENT SYSTEM. The name of this database is ERDb which stands for Entertainment Rating Database. The purpose of the software project is to develop the Management Information System (MIS) to automate the record keeping of ratings and other details of Movies, Television Shows, Games and Anime with a view to enhance the decision making of the functionaries. This software, being simple in design and working, does not require much of training to users, and can be used as a powerful tool for automating an ENTERTAINMENT RATING DATABASE MANAGEMENT SYSTEM. During coding and design of the software Project, Python IDLE, as a powerful front-end tool is used for getting coding simplicity. As a back-end a powerful, open source RDBMS, MySQL is used. ## Getting Started These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. ### Prerequisites This software project is developed with the help of certain programs and some prerequisite python modules which facilitate the working of the program and make it presentable. The Softwares used: Microsoft Windows 10 Pro as Operating System. Python 3.8.5 as Front-end Development environment. MySQL as Back-end Sever with Database for Testing. Mysql.Connector to connect Python module with database. Tabulate module to present tuples fetched from database into tables in python. ### Installing I have used mysql.connector and tabulate modules in our python code. Mysql.connector module helps establishing connectivity between python and MySQL. Tabulate module helps us to present tabular data in a nicely formatted table in python. Following are the steps to install both the modules. Steps to Install mysql.connector module ``` Step - 1 : Open command prompt from Start Step - 2 : Enter command “python -m pip install –upgrade” Step - 3 : Enter command “install mysql.connector” ``` ![alt text](https://github.com/anujeshify/Entertainment-Rating-Database-ERDb/blob/master/Extras/mysql%20connector.png) Installing tabulate module ``` Step – 1 : Open command prompt from Start. Step – 2 : Enter command “pip install tabulate”. ``` ![alt text](https://github.com/anujeshify/Entertainment-Rating-Database-ERDb/blob/master/Extras/tabulate%20module.png) NOTE: You must have an active internet connection while downloading the prerequisites. ## Built With * [Python](https://www.python.org/doc/) - Front-End Application * [MySQL](https://dev.mysql.com/doc/) - Database Management ## Authors * **Anujesh Bansal** - *Initial work* - [anujeshify](https://github.com/anujeshify) * **Shaurya Jain** See also the list of [contributors](https://github.com/anujeshify/Entertainment-Rating-Database-ERDb/graphs/contributors) who participated in this project. ## Acknowledgments * Inspiration - I was inspired by the online database site named IMDb, which stores information related to films and tv shows.

近期下载者

相关文件


收藏者