Homework Two

Due Date: Monday, December 18 at Midnight
since grades need to be turned in I will have to grade this real soon so don't be late!

70 PTS (The Institute for Craftiness) 1. You are going to continue to work with the Institute for Craftiness. But now the situation will be just slightly different and require some changes and additions. At present we will assume that all memberships belong to adults. We will also assume the only classes we are going to be dealing with are for children.

In your database crafts.mdb, you need to make sure you have the following tables with particular data.

membership_types

family - $40 per year

individual - $25 per year

seniors - $15 per year

so you need fields for

primary key - id_member_type

type_of_membership

cost

classes_childrens

make sure you have at least eight classes offered in the table

Expressions in Acrylics

Expressions in Clay

Expressions in Oils

Expressions in Watercolors

Advanced Acrylics

Advanced Clay

Advanced Oils

Advanced Watercolors

so you need fields for

primary key - id_child_class

course_title

start_date

end_date

cost

teacher

members

make sur eyou have at least eight members in the table

so you need fields for (slightly simplified list)

primary key - id_member

first_name

middle_name

last_name

address

city

state

zip

fk_id_member_type

phone

email

child

make sure you have at least one member with three children taking classes

make sure you have at least two members each with two children taking classes

make sure you have at least three other members with at least a single child

so you need fields for

primary key - id_child

fk_id_member

child_first_name

child_middle_name

child_last_name

date_of_birth

enrollments

so you need fields for

primary key - id_enrollment

fk_id_child

fk_id_child_class

So these are the only tables you need to work with.

Now you need to create some forms with related subforms. The first form you need is

frm_members

Then you need to create a subform that associates each member with their children reflecting a one-to-many relationship.

frm_parent_child

you want to reflect the information you have on each member and any and all of their children

You need to make sure you create command buttons to help you navigate to the appropriate form and display information that is linked to the record being displayed on the referring form.