I haven't had much experience with databases since my one class in
college. Now I need one, or at least a prototype for my application
that I can make into a real database later.
At any rate. I cranked it up Access and made my first table:
Table: Goods
Description: Something to represent all goods that may exist in my
application's universe
Name - Text Primary Key
Base Value - Number
Now my second table is giving me trouble.
I need something to represent requirements to manufacture a good. For each
good that exists, its manufacture requires many <Good Name, Number
Required>
'sets'
For example
Maufacture of 1 Laser requires: 2 units of Energy, 2 units of chips, 1
unit
of computers, 1 unit of machinery...or something like that.
I want to store those requirements in the DB
The table is related to itself :( So I figure a new table is needed, but I
have no idea how to represent this in my database! I remember my
instructor
teaching us how to resolve one to many or many to many relation****ps and
finally wanting to end up with one to one... I think.
Anyway, can anyone help me out with some advice?
Also some good reference materiel resources are appreciated if free and
unbloated. I just want the basics to get things up quickly. Not 700 pages
on
DB administration, stored procedures, triggers, etc.
Thanks!
|
