Completed

Help with School Python Project

Create a program that displays the following menu to the user:

Add student

Add course

Add test

Add student to course

List courses by student

List tests by course

Exit

then performs the choice entered by the user. You can reuse code from the previous assignment if you want to.

Data considerations:

Students can take multiple courses and courses contain multiple students (many to many)

Courses can have multiple tests, but a test only belongs to one course (one to many)

All data must be stored in the SQLite database called school.sqlite.

The students table has the following columns:

id integer primary key auto increment

name text

email text

year integer

The courses table has the following columns:

id integer primary key auto increment

name text

max_students integer

The tests table has the following columns:

id integer primary key auto increment

course_id integer foreign key

name text

date_time text

The student_course table is an association table with the following columns:

student_id integer foreign key

course_id integer foreign key

1., 2. and 3.

Asks the user for the table fields in order (without id), then adds the new student/course/test to the database.

Expected output: Added <student/course/test> with id <id>

4.

Asks the user for a student id and a course id then adds the student to the course.

Note: Ask for both ids before checking if they are valid.

Expected output: Added student to course id <id>

Or: Student not found

Or: Course not found

5.

Asks the user for a student id then lists all the courses assigned to this student. The courses must be sorted by id, lowest first.

Expected output: Courses for student <id>: <course name>, <course name> ...

Or: Student not found

6.

Asks the user for a course id then lists all the tests for this course. The tests must be sorted by id, lowest first.

Expected output: Tests for course <id>: <test name>, <test name> ...

Or: Course not found

7. Exit

Exits the program.

Skills: Python, SQL

See more: project create music database, small python project example, school auction project, project create chat room, net project create critical path, 2008 school fees project, python twisted create ftp server, school system project php, school search project, free school management project, cost school website project, help school embedded project, create django python project, school project create app, simple project create school portal php, create simple python project, aptana create python project, In this project you will create 3 simple, binary 25x25 images or your choice and use Java 2D graphic methods to rotate, scale an

About the Employer:
( 0 reviews ) Kristiansand, Norway

Project ID: #25630715

Awarded to:

sleepyeos

Hi there! I've been developing and designing software for 6 years, and I majored in Computer Science. Python is my favorite language and I can have this project done for you today. I'm very interested in working with y More

$20 USD in 1 day
(0 Reviews)
0.0

16 freelancers are bidding on average $21 for this job

WangXiaoNi81

Hi, sir! I have experienced the Python and SQL for over 5 years. I have read your project description carefully and all are clear. I am ready to start work right now. Let's have a chat. Best regards.

$50 USD in 1 day
(17 Reviews)
3.9
WebDigitalExpert

Hi I am a Certified Python & R Expert. I have good experience dealing with python & R. I'm sure I will complete your project. Let's discuss a few points. I'll not disappoint you

$30 USD in 7 days
(4 Reviews)
2.5
ftfarhad0085

Hello, I am a Python developer. I have previous experience of doing the same you just posted in your job proposal. I have previous experience in Microsoft access data doing the same things. The price I included is just More

$50 USD in 7 days
(0 Reviews)
0.0
threeeyedmonk

Hi, I am experienced in Python programming. I can code and share this program with you. I have understood your requirement clearly. Please let me know when can I start. Thanks.

$10 USD in 3 days
(0 Reviews)
0.0
Daigowo

I am studying and passed all my Python courses, I can make your code in a few minutes. I am used to doing codes of this style, since they did many of these in my tests / tasks

$10 USD in 2 days
(0 Reviews)
0.0
enzoadofacci

Hello sir. I am a Python professional, I have 3 years of experience in it, so I can do what you ask me in less time. For sql I use at least 70% of the time I'm asking for I understand all your requirements and can star More

$20 USD in 2 days
(0 Reviews)
0.0
prakhardump016

I would love to help you. I am good at python and sql. Love for python can TAKE ME ANYWHERE . Trust me it will be a worthwhile and would be a cooler application. print("I Am Ready To Help ..!! ;)") Relevant Skills a More

$25 USD in 1 day
(0 Reviews)
0.0
dipakchouhan

Hi Sir! I have python and SQL experience of more than 2.6 years. I have understood the requirement properly and will complete it within the given time window. I am eager to start working on it. Lets have a discussion More

$10 USD in 1 day
(0 Reviews)
0.0
Astrobubu

I've been using python for sciences for 3 years

$15 USD in 1 day
(0 Reviews)
0.0
kusumakarshukla

I can do it within a week. The description and the requirement has been aptly elaborated. We can talk more on this.

$15 USD in 7 days
(0 Reviews)
0.0
sunitatrivedi

I can easily complete your assignment. You can check my profile having gold badge in python on hackerrank website. Link in my freelancer profile. I will finish the work as soon as I can.

$10 USD in 2 days
(0 Reviews)
0.0
$30 USD in 10 days
(0 Reviews)
0.0
Swati27

I have hands-on experience in making projects with knowledge of python too. To provide backend support in project ,have run many sql queries inside projects to perform various CRUD(create row,retrieve data,update data More

$15 USD in 7 days
(0 Reviews)
0.0
AbdulMoiz2200

Hey there, i have read your proposal thoroughly , This is something i can make easily as i have full command on python programming language plus it's library sqlite 3 , why i am so comfortable with this task is i have More

$20 USD in 1 day
(0 Reviews)
0.0
moisescunha

Hello, I am a python programmer and would like to run your project. Python's interaction with SQLite is simple and I can do that quickly.

$10 USD in 1 day
(0 Reviews)
0.0