userID | username | password |
---|---|---|
1 | john_doe | password123 |
2 | jane_smith | securepass |
3 | bob_brown | mypassword |
4 | alice_white | strongPass#1 |
5 | emily_black | mysecretpass |
platformID | name | website |
---|---|---|
1 | Udemy | www.udemy.com |
2 | Coursera | www.coursera.org |
3 | edX | www.edx.org |
4 | Codecademy | www.codecademy.com |
5 | LinkedIn Learning | learning.linkedin.com |
courseID | title | description |
---|---|---|
1 | English_As_A_Second_Language | This course will teach you English as a second language. |
2 | Programming_Basics | This course covers the basics of programming languages. |
3 | Mathematics_For_Engineers | This course is designed for engineering students who need a strong foundation in mathematics. |
4 | Artificial_Intelligence | This advanced course covers artificial intelligence concepts and applications. |
5 | Data_Science | This comprehensive course teaches data science skills and techniques. |
studentID | courseID | enrollmentDate |
---|---|---|
(→ Users.userID) | (→ Courses.courseID) | |
1 | 1 | 2021-07-01 |
2 | 2 | 2021-06-20 |
3 | 3 | 2021-08-15 |
4 | 4 | 2021-09-01 |
5 | 5 | 2021-10-01 |
ratingID | studentID | courseID | stars | reviewText | submissionDate |
---|---|---|---|---|---|
(→ Users.userID) | (→ Courses.courseID) | ||||
1 | 1 | 1 | 5 | Excellent course! Highly recommended. | 2021-08-10 |
2 | 2 | 2 | 4 | Good course but could use more examples. | 2021-07-15 |
3 | 3 | 3 | 5 | Very helpful for my studies. | 2021-08-20 |
4 | 4 | 4 | 5 | Great course on AI, highly informative. | 2021-09-05 |
5 | 5 | 5 | 4 | The content was good, but I felt it lacked depth at times. | 2021-10-10 |
instructorID | firstName | lastName | |
---|---|---|---|
1 | John | Doe | johnd@example.com |
2 | Jane | Smith | janes@example.com |
3 | Bob | Brown | bobb@example.com |
4 | Alice | White | alicw@example.com |
5 | Emily | Black | emilbl@example.com |
courseID | instructorID | startDate | endDate |
---|---|---|---|
(→ Courses.courseID) | (→ Instructors.instructorID) | ||
1 | 1 | 2021-01-01 | 2022-12-31 |
2 | 2 | 2021-02-01 | 2022-12-31 |
3 | 3 | 2021-03-01 | 2022-12-31 |
4 | 4 | 2021-04-01 | 2022-12-31 |
5 | 5 | 2021-05-01 | 2022-12-31 |
platformID | courseID | availabilityStatus |
---|---|---|
(→ Online_Learning_Platforms.platformID) | (→ Courses.courseID) | |
1 | 1 | Available |
2 | 1 | Unavailable |
3 | 2 | Available |
4 | 3 | Unavailable |
5 | 4 | Available |
3 | 1 | Available |
4 | 1 | Unavailable |
5 | 1 | Available |