I am creating a stock control application.
I have a table called "equipment_type" that stores a general
description of a piece of equipment. This could be for instance: Canon
60D DSLR camera.
I also have an table called "equipment" that stores all the equipment
we have with their serial numbers. There may be many Canon 60Ds and
they should refer to the "equipment_type" table for their description.
Is this a one-to-one association, because they have only one
Or is this a one-to-many, because one "equipment_type" is related to
Thanks for your help