Help With Realationships And Design

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

Guest

Hello. Im trying to design a databse that will house information for a small
college Judicial Board. I have put some tables together to support what we
are looking for. I need help with relationships. Im not sure how to buid a
bridge table if that is even needed. I also would like to be able view
reports of students who have judical records. If anyone could help let me
know. If it is better we could communicate through reg.email

OffenderTable
Offender ID
First_Name
Last_Name
DoB
Gender
Notes

Violator Table
Violator ID
Violator First_Name
Violator_Last_Name
DoB
Gender
Notes

Victim Table
Victim ID
First_Name
Last_Name
DoB
Notes

Incident Table
Inicdent ID
Incident Type
Incident Date

Hearing Table
Hearing ID
Incident ID
Hearing Begin Date
Hearing End Date
Hearing Location
Out Come
Sanctions
 
Here is one to get you started. Assuming that an Incident could have an
Offender and a Victim in some cases, at least, do this:

Add OffenderID field to your Incidents table and create a relationship to
the OffenderID in the Offenders table.

Do the same with the VictimID.

This way, when you have an incident that involves an offender and a victim,
the ID's for those individuals will be tied to the incident. They key will be
creating forms that make these things transparent to the user (like showing
the user the offender's name while actually using the OffenderID to tie the
offender to the incident, since the OffenderID will probably mean very
little, if anything, to the user).

If EVERY incident has an offender, then make OffenderID required in the
Incidents table.

You could do the same to tie OffenderID to the Hearings table, since
presumably each hearing involves an offender.

Try posting more specific report questions in the Access Reports forum after
you have the tables and input forms constructed and working. That way, you
can get more specific help.
 
Back
Top