database design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A manufacture table stores make, model, price, colour and options information.
The available make calibras has two models 2.0i and 2.0i16v and bmw car two
models p610 and p612.

My question how to create a database that doesn't allow the user to enter
the make of the car as bmw and model as 2.0i.
 
A manufacture table stores make, model, price, colour and options information.
The available make calibras has two models 2.0i and 2.0i16v and bmw car two
models p610 and p612.

My question how to create a database that doesn't allow the user to enter
the make of the car as bmw and model as 2.0i.
Click to expand...

Typically one would have two tables in a one to many relationship: Makes
related one to many to Models. The Models table would have a Make field as a
foreign key, referential integrity enforced, to the Makes table. Only
authorized users would be allowed to add records to the Models table (and
you'll have to have some trusted user, maybe yourself).

John W. Vinson [MVP]
 
Back
Top