Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2010
    Posts
    4

    Unanswered: create one or more tables?

    Hi,
    Im starting my first database, Im using access2007. I decided to list all of my books and create all this fields...
    Do I need to divide those fields into 2+ tables and link them afterwards or perhaps only 1 complete table will be fine?

    Book ID (autonumber)
    Book Title (text)
    Author Last Name (text)
    Author First Name (text)
    Publisher (text)
    Year the book has been published (number)
    Language of the book (text)
    Genre (text)
    Book Binding (hardback-paperback)
    Rating (number)
    Year First Release (number)
    Book cover (image)

    Thanks for your replies.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Depends on how you want to use the data.

    What questions would you like this database to be capable of answering?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jan 2010
    Posts
    4
    I`d like it to retrieve records based on :

    Book title
    Author
    Publisher
    Genre
    Language
    Rating
    ........

    pretty much every fields. Querying the database, I would get all book in "English" language.

  4. #4
    Join Date
    Jan 2010
    Posts
    4
    Quote Originally Posted by bulma View Post
    Querying the database, I would get all book in "English" language.
    This was an example. It should answers many questions in order to filter out the few records.
    Thanks

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so you need to look at database design
    have a look at normalisation

    Fundamentals of Relational Database Design -- r937.com
    or
    The Relational Data Model, Normalisation and effective Database Design
    are good places to start

    in essence you should try to desing your tables so that only one piece of information is stored

    ferisinstance if you are storing author you should store the name once and use a foreign key to reference that author in the books table, similar to language, genre and so on.

    for author you may need to allow for multiple authors ie there is not a direct link between the book and the author, you may need an intersection table to allow for multiple authors on a single book.

    you ought to select a primary key if you want to use a relational db, and there is at least one natural key for that the ISBN number, however if your publications may not have an ISBN in issue then you need to develop another candidate primary key. note ISBN numbers have recently changed in size from 10 to 13 digits so your code should handle that.
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Jan 2010
    Posts
    4
    I have lot to learn.
    I think I`ll start reading the 2 links.
    Thanks again!

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by bulma View Post
    I have lot to learn.
    I think I`ll start reading the 2 links.
    Thanks again!
    Well done sir\ madam! That is the correct response. All too often people see those links and ignore them, thinking reading them is too much effort. Designing your database correctly in the first place will save you incalculable time and effort in the long run.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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