Re: Relational Database Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 11:26:07 -0500

Rob,

The first architecture, using the BookAssociations table, is much more
flexible, as it allows for the possibility of books being written by
multiple authors. So that's a much more realistic way of architecthing the
data.

Neither of these has any bearing on whether your database is 'relational',
however. The Relational Model of Data is the underlying theory behind the
DBMS's architecture itself, below the level at which your schema resides.
You should read a text on databases if possible. I highly recommend Chris
Date's _Introduction to Database Systems_. 

-- 
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Rob Meade" <robb.meade@NO-SPAM.kingswoodweb.net> wrote in message
news:zpOhd.5046$up1.975@text.news.blueyonder.co.uk...
> Hi all,
>
> Sorry if this isn't directly related to SQL Server, although that is my
> "weapon of choice" as it were...
>
> I have a few simple tables, and I'm trying to decide whether my planning
and
> thinking is correct.
>
> I want to ensure that I have a relational database, but my previous tables
> are 'related' through another table, can anyone confirm whether this is
> correct or not?
>
> for example:
>
> Authors
> --------
> AuthorID
> AuthorName
>
> Books
> -------
> BookID
> BookTitle
>
> BookAssocations
> ------------------
> AssociationID
> BookID
> AuthorID
>
>
> This is how I have things 'mostly' at the moment...but I'm wondering
whether
> in fact the structure should be like this:
>
> Authors
> --------
> AuthorID
> AuthorName
>
> Books
> -------
> BookID
> AuthorID
> BookTitle
>
>
> If anyone could chip in on this I would be grateful, I already have a
> database in use and I'm adding to it with the intention of going back and
> correcting the rest, but whilst I add new tables/views/stored procedures
and
> the like I would like to "get it right"..
>
> Your help is appreciated,
>
> Regards
>
> Rob
>
>

Relevant Pages

  • Please help if you have the time& patience (Setting up Relationshi
    ... I am trying to set up a simple database, just to keep a reading log ... I want to establish a relationship between; BookID, ... The bookID, AuthorID and Author ... that one Author will have many or more than one books. ...
    (microsoft.public.access.tablesdbdesign)
  • Author Help
    ... I have a database which is tracking old books. ... Title, FirstName, LastName) and tbl Book/Authors(BookId, AuthorID) ... e dot thoemmes at blueyonder dot co dot uk ...
    (microsoft.public.access.forms)
  • Re: Consolidate duplicate entries
    ... BookID and AuthorID if you want to record the ... Am rebuilding a book db which lists approx 40k of books, ... AuthSName and AuthFName are text fields while BookID and AuthorID are ...
    (microsoft.public.access.tablesdbdesign)
  • Re: A calculated field and a Master/Detail relationship
    ... I don't know if I understood the TQuery suggestion. ... > While authors have many books, ... > storing the BookId and the AuthorId as appropriate. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Please help if you have the time& patience (Setting up Relationshi
    ... Do you need to track times when you took out a book more than once? ... The answer may well be No if you are reading fiction, but it might be Yes if you are borrowing reference books. ... Your table of borrowings would then only have the BookID ... If so, you need a separate table of authors with an AuthorID, and your table of borrowings would only have the AuthorID ...
    (microsoft.public.access.tablesdbdesign)