Python Tkinter GUI Mysql

Closed Posted 3 years ago Paid on delivery
Closed 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.

MySQL Python Graphical User Interface (GUI)

Project ID: #24728070

About the project

24 proposals Remote project Active 3 years ago

24 freelancers are bidding on average $217 for this job

popularcontent12

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

$150 USD in 2 days
(21 Reviews)
4.4
slavaYar

Hello. Thanks for your job 'Python Tkinter GUI Mysql'. I am a professional developer for you and your project. I have valuable strong experience with python, mysql, tkinter as you expected and already completed many pr More

$150 USD in 3 days
(1 Review)
3.9
suyashdhoot

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

$1000 USD in 7 days
(23 Reviews)
5.7
kanwarrajani

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

$250 USD in 3 days
(3 Reviews)
3.1
fpirzada

Hi there, Already worked with it. Please send me your email so i can send you examples. Looking forward to it. Regards

$150 USD in 7 days
(8 Reviews)
2.9
ambajiinfotech

I can get this done in 3 days i have compelted a similar code with PyQt . Awaiting your reply ................

$140 USD in 3 days
(2 Reviews)
2.0
lazygeek2k18

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

$100 USD in 7 days
(6 Reviews)
1.5
UsamaEjaz0

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!

$80 USD in 10 days
(4 Reviews)
1.8
palaknusystech

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

$140 USD in 7 days
(0 Reviews)
0.0
uzoubah

Hello, I have created business inventory systems using Python GUI with Tkinter, MySQL and PostgreSQL backends. Your project is with MySQL backend, I get that. I am a data developer. I can build and maintain (if d More

$250 USD in 14 days
(0 Reviews)
0.0
valentalent

Hi, I already have a similar application made. I used python with Tkinter and connected it to MYSQL just as you pointed. Br, Valent

$167 USD in 4 days
(0 Reviews)
0.0
ndut343

I am an automation engineer with professional experience working on enterprise software with advanced software skills in Python and database management(SQL). I have also designed GUI user interfaces for projects in Pyt More

$200 USD in 15 days
(0 Reviews)
0.0
bravesomu

Accomplished software engineer specializing in scalable solutions to software development. Extensive background in full-cycle of the software development process including requirements gathering, design, coding, testin More

$180 USD in 7 days
(0 Reviews)
0.0
harshitsukhija20

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

$100 USD in 7 days
(0 Reviews)
0.0
johnboscouroko

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.

$100 USD in 7 days
(0 Reviews)
0.0
WaleedKhader

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

$300 USD in 7 days
(0 Reviews)
1.6
TellezMiotta

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

$220 USD in 7 days
(0 Reviews)
1.9
sayonjana

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

$128 USD in 5 days
(0 Reviews)
0.0