One or two tables ?

[pedro]

In a DB cataloguing journal articles, tblCatalogue links via an M-M
transition table to tblAuthors identifying the article author
name(s). I wish to extend the DB to cover persons cited in the
articles, thus requiring a new table (e.g. tblPersonsCited ). However,
to the extent that persons cited may also be authors, this would imply
duplication. Is there a way to set up a single table (e.g.
tblPersons) to cover both authors and persons cited ?

[Roger]

Re: One or two tables ?

On May 14, 3:40 am, pedro <PeterGFar...@g mail.comwrote:

In a DB cataloguing journal articles, tblCatalogue links via an M-M
transition table to tblAuthors identifying the article author
name(s).  I wish to extend the DB to cover persons cited in the
articles, thus requiring a new table (e.g. tblPersonsCited ).  However,
to the extent that persons cited may also be authors, this would imply
duplication.  Is there a way to set up a single table (e.g.
tblPersons) to cover both authors and persons cited ?

tblCatalogue
catalogId
catalogDesc

tblPerson
personId
personName

tblCataloguePer son
catalogId
personId
author (yes/no)
cited (yes/no)