473,605 Members | 2,387 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Attempting to create well-designed database

Work in legal office. Trying to create solid designed database
structure. This is list of tables w/fields and primary keys. Any
comments/advice greatly appreciated.
tbl-Defendants
CaseNumber (primary key)
FirstName
MiddleName
LastName
DOB
Race
Gender
tbl-JunctionCharges ToDefendantsCas e
CaseNumber
ChargeID
tbl-Charges
ChargeID (auto-number assigned Primary Key)
Statute
Description
ChargeType
tbl-ChargeTypes (used as combo box in form)
ChargeTypeID (auto-number assigned Primary Key)
Municipal
County
State
Federal
tbl-Prosecutor (used as combo box in form)
BarNumber (Primary Key)
ProsecutorName
tbl-Appearance
AppearanceID (auto-number assigned Primary Key)
CaseNumber
AppearanceType
Date
Time
ProsecutorName
Offer
Plea
Disposition
tbl-AppearanceTypes (used as combo box in form)
AppearanceTypeI D (auto-number assigned Primary Key)
FirstAppearance
Arraignment
DocketSounding
PleaDay
Trial

Notes: Defendants may have more than one case number but case number
can only have one defendant.

Case numbers may can have more than one charge and a charge can have
many cases.

A case has a structured set of appearence types:

First Appearance
Arraignment
Docket Sounding
Plea Day
Trial

Due to various reasons, a case may have more than one of these
appearance types.

Nov 13 '05 #1
24 3095
rkc
fl******@bellso uth.net wrote:
Work in legal office. Trying to create solid designed database
structure. This is list of tables w/fields and primary keys. Any
comments/advice greatly appreciated.


<snip table descriptions>

A first glance:

I see no Case table. Seems to me that Case would be a primary entity
in such a model.

Case number is not an attribute of a Defendant. Case number is an
attribute of the missing Case entity.

Suppose the defendant is the habitual type. Your model would
repeat the defendants personal information each time he/she
showed up in the system.
Nov 13 '05 #2
Tom
I suggest you use an autonumber for the PK. If someone makes a mistake an
assigns a previously assigned case number to a new client, CaseNumber is no
longer unique. An autonumber will always be unique.

I am in business to provide customers with a resource for help with Access,
Excel and Word. If you need help with your database, lease contact me at my
email address below.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
<fl******@bells outh.net> wrote in message
news:11******** **************@ c13g2000cwb.goo glegroups.com.. .
Work in legal office. Trying to create solid designed database
structure. This is list of tables w/fields and primary keys. Any
comments/advice greatly appreciated.
tbl-Defendants
CaseNumber (primary key)
FirstName
MiddleName
LastName
DOB
Race
Gender
tbl-JunctionCharges ToDefendantsCas e
CaseNumber
ChargeID
tbl-Charges
ChargeID (auto-number assigned Primary Key)
Statute
Description
ChargeType
tbl-ChargeTypes (used as combo box in form)
ChargeTypeID (auto-number assigned Primary Key)
Municipal
County
State
Federal
tbl-Prosecutor (used as combo box in form)
BarNumber (Primary Key)
ProsecutorName
tbl-Appearance
AppearanceID (auto-number assigned Primary Key)
CaseNumber
AppearanceType
Date
Time
ProsecutorName
Offer
Plea
Disposition
tbl-AppearanceTypes (used as combo box in form)
AppearanceTypeI D (auto-number assigned Primary Key)
FirstAppearance
Arraignment
DocketSounding
PleaDay
Trial

Notes: Defendants may have more than one case number but case number
can only have one defendant.

Case numbers may can have more than one charge and a charge can have
many cases.

A case has a structured set of appearence types:

First Appearance
Arraignment
Docket Sounding
Plea Day
Trial

Due to various reasons, a case may have more than one of these
appearance types.

Nov 13 '05 #3
I assume this is a prosecutor's office?
Some other items you may want to consider:

Codefendants
JudgeName
DefenseAttorney
TypeOfTrial(Jud ge or Jury)
OffenseDate
Witnesses
Address/phone info for Defendants and witnesses
SentencingGuide linesApply
MotionForDiscov eryFiled
LabTestResultsR ecieved
ReasonForContin uance
Questions:

Will you be using this to prepare court orders?
Issue subpeonas for witnesses and defendants?
Do you want to just track court dates, or use the data to manage file
content?

Comments:

You need to separate out defendants from the Case Number. The defendant
can (and will) be a defendant in other cases, so you don't want to have to
re-enter the information. Generally your table name should correspond with
your primary key - IOW, if your table is 'defendant', your pk should not be
CaseNumber, but defendant_id

tbl-Defendants
DefendatID (primary key)
FirstName
MiddleName
LastName
Suffix (Jr, Sr, III)
DOB
Race
Gender

As much as it may seem logical to use the BarNumber as the pk, I would not.
You just never know when something weird could happen - I use autonumbers
for every table, even if a pk seems to be apparent. Also, if you're in an
office with more than three prosecutors, I would consider storing last
names, first names etc rather than just ProsecutorName. With turnover and
special prosecutors, the list may grow longer than you think.

tbl-Prosecutor
ProsecuterID (Primary Key)
BarNumber
LastName
FirstName
MiddleName
Suffix

Municipal, County, State, and Federal all are types of charges - so that is
the data, not fields.

tbl-ChargeType
ChargeTypeID (auto-number assigned Primary Key)
ChargeTypeDesc (Municipal, County, State, and Federal)

Same thing.

tbl-AppearanceType (used as combo box in form)
AppearanceTypeI D (auto-number assigned Primary Key)
AppearanceTypeD esc (FirstAppearanc e, Arraignment, DocketSounding, PleaDay,
Trial)
Be very careful when choosing field names not to choose generic names that
will give you fits later. In tblAppearance, "Date" and "Time" are both
Access reserved words, and are bad choices for field names. Here is Tony
Toews' page on Naming Conventions.

http://www.granite.ab.ca/access/tablefieldnaming.htm

My personal preference would render the table like this (table names are
always singular, not plural):

appearance
appearance_id (auto-number assigned Primary Key)
app_court_case_ id (foreign key)
app_app_type_id (foreign key)
app_prosecutor_ id (foreign key)
app_date
app_time
The offer and plea information should go in the Case table, not the
appearance table, unless you feel the need to track a changing plea offer

court_case
court_case_id
cc_case_number
cc_offer
cc_plea

Where you put the disposition data will depend on your state, but it would
be best if it is kept in the same table as the individual charge, rather
than with the court case. Some states don't differentiate, but others do.
To my mind it is much easier to catch sentnecing errors if the disposition
information is kept with the cahrge, not lumped together.

I know that the court docket number is already unique, so why have a
separate autonumber id? There are several reasons, but here are a two:
- the assigneing of Docket numbers is done by the court, not your office.
Any time that the data is out of your control, I would be loathe to use that
for a pk - what if they made a mistake in the docket number, and later the
clerk wants to correct it?
- always using Long data types, with consistent names (table name + "id")
makes your life easier when writing code, recalling field names, etc
Darryl Kerkeslager
<fl******@bells outh.net> wrote:
Work in legal office. Trying to create solid designed database
structure. This is list of tables w/fields and primary keys. Any
comments/advice greatly appreciated.
tbl-Defendants
CaseNumber (primary key)
FirstName
MiddleName
LastName
DOB
Race
Gender
tbl-JunctionCharges ToDefendantsCas e
CaseNumber
ChargeID
tbl-Charges
ChargeID (auto-number assigned Primary Key)
Statute
Description
ChargeType
tbl-ChargeTypes (used as combo box in form)
ChargeTypeID (auto-number assigned Primary Key)
Municipal
County
State
Federal
tbl-Prosecutor (used as combo box in form)
BarNumber (Primary Key)
ProsecutorName
tbl-Appearance
AppearanceID (auto-number assigned Primary Key)
CaseNumber
AppearanceType
Date
Time
ProsecutorName
Offer
Plea
Disposition
tbl-AppearanceTypes (used as combo box in form)
AppearanceTypeI D (auto-number assigned Primary Key)
FirstAppearance
Arraignment
DocketSounding
PleaDay
Trial

Notes: Defendants may have more than one case number but case number
can only have one defendant.

Case numbers may can have more than one charge and a charge can have
many cases.

A case has a structured set of appearence types:

First Appearance
Arraignment
Docket Sounding
Plea Day
Trial

Due to various reasons, a case may have more than one of these
appearance types.

Nov 13 '05 #4
Per fl******@bellso uth.net:
comments/advice greatly appreciated.
tbl-Defendants


Lose the hyphens in object/field names.

They'll make you crazy when editing code and you try to doubleclick to select
all of the name.

--
PeteCresswell
Nov 13 '05 #5
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Don't use AutoNumbers as Primary Keys (PK). You can assign a Unique
Index to the AutoNumbers if you want to use them as FK linking columns
in other tables. PKs should identify the row's data in the "real
world."

Example: Will the CaseNumber identify the defendant if you went to the
courthouse and asked who was the defendant on Case # 12345? Would that
be the only defendant on that case? If there is more than one defendant
on that case then that breaks the PK. Therefore, you should have the a
Defendants table without the CaseNumber. You should have a joing table
"DefendantCases " w/ the Defendant's ID number and the CaseID. Here are
DDLs of two tables (JET SQL):

CREATE TABLE Defendants (
DefendantID COUNTER , -- the JET autonumber, a long integer
LastName VARCHAR(30) NOT NULL ,
FirstName VARCHAR(15) NOT NULL ,
MiddleName VARCHAR(15) NULL ,
DateOfBirth DATETIME NULL , -- if required change to NOT NULL
Address VARCHAR(255) NOT NULL ,
City VARCHAR(30) NOT NULL ,
State VARCHAR(2) NOT NULL ,
ZipCode VARCHAR(5) NULL , -- if required change to NOT NULL
... other personal columns ...
)

CREATE TABLE Cases (
CaseID COUNTER ,
CaseNumber VARCHAR(15) NOT NULL PRIMARY KEY ,
... other columns ...
)

CREATE TABLE DefendantCases (
DC_ID COUNTER NOT NULL , -- put a unique index on this
DefendantID INTEGER NOT NULL REFERENCES Defendants
ON DELETE CASCADE ,
CaseID INTEGER NOT NULL REFERENCES Cases
ON DELETE CASCADE ,
CONSTRAINT PK_DefendantCas es PRIMARY KEY (DefendantID, CaseID)
)

In response to the poster who said table names should be in the singular
rather than the plural - use the plural 'cuz the table holds more than
one Case, Defendant, etc.; therefore, the plural is a more accurate
indication of what is in the table.

The PK for people (Defendants) is always hard, 'cuz there can be more
than one person w/ the same first, last and middle names. Even the DOB
can be the same! If you have location ID like the ZipCode you, maybe,
could use First, Last, DOB and ZipCode as a PK for Defendants. There
always is the possibility of the data-entry op misspelling one of the
names & causing a duplicate Defendant entry.

In the DefendantCases table the REFERENCES is a Foreign Key constraint
that will only permit DefendantIDs that are already in the table
Defendants and CaseIDs that are already in the table Cases.

The PK for DefendantCases is the DefendantID & the CaseID. This means
you can have more than one Defendant on the same Case, but you can't
enter more than one of the same defendant/case combinations. The ON
DELETE CASCADE clause means if the Defendant record is deleted in
Defendants it's dependent record in DefendantCases will also be deleted;
and, if the Case record is deleted in Cases it's dependent record in
DefendantCases will also be deleted.

Your table tbl_Appearances should be like this:

CREATE TABLE Appearances (
DC_ID INTEGER NOT NULL REFERENCES DefendantCases
ON DELETE CASCADE ,
AppearanceTypeI D INTEGER NOT NULL REFERENCES AppearanceTypes ,
App_Date DATETIME NOT NULL , -- includes both date & time
ProsecutorID INTEGER NOT NULL REFERENCES Prosecutors ,
Offer VARCHAR(255) NULL ,
PleaID INTEGER NULL REFERENCES Pleas ,
Disposition VARCHAR(255) NULL ,
CONSTRAINT PK_Appearances PRIMARY KEY (DC_ID, AppearanceTypeI D,
App_Date)
)

The DC_ID refers to the DefendantCases table, which indicates which
defendant in the case is appearing. The PK means that the defendant can
only appear at the indicated date/time for the indicated appearance
type. The defendant can appear many times on the same date for the same
or different cases.

The referenced tables AppearanceTypes , Prosecutors, and Pleas are "look
up" tables that will hold IDs, usually AutoNumbers for each
AppearanceType, Prosecutor & Plea. If the pleas can be more numerious &
variable than could be ennumerated in a list, then you may want to have
a VARCHAR data type instead of the INTEGER reference to the Pleas table.

There are probably more things here that could be addressed....

HTH,
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQeLlmoechKq OuFEgEQJcQACg/UkFRDpaBaL+T/E5qc1Fr5qklBwAo IhR
EKXZntkkVxCljTB E2bEpttoP
=VhRG
-----END PGP SIGNATURE-----

fl******@bellso uth.net wrote:
Work in legal office. Trying to create solid designed database
structure. This is list of tables w/fields and primary keys. Any
comments/advice greatly appreciated.
tbl-Defendants
CaseNumber (primary key)
FirstName
MiddleName
LastName
DOB
Race
Gender
tbl-JunctionCharges ToDefendantsCas e
CaseNumber
ChargeID
tbl-Charges
ChargeID (auto-number assigned Primary Key)
Statute
Description
ChargeType
tbl-ChargeTypes (used as combo box in form)
ChargeTypeID (auto-number assigned Primary Key)
Municipal
County
State
Federal
tbl-Prosecutor (used as combo box in form)
BarNumber (Primary Key)
ProsecutorName
tbl-Appearance
AppearanceID (auto-number assigned Primary Key)
CaseNumber
AppearanceType
Date
Time
ProsecutorName
Offer
Plea
Disposition
tbl-AppearanceTypes (used as combo box in form)
AppearanceTypeI D (auto-number assigned Primary Key)
FirstAppearance
Arraignment
DocketSounding
PleaDay
Trial

Notes: Defendants may have more than one case number but case number
can only have one defendant.

Case numbers may can have more than one charge and a charge can have
many cases.

A case has a structured set of appearence types:

First Appearance
Arraignment
Docket Sounding
Plea Day
Trial

Due to various reasons, a case may have more than one of these
appearance types.

Nov 13 '05 #6
"MGFoster" <me@privacy.com > wrote:
Don't use AutoNumbers as Primary Keys (PK). You can assign a Unique
Index to the AutoNumbers if you want to use them as FK linking columns
in other tables. PKs should identify the row's data in the "real
world."

Example: Will the CaseNumber identify the defendant if you went to the
courthouse and asked who was the defendant on Case # 12345? Would that
be the only defendant on that case? If there is more than one defendant
on that case then that breaks the PK. Therefore, you should have the a
Defendants table without the CaseNumber. You should have a joing table
"DefendantCases " w/ the Defendant's ID number and the CaseID. Here are
DDLs of two tables (JET SQL):
I don't like to disagree - generally - more specifically with those who
likely have more experience than I - yet to flat-out advise to "Don't use
AutoNumbers as Primary Keys" seems to be unhelpful - as does the statement
that "PKs should identify the row's data in the "real
world." The OP was not seeking a philosophical discussion, just advice.
I'm sure that several here can attest that there are points of view on this.

And isn't this what you are advising here?
CREATE TABLE Defendants (
DefendantID COUNTER , -- the JET autonumber, a long integer -----------------------------------------------------------------------
In response to the poster who said table names should be in the singular
rather than the plural - use the plural 'cuz the table holds more than
one Case, Defendant, etc.; therefore, the plural is a more accurate
indication of what is in the table.


Again, there are two points of view on this, right? Why involve the OP in
this disagreement? Does the OP care? My advice to use the singular is
based on entity modeling - which is where the OP is right now. Here are
some other points of view:

http://discuss.fogcreek.com/joelonso...ow&ixPost=5904

http://www.hower.org/Kudzu/Articles/DBDesign/index.iwp

http://www.anticlue.net/archives/000076.htm

http://dbazine.com/gulutzan5.shtml

(etc)

Oracle seems to be consistent with preferring the plural form - but then,
this is an Access NG.

The OP was not consistent in singular vs. plural (tbl-Charges,
tbl-Prosecutor, tbl-Appearance, tbl-Defendants), so I was advising the
singular - which is not *wrong*, just not your preference. So why bring it
up in this thread?

Darryl Kerkeslager


Nov 13 '05 #7
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Row objects are supposed to model the "real-world" therefore, the PK
(which prevents duplicates by uniquely identifying the row's real-world
object) should not be an AutoNumber, which is a system-generated
identifier that has NOTHING to do w/ the real-world object. The
AutoNumber as a Unique Index is a great way to link (Foreign Key - which
requires an indexed column(s) in the parent table) to related data in
other tables, w/o including the parent's, possibly, multi-column primary
key values/columns in the related table. That's why I use them. I will
never use them as the ONLY column in a PK. My definition of the
Defendant's table did not have a PK 'cuz it would take more than one
column to uniquely identify each defendant (row). The choice of those
columns is up to the db designer 'cuz s/he has a better understanding of
the data that will be entered & the db's requirements. The AutoNumber
just "says" this is a row. The PK "says" these columns uniquely
identify this row - IOW, all the rows in the table refer to different
people.

See these sites for my views on PKs espoused by others:

http://builder.com.com/5100-6388-5034792.html
http://www.blueclaw-db.com/table_design/
http://en.wikipedia.org/wiki/Weak_entity
http://www.15seconds.com/issue/020522.htm

Singular vs. Plural - I gave an opinion & a reason 'cuz I didn't agree
w/ your statement (which you made w/o any reason). Again, our opinions.
What I think we can both agree on is consistency in naming conventions,
no matter the style. As you say there are differing opinions on naming
conventions. I just stated mine, which I consider right :-) (don't we
all?).

Rgds,
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQeM/2IechKqOuFEgEQK +vgCeKDY2nPmGHC u1pRQL5Eh2cAKKu HkAnRb6
3rt1EH0dCoi2Agg CF40tU3V+
=45Zg
-----END PGP SIGNATURE-----
Darryl Kerkeslager wrote:
"MGFoster" <me@privacy.com > wrote:
Don't use AutoNumbers as Primary Keys (PK). You can assign a Unique
Index to the AutoNumbers if you want to use them as FK linking columns
in other tables. PKs should identify the row's data in the "real
world."

Example: Will the CaseNumber identify the defendant if you went to the
courthouse and asked who was the defendant on Case # 12345? Would that
be the only defendant on that case? If there is more than one defendant
on that case then that breaks the PK. Therefore, you should have the a
Defendants table without the CaseNumber. You should have a joing table
"DefendantCas es" w/ the Defendant's ID number and the CaseID. Here are
DDLs of two tables (JET SQL):

I don't like to disagree - generally - more specifically with those who
likely have more experience than I - yet to flat-out advise to "Don't use
AutoNumbers as Primary Keys" seems to be unhelpful - as does the statement
that "PKs should identify the row's data in the "real
world." The OP was not seeking a philosophical discussion, just advice.
I'm sure that several here can attest that there are points of view on this.

And isn't this what you are advising here?

CREATE TABLE Defendants (
DefendantID COUNTER , -- the JET autonumber, a long integer


-----------------------------------------------------------------------

In response to the poster who said table names should be in the singular
rather than the plural - use the plural 'cuz the table holds more than
one Case, Defendant, etc.; therefore, the plural is a more accurate
indication of what is in the table.

Again, there are two points of view on this, right? Why involve the OP in
this disagreement? Does the OP care? My advice to use the singular is
based on entity modeling - which is where the OP is right now. Here are
some other points of view:

http://discuss.fogcreek.com/joelonso...ow&ixPost=5904

http://www.hower.org/Kudzu/Articles/DBDesign/index.iwp

http://www.anticlue.net/archives/000076.htm

http://dbazine.com/gulutzan5.shtml

(etc)

Oracle seems to be consistent with preferring the plural form - but then,
this is an Access NG.

The OP was not consistent in singular vs. plural (tbl-Charges,
tbl-Prosecutor, tbl-Appearance, tbl-Defendants), so I was advising the
singular - which is not *wrong*, just not your preference. So why bring it
up in this thread?

Darryl Kerkeslager

Nov 13 '05 #8
Lea
Sorry it has taken so long to respond to all. Seems like I'm always
putting out fires at work so I've been extremely busy. I appreciate all
the input and this morning I will sit down and analyze all this input
to get this project a little further along (as soon as I finish the
latest (yesterday's newest) Visio project.

I'll post back here once I get more advanced into the database details.

Once again, thanks for all the advice. It's great to have this user's
group and it's support.
MGFoster wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Row objects are supposed to model the "real-world" therefore, the PK
(which prevents duplicates by uniquely identifying the row's real-world object) should not be an AutoNumber, which is a system-generated
identifier that has NOTHING to do w/ the real-world object. The
AutoNumber as a Unique Index is a great way to link (Foreign Key - which requires an indexed column(s) in the parent table) to related data in
other tables, w/o including the parent's, possibly, multi-column primary key values/columns in the related table. That's why I use them. I will never use them as the ONLY column in a PK. My definition of the
Defendant's table did not have a PK 'cuz it would take more than one
column to uniquely identify each defendant (row). The choice of those columns is up to the db designer 'cuz s/he has a better understanding of the data that will be entered & the db's requirements. The AutoNumber just "says" this is a row. The PK "says" these columns uniquely
identify this row - IOW, all the rows in the table refer to different
people.

See these sites for my views on PKs espoused by others:

http://builder.com.com/5100-6388-5034792.html
http://www.blueclaw-db.com/table_design/
http://en.wikipedia.org/wiki/Weak_entity
http://www.15seconds.com/issue/020522.htm

Singular vs. Plural - I gave an opinion & a reason 'cuz I didn't agree w/ your statement (which you made w/o any reason). Again, our opinions. What I think we can both agree on is consistency in naming conventions, no matter the style. As you say there are differing opinions on naming conventions. I just stated mine, which I consider right :-) (don't we all?).

Rgds,
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQeM/2IechKqOuFEgEQK +vgCeKDY2nPmGHC u1pRQL5Eh2cAKKu HkAnRb6
3rt1EH0dCoi2Agg CF40tU3V+
=45Zg
-----END PGP SIGNATURE-----
Darryl Kerkeslager wrote:
"MGFoster" <me@privacy.com > wrote:
Don't use AutoNumbers as Primary Keys (PK). You can assign a UniqueIndex to the AutoNumbers if you want to use them as FK linking columnsin other tables. PKs should identify the row's data in the "real
world."

Example: Will the CaseNumber identify the defendant if you went to thecourthouse and asked who was the defendant on Case # 12345? Would thatbe the only defendant on that case? If there is more than one defendanton that case then that breaks the PK. Therefore, you should have the aDefendants table without the CaseNumber. You should have a joing table"DefendantCas es" w/ the Defendant's ID number and the CaseID. Here areDDLs of two tables (JET SQL):

I don't like to disagree - generally - more specifically with those who likely have more experience than I - yet to flat-out advise to "Don't use AutoNumbers as Primary Keys" seems to be unhelpful - as does the statement that "PKs should identify the row's data in the "real
world." The OP was not seeking a philosophical discussion, just advice. I'm sure that several here can attest that there are points of view on this.
And isn't this what you are advising here?

CREATE TABLE Defendants (
DefendantID COUNTER , -- the JET autonumber, a long integer


-----------------------------------------------------------------------
In response to the poster who said table names should be in the singularrather than the plural - use the plural 'cuz the table holds more thanone Case, Defendant, etc.; therefore, the plural is a more accurate
indication of what is in the table.

Again, there are two points of view on this, right? Why involve the OP in this disagreement? Does the OP care? My advice to use the singular is based on entity modeling - which is where the OP is right now. Here are some other points of view:

http://discuss.fogcreek.com/joelonso...ow&ixPost=5904
http://www.hower.org/Kudzu/Articles/DBDesign/index.iwp

http://www.anticlue.net/archives/000076.htm

http://dbazine.com/gulutzan5.shtml

(etc)

Oracle seems to be consistent with preferring the plural form - but then, this is an Access NG.

The OP was not consistent in singular vs. plural (tbl-Charges,
tbl-Prosecutor, tbl-Appearance, tbl-Defendants), so I was advising the singular - which is not *wrong*, just not your preference. So why bring it up in this thread?

Darryl Kerkeslager


Nov 13 '05 #9
"MGFoster" <me@privacy.com > wrote in message
news:xd******** *********@newsr ead3.news.pas.e arthlink.net...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Row objects are supposed to model the "real-world" therefore, the PK
(which prevents duplicates by uniquely identifying the row's real-world
object) should not be an AutoNumber, which is a system-generated
identifier that has NOTHING to do w/ the real-world object.


Sure. So what would you use as a primary key for defendents?

Mike
Nov 13 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
1418
by: dalyjason | last post by:
I'm trying to write an asp page line by line, as one would create a text file, only my file will end in .asp. One line simply writes a close ASP code tag, or FILECONTENTS=FILECONTENTS & "%>" When this line processed, an error occurs saying that the string was never terminated because the asp page attempting to write this line of code to a NEW asp page reads that close ASP tag (%>), as an actual close asp tag for itself, instead of a...
2
1858
by: James Coe | last post by:
ARGH! Any ideas why this might be happening? The code I'm using comes straight from the example in the VB.NET Help System. All I did was tweak the name= stuff to match my application. Server Error in '/ImageMaker' Application. ---------------------------------------------------------------------------- ---- Configuration Error Description: An error occurred during the processing of a configuration file
1
4114
by: lou | last post by:
This is the error that Visual Studio 2003 gives me when trying to open some of my Web Projects: "The Web server reported the following error when attempting to create or open the Web project located at the following URL: 'http://Localhost:/MyWebApplication'. 'HTTP/1.0 403 Access Denied'." Some web projects give a '500 Internal Server Error' when trying to open them. I'm having the problem with all .NET solutions on my system. They worked...
1
9453
by: chanmm | last post by:
I hit the problem in my WinXP can someone help me: The Web server reported the following error when attempting to create or open the Web project located at the following URL: 'http://localhost/webapplication1'. 'HTTP/1.1 500 Internal Server Error'. Regards
2
5583
by: Error when creating new asp.net applicat | last post by:
Hi, I'm getting this error when I create a asp.net application. The Web server reported the following error when attempting to create or open the Web projects located at the following URL: 'http://localhost/WebApplication1'. 'HTTP/1.1 500 Internal ServerError'. my system configuration is as follows:
5
1545
by: Bryan Dickerson | last post by:
I'm still struggling with this XML stuff. I've gotten this far: oSR = New System.IO.StringReader(oC.GetAllContacts(txCICust.Text, txCIType.Text)) oXML.LoadXml(oSR.ReadToEnd) sStr = "Found Contact Name: ".Concat(oXML.DocumentElement.SelectNodes("/Table/CI_NAME").Item(0).Value()) .... but I get an error on the LoadXml method that says: "Root element is missing." What does that mean?
2
1709
by: sakieboy | last post by:
When attempting to load an Oulook Object in ASP.Net (VB) I get the foloowing error on the Server: System.Security.SecurityException: Request for the permission of type System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed. Here's the code Dim objOutlook As New Outlook.Application Dim objOutlookMsg As Outlook.MailItem
3
7158
by: weston | last post by:
I'm making a foray into trying to create custom vertical scrollbars and sliders, and thought I had a basic idea how to do it, but seem to be having some trouble with the implementation. My thinking was: (a) create a div for the slider / scroll nub to move within (b) attach event handlers which, onmousedown, specify the slider/nub is moveable, and onmouseup, specify it's not (c) attach an event handler to the contaning div which,...
2
2027
by: Michael D'Angelo | last post by:
We have a machine running Windows 2000 which is running a 3rd party application. We recently installed ASP.NET 2.0 on the server to install some addons for this application. When attempting to browse to an asp.net site, we get this error in the event log: "aspnet_wp.exe could not be started. The error code for the failure is 80070522. This error can be caused when the worker process account has insufficient rights to read the .NET...
8
3155
by: J-P-W | last post by:
Hi, anyone got any thoughts on this problem? I have sales reps. that remotely send their data to an ftp server. The office downloads all files, the code creates an empty file, then downloads the data to it, then moves on to the next rep: ---------- conTARGETVisits = FTPLocation & "RepCallPlan" & Format(MyRepCode, "00")
0
7999
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
7931
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8423
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8411
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
6740
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
5885
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
3911
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3956
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1530
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.