Help with table normalization

[ProgramError]

I haven't yet created the table(s) yet. I have two fields one make the other model and I wish to put them in table(s) in a normalized fashion.
Should I...

have three tables, one with model, one with make and the other with look up feild to the model and make tables

or

have two tables one with model and lookup field to a make table.

or is there another way I should be doing this?


Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[r937]

what is a model? what is a make?

we can't help you if we don't know what these things are

r937.com | rudy.ca

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ProgramError]

r937, the model and make references are attributes, columns or fields depending on the theory used to describe them as indicated in the link kindly provided by PHV (the r937.com site).
I referred to them as fields as I thought I had indicated in my question. quote: "lookup field"

thanks


Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[r937]

can a model have multiple makes? can a make have multiple models?

if i knew what they were, i might be able to answer this myself, or at least take an educated guess

is a make like a version? is a model like a master? can a model have a model?

they are just words at this point, and you can't normalize a couple of words with any confidence...

r937.com | rudy.ca

 

[lespaul]

are you talking about cars? What is your database suppose to "do" when you're done with it? What other fields are you considering? Just two? Make and model? Any thoughts on tables?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[GKChesterton]

Observation 1:
Don't use "Look-Up Fields" !!!

http://www.mvps.org/ac

cess/lookupfields.htm

Observation 2:
A join table is required if more than one A may apply to B, and, more than one B may apply A. Otherwise, only a 1-way join is required, and no join table.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database[white].[/white]development[/blue], would it? [tab]-- Albert Einstein[/purple]​