To get more practice with creating, conceptualizing, and implementing data structures, we would like to add the capability to track information about enrolled students and the courses they're taking. Some data that we would like to track for students include, but are not limited to:
- Student ID numbers
- Names (first & last)
- Phone number
- Degree program
- Enrollment date
This section has less guidance than the previous sections. If you would like a walk-through, watch this videoabout Normalizing Data.
Step1. Create tblStudents to track student information.
Step2. Add tblStudents to the Relationships window and create the appropriate relationships, if any exist.
- Section ID number
- Student ID number
- Student's grade
- Enrollment ID number
Step3. Create tblEnrollments to track enrollment information.
Step4. Add tblEnrollments to the Relationships window and create the appropriate relationships, if any exist.
Step5. Create some students and their associated enrollment data to double check your data structures.
|File Name||Included Data|
|tblStudents.xlsx||Student Personal Data|
|tblEnrollments.xlsx||Student Enrollment and Grade Data|