table help PLEASE!!!!!

[Rebecca]

can someone please help me i am currently trying to create
a database on software used within a company and also all
of the computers used within the company. can anyone give
me any idears to the tables i need and the attributes i
should put in them.

cheers!!
Becky

 

[Dan Artuso]

Hi Becky,
Here's some thoughts on the tables. The attributes really depend
on what is relevant to you to keep track of.

You'll need at least something like this:

Users table
Software table
Computers table (if you want to keep track of hardware it gets more complicated)
Rooms

Now to relate everything you'll need
UserComputer (contains the User primary key and Computer pk)
ComputerSoftware (contains Computer pk and Software pk)
UsersRooms (contains Users pk and Rooms pk)