| 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 |