College or school database
By making a project such as college or school database, you can do a variety of operations. The main objective of this project will be to handle all the details of students’ and proffessors' data, as well as their courses. The main data properties that this database should have are the following:
- Student: name, phone number, email, address, year of admission, courses applicable, etc.
- Other important things such as student's attendance, their grade sheets, scholarships, and tests
- Data for the teachers, same as for the students (name, contact details, courses, salary, hours)
- Course: name, description, duration..
Query examples:
Get all the teachers that have given D to the students with year of admission 2020.
Get all the different courses that the students born in 1995 have taken in the past 3 years.
In the following ER diagram we will show a simplified version of the school database:
