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

    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.


  2. #2
    Join Date
    Dec 2005
    Hey David,

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


  3. #3
    Join Date
    Jun 2004
    Arizona, USA
    Here are some database tutorials I wrote a while back on referential integrity and normalization.
    "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