Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> newbie question
I have just taken all of the training courses of Oracle and now I am expected to make a database and have it run on the web. Sounds like a rough task. Well I hope not. Right now I am starting with an easy project. I just want to be able to search for 5 different products that each have qualities of there own.
For instance CARS
I want to have
BRAND
MODEL
YEAR
CONDITION
PRICE
Should I make a separate table for BRAND, a separate table for MODEL, a
separate table for condition, and have one table that has
BRAND,MODEL YEAR, CONDITION, AND PRICE. I think I am making this way more
confusing than it is. What would be my advantage of making separate
tables or justing making one table where I insert all the data. Eventually
I want to be able to search for a type of car by every means possible (by
brand,car, price, condition , year) or all at the same time or any
combination of them.
Thank You
Patrick Hahn
Received on Thu Dec 18 1997 - 00:00:00 CST