A prototype for Student Enrolments

Last week we started designing the tables for our Student Enrolments database.

This morning we'll work in small groups to do the following:

1. Check the table designs from last week, (the database Student Enrolments is on the P:, note - there might be some mistakes... or not!)
   
2. Add some sample data (for eg, 3 courses and 8 students)
3. Discuss together how you will enrol a student in a course (you'll need to add at least one table to your design)
4. Make the appropriate changes and test (Don't worry about forms or making your app easy to use just yet, our priority is that the design is correct).
5. Enrol all of your students in different courses.
   

We'll then get together and take a look at the different designs. If you finish early and are waiting, you might want to try the following:

• Create a query which displays all the enrolments in a way that is useful to users
• Create a report which shows all the student enrolments for each course
• Add totals to your report so that it automatically calculates how many students are enrolled in each course!