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

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 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

don’t add validations if using lookup and referential integrity enforced

Explanation / Answer

The access database to track the Badges Earned by the local Scout troupe having following three tables. The table informations with the attribut details are given below:

1) Scout_Personal_Data_Table(Id, name, address, telephone_number, email_address)
Here in the above table "Id" attribute will be work as primary key, it should be unique and not null.

2) Badge_Table(badge_Id, badge_name, badge_type, badge_description)
Here in the above table "badge_Id" attribute will work as primary key and it should be unique and not null.

3) Badge_Earn_Table(badge_Id, Id, no_of_badge)
Here in this table "badge_Id" and "Id" is working as foreign key for the table.

For creating these tables in access we can follow the below given steps:

i) First we will launch the access application and then chose File--->New
ii) Now we will be chosing "blank database" as we need to create a fresh database.
iii) By default one table will appear, click on "click to add" and start entering the attributes in this table.
iv) Now you can add one more table from add table option and can enter its attributes.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.