[Shacs] database structure question.. this one is easy

[Fuermann, Jason]

For the list to see. Also I guess I should have noticed you were populating the trial/hearing table, I was thrown off by the naming schema on the first example. I promise to pay more attention next time.

From: Fuermann, Jason
Sent: Wednesday, February 25, 2009 9:11 AM
To: 'Bronius Motekaitis'
Subject: RE: [Shacs] database structure question.. this one is easy

Shouldn't your second example have judgeid,locationid,requiredcount,trialduration in the court table as well. Either way, the extra table is the way to go.

From: shacs-bounces at shsu.edu [mailto:shacs-bounces at shsu.edu] On Behalf Of Bronius Motekaitis
Sent: Wednesday, February 25, 2009 8:54 AM
To: shacs
Subject: [Shacs] database structure question.. this one is easy

Let's consider the tables: Hearing, Court, Judge, and Location (notice the CAPS: I did that so I wouldn't scare away any Access fans and undergrads..!)

A Hearing can hear any Court's cases at any Location by any Judge, so these are all foreign keys on Hearing. When creating a Hearing, I want to populate default values for Judge, Location and a handful of other values not shown here based on the Court selected.

Where should I attach these default values?  Does it make more sense to make a "Court_Default" table or stuff the given Court table with these foreign key values as defaults?

See attached for comparison of the two models considered..

-bronius
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.shsu.edu/pipermail/shacs/attachments/20090225/548addd4/attachment.html