Python Tkinter GUI Mysql
$30-250 USD
Paid on delivery
PROGRAM FOR HANDLING A SYSTEM FOR EXAMS
TKINTER GUI MUST BE USED + CONNECTION TO MYSQL FOR THE DATABASE
The program should be connected to the database (mysql) through: [login to view URL](host='localhost', port=3306, user='Eksamenssjef', passwd='oblig2020', db='oblig2020')
The program should be based and designed through the t-kinter and grid (geometry manager).
The dates should be registered as <year-month-day>, example. 20190510 for 10.05.2019.
New students that are registered should be numbered. BUT autoincrement should NOT be used in the database.
an exam in one/specific subject can be completed only in ONE room.
THE DATABASE PART
Table Structure of the Database - The database is called 'oblig2020':
Student(Studentnr, FirstName, Surname, Email, PhoneNumber)
Subject (SubjectCode, Subjectname, Points)
Room (Roomnr, NumberofPlaces)
Exam (SubjectCode*, Date, Roomnr*)
ExamResult (Studentnr*, SubjectCode*, Date*, Grade)
Studentnr CHAR(6)
FirstName CHAR(30)
SurnameCHAR(20)
Email CHAR(40)
PhoneNumber CHAR(8)
SubjectCode CHAR(8)
SubjectNameCHAR(40)
Points DECIMAL(3,1)
Roomnr CHAR(4)
NumberofPlaces INTEGER(3)
Date DATE
Grade CHAR(1)
THE TASK OF THE PROGRAM
The application should be able to add, update, and delete students, exam, and examresults.
Furthermore the application should be able to:
add, update and delete future exams and be able to control that one room is set up for ONLY one exam per day.
print out/show all exams on a particular day, with information of subject and room.
print out/show all exams in a particular period, ordered after DATE with information on which subject and room.
Register a grade for an exam that took place.
print out/show all EXAMRESULTS in a subject ("grade list"), in other words a list of students with grades that are ordered by student number.
print out/show grade statistics for a completed exam in a subject with all the subject information and a count of how many candidates got which grade on the exam.
print out/show all EXAMRESULTS with subjectname and how many points that each student has(with that a student can have one or more examresults in one particular subject), ordered by an exam date.
Project ID: #24728070
About the project
24 freelancers are bidding on average $217 for this job
Hello, I am a software and Web Developer. I hava also lot of experience in Designing. I have some rules and regulations before start of project: 1. Provide 100% work within deadline. 2. Provide unlimited revisions un More
Hi I am a very experienced statistician, data scientist and developer. I have vast experience in data modelling, model building and providing data driven business solutions. I have worked with data from several compani More
Hi dear client, i had seen your job post in freelancer.com it's well explained. Can you please share your entire idea or reference url for your requirements if any you have, so I can take a look on it and I will h More
Hi there, Already worked with it. Please send me your email so i can send you examples. Looking forward to it. Regards
I can get this done in 3 days i have compelted a similar code with PyQt . Awaiting your reply ................
Greetings, I hope you are in good health. I have read the requirements for this project in details and after reviewing them i am confident that i can make this software for you using PYTHON, MYSQL and for GUI Tkin More
Hi! I am an expert in python. I have great experience in tkinter and MySql as well. I can easily do this project for you! Kindly message me via chat to discuss further details. Thank you!
Dear Customer Greetings for the day!!! I am Agnesh Arya an experienced .professional with 10+ years of experience and based in India. I have seen your requirement and i am completely okay with mentioned details a More
Hi, I already have a similar application made. I used python with Tkinter and connected it to MYSQL just as you pointed. Br, Valent
Hi, I am a professional python programmer just started a new career in freelancing. Using python for 6 years for web developing. I can complete your work in a very short period of time and in a good manner as well. You More
Hi. I would be happy to help you with your project. Just recently I programmed a very similar project, using python, tkinter and MySQL, for another student. So therefore I think I would be the perfect fit for it.
Hello Sir, My name is Waleed and I'm expert in field of programming. I had done a similar project for educational academy, and I'd like to work in your project. I read all the needed features in your app, and you will More
Hi! My name is Fernando Téllez. I am a senior year student of electrical engineering at Universidad Simón Bolívar (USB), one of the most prestigious universities in my country (Ranked 34° at the QS University Rankings: More
The price is below average bid, But I promise you a quality work with in given time code will be simple and can be easily editable if required