Hello,
I have been learning everything I can about DBs because I'm teaching a course that requires students to create a product to solve a real world problem. Most students have always chosen Java, but one option is databases and so I now have kids doing database projects using Access. The problem is that the rubric is pretty vague and geared more towards coding projects. The biggest issue I am running into is the "Low to High Complexity" and "Low to High Ingenuity"
Complexity = their demonstration of their computational thinking
Ingenuity = their creativity in facilitating the user's life
So I have the following requirements:
1) At least 2-3 related tables
2) Normalization
3) Forms for user to add/delete
4) At least 3 Queries to pull meaningful data (using OR AND and operators)
5) At least 3 Reports
6) Validation rules and input masks
7) Password protected and a "switchboard" to create an interface
At this point I dont know how else I can have students demonstrate computational thinking or ingenuity apart from what I have. Not sure where they can plug in conditional statements or how they could use VB simply to add functionality
Any guidance on my list and the question would be greatly appreciated because I am very new to database development.
Thank you so much in advance
Omar