attribute and field help

[Rebecca]

i am designing a database for a company to record what
software they have and what software is on what macheine.
there is over 120 comps so you can emagine the amount of
work involved.

my question is what attributes are needed in the database
ie Software code, etc and how many tables i would require.

many thanks

 

[Donna]

Rebecca,

It all depends on how much information the company wants,
and what they're going to use it for.

You could use 2 tables (one parent and a child). The main
table could have a unique key for the machine (machine
serial number)and also include the company names. The
child table would include the machine number(sothat they
can be joined)and the software on the machine.


Hope this helps,

-- Donna