StudentID | FirstName | LastName |
---|---|---|
1 | John | Doe |
2 | Jane | Smith |
3 | Michael | Johnson |
4 | Emily | Williams |
5 | David | Brown |
AddressID | StreetAddress | City | State | ZipCode | StudentID |
---|---|---|---|---|---|
(→ Students.StudentID) | |||||
1 | 123 Main St | Anytown | CA | 90210 | 1 |
2 | 456 Elm St | Othertown | NY | 10001 | 2 |
3 | 789 Oak St | Anytown | TX | 77301 | 3 |
4 | 101 Pine St | Townville | IL | 60601 | 4 |
5 | 111 Maple Ave | Villagetown | NJ | 07601 | 5 |
PhoneNumberID | Number | Type | StudentID |
---|---|---|---|
(→ Students.StudentID) | |||
1 | (555) 123-4567 | Home | 1 |
2 | (555) 987-6543 | Mobile | 2 |
3 | (555) 321-0987 | Work | 3 |
4 | (555) 765-4321 | Home | 4 |
5 | (555) 135-7890 | Mobile | 5 |
EmailAddressID | IsPrimary | StudentID | |
---|---|---|---|
(→ Students.StudentID) | |||
1 | johndoe@example.com | 1 | 1 |
2 | janedoe@example.com | 0 | 1 |
3 | emilywilliams@example.net | 1 | 4 |
4 | davidbrown@example.org | 0 | 5 |
5 | michaeljohnson@example.edu | 1 | 3 |
EnrollmentID | CourseID | Semester | Year | Grade | StudentID |
---|---|---|---|---|---|
(→ Students.StudentID) | |||||
1 | 1 | Fall | 2021 | A | 1 |
2 | 2 | Spring | 2022 | B+ | 2 |
3 | 3 | Summer | 2022 | A- | 3 |
4 | 4 | Fall | 2021 | B | 4 |
5 | 5 | Winter | 2022 | Incomplete | 5 |
ScoreID | Month | Day | ExamDescription | Score | StudentID |
---|---|---|---|---|---|
(→ Students.StudentID) | |||||
1 | 10 | 15 | Final Exam | 95 | 1 |
2 | 4 | 20 | Midterm | 85 | 2 |
3 | 6 | 5 | Quiz | 90 | 3 |
4 | 12 | 10 | Project | 92 | 4 |
5 | 3 | 15 | Assignment | 88 | 5 |