Time-Table-Management-System-for-educational-institutes

#Front-End: Python, Back-End: Ms SQL In this project, I've designed a scheduling system with the help of Python and Ms SQL. With python, I've created a GUI from where user can enter data and the data will be stored in Ms SQL. Features include:

1. Inserting data through python based GUI data-fields
2. storing the data in Ms SQL database table
3. modify or delete data from that table
4. share the database table to the recipients if required via python email system.

Designing GUI

To design the GUI window, we need certain libraries:

1. tkinter: to design the GUI window
2. pillow: to set background image for the GUI window

Database Connectivity

To connect Ms SQL, we need:

1. pyodbc: to establish connection with Ms SQL
2. provide the exact database name to create table under that specific database

import pymysql to establish connection with MySQL

Establish Email Connection

1. import the library smtplib

Here I have imported email IDs from an excel file. For reading excel file, we have imported pandas library.

Output

Results of some features are shown below:

1. Inserting data
2. Database output
3. Shared the excel format of the MsSQL table via email
4. Video output of some features of this project

video.representation.mp4