Tealod

University System Database

1) Creating Database

CREATE DATABASE university_system 

2)Designing tables which table we should:

• Departments
• Faculties
• Professors
• Courses

Tealod

-- SQL : Retrieve all students with their enrolled courses
-- and enrollment dates.
-- Tables used:
-- 1. student       (id, name, …)
-- 2. course        (id, name, …)
-- 3. enrolment     (student_id, course_id, enrollmentDate)
-- 
-- Joins explained:
-- - student s JOIN enrolment e: matches each student with their enrollments