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. In this on-your-own exercise, you'll add the necessary tables to the database and create the needed relationships in order to effectively track student and enrollment data.
This section has less guidance than the previous sections. Each step has a walkthrough video included in the step's details. To see the details for each step, expand the appropriate accordion fold.
Some data that we would like to track for students includes (but is not limited to) the following items:
Student ID numbers
Names (first & last)
Address
Email
Phone number
Degree program
Enrollment date
Remember to set the appropriate primary key, data types, field sizes, and captions for each field.
Think about where tblStudents and tblEnrollments might connect to other tables in the database. Where does it make sense to build relationships between tables?
