A database program created in MySQL that can function as a college database. It stores all the students' info in the student_info table which contains the firstname, lastname, student ID, major and their sex. The instructors' details with their IDs and names are in another related table. Another table contains the major names and their corresponding codes. Lastly, different tables have been created for each individual course being offered. These course tables contain the student ID of each student who has taken the course, name of professor who taught the course to the student, year and semester the course was taken in and the mark the student received in the course.
- Create a database called
first_dbon MySQL - Run the script
main.sql
Note: This program has only been tested on MySQL. Performance on other database engines is not guaranteed.
Click the links to see the images
Click the links to see the images
- Total students.
- Terms a course is offered in.
- Name of all students and arranging them in descending order of age and last name.
- Average marks scored in a course by all students who have taken the course.
- Average marks scored by females in Calc 2.
- Name and details of student who scored the max marks in Calc 3.
- Grades assigned based on marks to students in electric fundamentals.
- Seeing whether student had honors, passed or failed in digital systems.
Pull requests are welcome for adding more courses and populating the database or fixing exisiting issues.