Question
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
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 2nd class badges, he moves up to 1st class.
When a Scout has earned 10 1st class badges, he moves up to Queen Scout.
Each badge is categorized as 2nd class, 1st 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started