Results 1 to 19 of 19

Thread: [RESOLVED] Help with database normalization...

Threaded View

  1. Sep 9th, 2008, 09:12 AM #14
    kevchadders
    kevchadders is offline
    Hyperactive Member
    Join Date
    Jan 2008
    Location
    Merseyside
    Posts
    456

    Re: Help with database normalization...

    For the issue with multiple authors could you have AuthorGroupID in your Book table, which replaces the AuthorFName and AuthorLName.

    Then you could create a AuthorsGroup table and a Author table.

    AuthorsGroup Table (Two-Way Junction Table)
    AuthorGroupID (composite key)
    AuthorID (composite key)

    Author Table
    AuthorID (key)
    AuthorFName
    AuthorSName

    The AuthorsGroup table is a many to many realtionship between the Book table and the Author table

    e.g. A book has 3 Authors, Bill Jones, Fred Banks, Hillary Smith and another book has 1 Author which is Hillary Smith again.
    Attached Images Attached Images  
    Last edited by kevchadders; Sep 9th, 2008 at 09:19 AM.
    If I've helped, please RATE my post.

    Some Informative Links: [Useful T-SQL Factsheet ] [T-SQL DateTime DataType][10 Most Asked SQL Questions and Answers][Connection Strings Refs]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width