Re: Database design question

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Tue, 07 Nov 2000 05:11:12 GMT
Message-ID: <20001107.5111200_at_mis.configured.host>


>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 11/6/00, 12:24:22 PM, Gary Benson <gary.benson_at_digitalmail.com> wrote  

regarding Database design question:

> Hi,
 

> I'm a bit of a newcomer to relational databases, and I have a question
 

> about how best to implement something. Hopefully I have the right NG..
.

> Basically, I have a database of technical papers, each with a variable
 

> number of authors. The authors are currently stored as a semicolon
> delimited text field.
 

> So that I can find papers with the same authors, I need some way to
> remove this delimited list. Currently what I have done is to create 2
> new tables, authors and authors lut. Authors contains a unique integer
 

> Id and a text field containing the author's name, and authors lut
> contains the integer Id of the author and the integer Id of the articl
e.

> Thus, each author has one entry in the authors table, and one entry pe
 r
> paper in the authors lut table. This works fine, but the data
> representing the author's names is stored twice, once in each paper th
 ey
> wrote and once in the authors table. To fulfil my quest for efficiency
 ,
> is there any neater way of doing this?
 

> Thanks,
 

> Gary

> Sent via Deja.com http://www.deja.com/
> Before you buy.

        You should have three tables:

	Authors:
		Author id
		Name

		One entry for each author being tracked.
		Index on Author id

	Papers
		Paper id
		Title

		One entry for each paper being tracked.
		Index on Paper id

	Authors Papers
		Author id
		Paper id


		For each paper there is one entry per author in the authors papers 
table.  
		Index on Author id
		Index on Paper id
Received on Tue Nov 07 2000 - 06:11:12 CET

Original text of this message