Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    2

    Database Design Help

    Hello,

    I need to create an inventory website for different system groups, I'm having difficulty with possible duplicate information for each table/group. I have 3 table I need to connect.Such as version #. I need to connect the hardware to a particular software which can also be used in another group.

    Table 1:
    Code:
    GroupID	Name	Purpose	   contact     Email   	Phone Number
    SLAB	System	Test	    Jon	      Johl@IKNOW	612-245-1111
    Elab	Elab	Dev.           Phil	     Phi@UKNOW	475-124-1111
    Table2:
    Code:
    hardwareId group	Asset	 Quantity Manufacturer   Type       Version
    1	Elab     xSeries 326    2	    IBM	        Server      326 
    2	Slab    BladeCenter    1	    IBM	        Chassis     H
    3	Slab    LS20 Blades    8	    IBM	       Server       L20
    Table3:
    Code:
    SoftwareID Group Assest Quantity  Manufacturer      Operat.System    Version
    Last edited by loquin; 07-18-06 at 13:14. Reason: add [code] [/code] tags for readability.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    It appears that you need to define a many-to-many relationship between the hardware and the software.

    A many-to-many relationship is created by defining an intersection table.

    For starters, I would suggest that you review the first two posts in this tutorial.
    Last edited by loquin; 07-18-06 at 13:25.
    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


  3. #3
    Join Date
    Jul 2006
    Posts
    2

    Post thanks

    Thank you.
    I'll try that!

Posting Permissions

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