Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    3

    On Normalization

    Hi everyone,
    I am working on a project, and right now I need to normalise my tables (just on paper, nothing with SQL so far), to break them where they defy the norms.
    Among my other tables I have one for the Author of books with various attributes. Some of these are: author id, last name, first name, genre, etc. I need to break this table in two, so I can place the genres in another table, since one author can have many genres (history, crime, fiction, etc). What I did is shown in the attached picture of an Excel file, however I think it's somehow wrong. Could anyone have a look at give me an idea whether it's ok? I am confused as to how can I link this to other tables and my main concern is that it doesn't have a primary key unless I take both columns as such, and then is the table enough only with those? It just doesn't seem right somehow...

    Thanks for any hints/suggestions,
    K
    Attached Thumbnails Attached Thumbnails normalization.jpg  

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    At a glance you've created an Author-Genre association table, which is fine.

    http://www.utexas.edu/its/windows/da.../refining.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •