Help please

[vdj]

Hi,
I'm wanting to create a database where i can index a newspaper. I want to include, Article title, Issue no., Volume no., Date, Personal name, and Subject. Do I include all of these in one table? Or, have Article title, date, issue, volume as one table and then have Personal name, date, issue, volume as another table and link them that way?? I may have a bunch of subjects for one article title or more than one personal name for each issue. I'm new at this - only done address databases so i'm in need of some help. thanks so much!

 

[Crowley16]

there are so many things to think about when designing a database which depend on various factors that only you can know the "best" way to do things.

I suggest you read some design books first, and ask specific questions, because a general question like that can have so many different answers it wouldn't really do you any good.

--------------------
Procrastinate Now!

 

[lespaul]

A must read before you start designing:

The Fundamentals of Relational Database Design


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual