attribute and field help

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

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
 
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
 
Back
Top