Start Date
16-8-2018 12:00 AM
Description
We use a problem-solving approach to learning where students work on a partially completed database with defects. To fix and complete the database design, students enforce entity, referential and column level constraints. After fixing the database, students develop data macros to update changes into other tables. By successfully fixing problems and creating macros, students gain confidence in working with databases. Informal feedback from students revealed evidence of learning among students. Students also learned valuable concepts in database design.
Recommended Citation
Singh, Anil; Bhadauria, Vikram; and Gurung, Anil, "A Problem-Solving Based Approach to Teaching Database Design" (2018). AMCIS 2018 Proceedings. 17.
https://aisel.aisnet.org/amcis2018/Education/Presentations/17
A Problem-Solving Based Approach to Teaching Database Design
We use a problem-solving approach to learning where students work on a partially completed database with defects. To fix and complete the database design, students enforce entity, referential and column level constraints. After fixing the database, students develop data macros to update changes into other tables. By successfully fixing problems and creating macros, students gain confidence in working with databases. Informal feedback from students revealed evidence of learning among students. Students also learned valuable concepts in database design.