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.

Share

COinS
 
Aug 16th, 12:00 AM

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.