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.