Due Monday, November 27 at Midnight (normally would be due Friday, November 24 but this is Thanksgiving week.
|20 PTS (A Database)
1. Think about your own experience with databases. This
can be a database you have worked on or with. Or it can be a
database you have used.
|40 PTS (Summer Camps) 2. Consider the following form for summer camps for children offered by The Institute for Craftiness.|
|Create a database with appropriate table and
You also need to create a form that reflects the data.
|40 PTS (The Institute)
3. For this problem you need to do some data modeling.
Consider The Institute for Craftiness that you started working on in
the last problem. But now you also need to consider that The
Institute for Craftiness has memberships. They cost
So you need to include both the data for memberships and for those attending summer camps. You also need to ensure that the dates for membership are maintained so that it is apparent who is actually paid up and who should be getting renewal reminders. At this point we will leave out any classes they offer (though if I can get it written up quickly enough I would like to include them) other than the summer camps.
What I want from you at this point is the entities - tables and their attributes - fields. That is you should give me the data dictionaries for each table. You do not need to create an E- R model for this homework.