Need Help With A Database Design

[Arc2571]

hey everyone i was reffered here cos someone over at CPCf said you guys could help me.

i really cant get my head wrapped around this database

i need a Entity Relationship Diagram which shows degree of relationships..

heres the brief;
The School of Law (SoL) at Tre-Gwyr University are piloting a scheme to train barristers. The scheme involves setting up a simulated Crown Court. In the simulated environment students’ role play as judges, prosecuting barristers, defence barrister and defendants as part of their coursework assessment. SoL has appointed you on a very large fee to draw up a design of a suitable database. The design is required to be in the form of an Entity Relationship Diagram, Table names and a description of all fields including primary and foreign keys.

Briefing Notes

The scheme is run as follows:

• Every judge will have a list of cases to manage.
• There is only one judge per case.
• Each case has a single prosecuting barrister.
• Cases are booked into one of three Crown Courts with both a start date and estimated time period in days.
• A case can consider more than one crime.
• A crime can have one or more defendants.
• Defendants can be involved in one or more cases.

can someone help me with the design of this database please

thanks

 

[dsigner]

Court tables

Hi Arc,
Here is a mockup of the tables you asked about. The relationship diagram is generated by Access (tools - relationships). I have assumed that while a case may have many crimes, a crime is only tried in one case. It is also likely that you will need a defending barrister but this was not in the spec so I have not coded it into the tables.

You will need appropriate forms and reports and you are likely to need more fields than I have shown which are the minimum to set up the relationships. Hope this gives you a start.

 

[Arc2571]

Thanks mate you are a lifesaver

 

[Pat Hartman]

Who's going to get the grade for the course?