Qualification Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

using Access 2003.
I am Trying to create a database for Qun Qualifications. I am not sure what
I am doing wrong.

These are my tables:
TBLShooters
ShooterID
First Name
Last Name
Rank
Last 4
TBLPistol
PistolID
ShooterID
ShootDate
RequalDate
Score
Qualified (y/n)
Marksman (y/n)
Sharpshooter (y/n)
Expert (y/n)
TBLRifle
RifleID
ShoterID
ShootDate
RequalDate
Score
Qualified (y/n)
Marksman (y/n)
Sharpshooter (y/n)
Expert (y/n)
I use a query for Shooters/Pistol and another for Shooters/Rifle

I am not sure what I am doing wrong.
Please Help!!

Thank you,


Sean
 
Consolidate to this ---
TBLShooters
ShooterID
First Name
Last Name
Rank
Last 4
TBLQual
QuallID
Weapon (Rifle / Pistol / Grenade )
ShooterID
ShootDate
RequalDate
Score
Qualified ( Marksman / Sharpshooter / Expert )
 
You can have separate tables for weapon type and qualification type and have
many-to-many relationships between the three tables.

Qualification test would be the junction table and you would have shooter,
weapon and qualification type as the main tables.

You can also have supervisor table, a date table.

A part of database design is to know what you want to do with the
information once it is stored. Do you want booking and diary information, do
you want to use the DB for classes.

It can be a case of working backwards.
 
Back
Top