Students

StudentIDFirstNameLastNamePersonal_Computing_DevicesOperating_SystemEmailAddress
1JohnDoeTabletWindows 10john.doe@example.com
2JaneSmithPhoneiOSjane.smith@example.com
3MikeBrownLaptopWindows 10mike.brown@example.com
4EmilyWhiteDesktopmacOSemily.white@example.com
5DavidGreenTabletAndroiddavid.green@example.com
6AmyBlackLaptopLinuxamy.black@example.com

Instructors

InstructorIDFirstNameLastNameDepartment
1ProfessorAdamsMathematics
2Dr.JohnsonPhysics
3AssistantWilliamsBiology
4AssociateTaylorEnglish Literature
5ProfessorThompsonHistory
6Dr.MartinGeography

Courses

CourseIDTitleDescriptionInstructorID
(→ Instructors.InstructorID)
1Calculus IIntroduction to Calculus1
2General PhysicsIntroduction to Classical Mechanics2
3Introductory BiologyCellular and Molecular Biology3
4Modern English LiteratureSurvey of British Literature since 19004
5World HistoryGlobal Civilizations Since 1500 CE5
6Human GeographyRegional Geographies of the World6

Enrollments

EnrollmentIDStudentIDCourseIDGrade
(→ Students.StudentID)(→ Courses.CourseID)
111A
212B+
322A-
433B
544A
655A
766B