Help With Realationships And Design

W

Wtigermac

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

redundant data - help with Contact Database 6
CDate results in Data Type Mismatch in Query & Excel Pivot 1
Help with forms and relational model 1
forms, foreign keys and relational model 1
Help with feature design... 1
I need help with my design 1
Need help with table design and relationships 5
DB Design and Relationship Questions 7

Top