normalization
Could anyone please tell me if this is normalized in 3NF correctly? Thanks so much.
INFO
info_id (PRIMARY KEY)
product_info_id (FOREIGN KEY)
stores_id (FOREIGN KEY)
model_id (FOREIGN KEY)
age_group_id (FOREIGN KEY)
comments_id (FOREIGN KEY)
serial_id (FORIEGN KEY)
first_name
last_name
email
street
city
state
zip
PRODUCT_INFO
product_info_id (PRIMARY KEY)
date_purchased
price
reasons_1
reasons_2
features_liked
features_added
STORES
stores_id (PRIMARY KEY)
store_name
MODEL
model_id (PRIMARY KEY)
model
SERIAL
serial_id (PRIMARY KEY)
serial
AGE_GROUP
age_group_id (PRIMARY KEY)
age_group
COMMENTS
comments_id (PRIMARY KEY)
comments
Subject
Written By
Posted
normalization
August 18, 2005 10:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.