Students

studentIDfirstNamelastNameemailAddress
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com

Courses

courseIDtitleprofessor
1Introduction to Computer ScienceDr. John Smith
2Calculus IProfessor Jane Doe

Enrollments

enrollmentIDstudentIDcourseID
(→ Students.studentID)(→ Courses.courseID)
111
222

Books

bookIDtitlegenreISBN
1The Great GatsbyFiction9780743273565
2To Kill a MockingbirdFiction9780060935467

Ratings

ratingIDbookIDratingText
(→ Books.bookID)
113.5
224.0

FictionBooks

bookIDauthorpublicationYear
(→ Books.bookID)
1F. Scott Fitzgerald1925
2Harper Lee1960

NonFictionBooks

bookIDtopicpublisher
(→ Books.bookID)
1History of ComputersPearson Education
2Mathematics for EngineersMcGraw-Hill Education