## Campus_Building

id | name | capacity
--- | --- | ---
1 | Main Building | 1200
2 | Library | 800
3 | Sports Center | 600
4 | Art Center | 300
5 | Conference Hall | 100

## Online_Platform

id | platformName | URL
--- | --- | ---
1 | EdX | https://www.edx.org
2 | Coursera | https://www.coursera.org
3 | Udacity | https://www.udacity.com
4 | Codecademy | https://www.codecademy.com
5 | LinkedIn Learning | https://www.linkedin.com/learning

## Lecture

id | title | duration | campusId | onlineId
--- | --- | --- | --- | ---
|  |  | (→ Campus_Building.id) | (→ Online_Platform.id)
1 | Introduction to Databases | 90 | 1 | 1
2 | Advanced Programming Techniques | 120 | 2 | 2
3 | Data Science and Machine Learning | 150 | 3 | 3
4 | Network Security Fundamentals | 100 | 4 | 4
5 | Project Management Best Practices | 110 | 5 | 5

## Student

id | firstName | lastName | email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com
3 | Michael | Brown | michael.brown@example.com
4 | Emily | White | emily.white@example.com
5 | David | Green | david.green@example.com

## Enrollment

studentId | lectureId | grade
--- | --- | ---
(→ Student.id) | (→ Lecture.id) |
1 | 1 | 90
1 | 2 | 87
2 | 3 | 92
2 | 4 | 88
3 | 1 | 93

## Course

id | courseCode | courseTitle | lecturesInCourse
--- | --- | --- | ---
|  |  | (→ Lecture.id)
1 | CS101 | Fundamental of Computer Science | 5
2 | DS201 | Applied Data Structures | 4
3 | ENG301 | Technical Writing | 3
4 | MGMT401 | Human Resource Management | 3
5 | IT202 | Web Development | 4