Database Design Help

shola0080 · #1 (**permalink**) 07-17-06, 18:00

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

loquin · #2 (**permalink**) 07-18-06, 12:17

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.

shola0080 · #3 (**permalink**) 07-18-06, 14:15

Thank you.
I'll try that!

Internet Services

Web Development

Digital Marketing

Consumer Tech