Project-TV-DBMS

A TV (Service and Request) Database management system created by interfacing of MySQL and Python, with Tkinter GUI

Working-Demo

https://youtu.be/dzzsTXV2qYA

Requirements

python(3.8 and above), mySQL server version 5.7.34, pip (21.2.1 and above), mysql-connector python (8.0.26), tkinter, clipboard, functools

Features

1. Search user data with serial number of device
2. Update, Add, Delete or Edit user data
3. Check active requests
4. Update, Add, Delete, Escalate or Edit requests
5. Generate EMail text for feedback or service requests
6. Check service centre details and available technicians