Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    1

    Unanswered: Database Relationships

    Hello everyone,

    I have worked with databases, and have created simple databases.

    I am not real familiar with designing databases and defining relationships.

    I know how to actually create the relationships between tables with primary keys and stuff, but what I am not sure of is the logic of database design and the use of relationships.

    What I want to do is have a table with a list of computers, specs, etc.

    Then have other tables, each one representing a vendor, and listing that vendors applications (Like having table with a list of microsoft applications).

    Then what I want to do is create some type of relationship where I can check off whether a certain application from a certain vendor is installed on a certain computer.

    I know how to create forms and everything, I am just not sure how I should design the tables and create the relationships.

    I hope I explained everything well enough.

    If anyone has any suggestions, I would appreciate it.

    Thanks,
    David

  2. #2
    Join Date
    Dec 2005
    Location
    Texas
    Posts
    13
    Hey David,

    Here's 3 links that you may find useful. After reading your link, I think you may find these helpful. Hopefully.

    Shane


    http://www.utteraccess.com/forums/sh...b=5&o=&fpart=1

    http://oldweb.uwp.edu/academic/mis/baldwin/normal.htm

    http://www.datamodel.org/NormalizationRules.html

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Here are some database tutorials I wrote a while back on referential integrity and normalization.

    http://www.xtremevbtalk.com/showthre...185#post969185
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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