Relational Database Creation & Querys | SQL 🗃️

Project that consists of the creation of a relational database with SQL

Objetives 📋

Create a relational database schema that contain information about students, teachers, exams and subjects. The relationship is as follows:

• A student can have one or more subjects
• The teacher-student relationship is through the subjects, not directly
• The relationship between exams and students depends on the subject, it is not direct.
• A teacher can teach in several subjects and a subject can have several professors.
• Same for students and subjects.
• The exams are UNIQUE per subject. THERE IS ONLY ONE EXAM FOR EACH SUBJECT and STUDENT AND ONLY ONE.

Once you've created the schema, make up values and fill the tables with appropriate data. Try to have enough columns to store all the information that might be relevant.

At the end you should be able to perform the following queries.

1. Average mark of each subject.
2. Average grade associated with each teacher (average grades for their subjects)
3. Average mark of each student
4. What is the most difficult subject?
5. Look for the risk group of each subject (students who do worse.

ERR Diagram