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 |