Python only.

Create a database of following details for at least 50 students and store it in a text file.

Student ID

first name

last name

phone number (xxx-xxx-xxxx)

email id

Major

Create another database of following details for those students and store it in another text file.

Student ID

Courses taken for each semester and Scores for each course which includes overall average of assignments, quizzes, projects and exams.

For example:

Student _ID Campus year semester course_number average_assignment average_quizzes average_projects average_exams..

Example:

2451813 2015 spring CS123 90 91 98 92 CS120 80 70 75 2 fall Math250 92 84 88 91

2016 spring CS121 90 91 98 92 CS125 80 70 75 2 fall Math252 92 84 88 91

Note: You can change/manipulate the order of data entries as needed.

Exercise:1

Choose an appropriate data type and data structure (lists, lists of list, dictionary etc.) for storing the information in your program.

Exercise:2

Write a function which takes student ID as input and displays all information of the student stored in file-1 and file-2.

Exercise:3

Write a function which takes student ID and specify course number as inputs and displays the score information of that course.

Exercise:4

Write a function which takes student ID and specify semester name as inputs and displays the grade for all the courses taken in that semester.

Exercise:5

Write a function which takes student ID as input and displays the course number of maximum grade and minimum grade with the associated grade.

Exercise:6

Show an example of using split and join method.

Exercise:7

Show an example of adding data entry for a new student, modifying a students score for a specific semester and deleting a student entry.

Exercise:8

Write a function which takes a parameter and sorts the entire list of students and displays all the details of all students. For example, if you specify the student ID or first name, the entries should be sorted accordingly.

Exercise:9

Write a function which takes student id as parameter and finds whether the student is a freshmen or sophomore or junior or senior.

Exercise:10

Programmatically create a file storing all the students information including the added/modified entry.