## Students

studentID | firstName | lastName | emailAddress
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com

## Courses

courseID | title | professor
--- | --- | ---
1 | Introduction to Computer Science | Dr. John Smith
2 | Calculus I | Professor Jane Doe

## Enrollments

enrollmentID | studentID | courseID
--- | --- | ---
| (→ Students.studentID) | (→ Courses.courseID)
1 | 1 | 1
2 | 2 | 2

## Books

bookID | title | genre | ISBN
--- | --- | --- | ---
1 | The Great Gatsby | Fiction | 9780743273565
2 | To Kill a Mockingbird | Fiction | 9780060935467

## Ratings

ratingID | bookID | ratingText
--- | --- | ---
| (→ Books.bookID) |
1 | 1 | 3.5
2 | 2 | 4.0

## FictionBooks

bookID | author | publicationYear
--- | --- | ---
(→ Books.bookID) |  |
1 | F. Scott Fitzgerald | 1925
2 | Harper Lee | 1960

## NonFictionBooks

bookID | topic | publisher
--- | --- | ---
(→ Books.bookID) |  |
1 | History of Computers | Pearson Education
2 | Mathematics for Engineers | McGraw-Hill Education