Beginning Database Design: From Novice to Professional, Second Edition

Appendix

Testing Your Understanding

In this Appendix we will discuss the problems from the end of each chapter. I emphasize that these are discussions as opposed to answers. There may be other acceptable ways to approach the different scenarios.

Exercise 1-1

A school is planning some outdoor pursuits for its students. It wants to create a database of how parents can help. The secretary sets up the database table as in Figure A-1 to keep the information.

Figure A-1. Initial database table for recording parent contributions

a)  What problems can ...