MySQL Forums
Forum List  »  Newbie

normalization
Posted by: Taylor Collins
Date: August 18, 2005 10:15AM

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

Options: ReplyQuote


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.