Create a database (ACCESS) to track the Badges Earned by the local Scout troupe.

u The database (DB) must contain at least 3 tables, but you may have more.

You must include input masks and validations.

v Track a Scout and all the badges he has earned.

Scouts can earn many badges.

At the age of 21, a Scout must leave the Scouts Canada organization.

When a Scout has earned 15 2^nd class badges, he moves up to 1^st class.

When a Scout has earned 10 1^st class badges, he moves up to Queen Scout.

Each badge is categorized as 2^nd class, 1^st class or Queen Scout.

Badges are worn on specific spots on the uniform.

w We need to be able to track:

- A Scout and all the badges he has earned.

- Which badge has been earned by which Scout(s)?

- Which badges are in each of the 3 categories?

- A mailing list used to invite the parents to the Investiture Ceremonies.

Extras:

4. Add a troupe table.

Troupes have leader(s). Leaders have designations (rank), and pet names.

Leaders receive literature mailed to them from Scouts Canada.

More information on validations:

Dates not in future <=date()

Dates not more than 1 year in past >=date()-365

Check an integer year is not in future

<=year(date())

Birthdate of a boyscout makes him between 10 and 20 years old

>=[date() 20*365 and <= date() 10*365

badgeCost reasonable that not negative and not more than $10

>=0 and <=10

dont add validations if using lookup and referential integrity enforced