| studentID | firstName | lastName | emailAddress |
|---|---|---|---|
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
| courseID | title | professor |
|---|---|---|
| 1 | Introduction to Computer Science | Dr. John Smith |
| 2 | Calculus I | Professor Jane Doe |
| enrollmentID | studentID | courseID |
|---|---|---|
| (→ Students.studentID) | (→ Courses.courseID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| bookID | title | genre | ISBN |
|---|---|---|---|
| 1 | The Great Gatsby | Fiction | 9780743273565 |
| 2 | To Kill a Mockingbird | Fiction | 9780060935467 |
| ratingID | bookID | ratingText |
|---|---|---|
| (→ Books.bookID) | ||
| 1 | 1 | 3.5 |
| 2 | 2 | 4.0 |
| bookID | author | publicationYear |
|---|---|---|
| (→ Books.bookID) | ||
| 1 | F. Scott Fitzgerald | 1925 |
| 2 | Harper Lee | 1960 |
| bookID | topic | publisher |
|---|---|---|
| (→ Books.bookID) | ||
| 1 | History of Computers | Pearson Education |
| 2 | Mathematics for Engineers | McGraw-Hill Education |