Re: Structure Critique
Posted by: Rick James
Date: November 19, 2010 06:42PM

Looks like a clean example of Normalization.

Tags -- that should be 1:many, not what you have. That is, `tags` should not have `tag_id` and `tag_names`, but rather `product_id` and `tag_name` (one per row).

Borough -- possibly should not bother separating it out.

But... I can't really pass judgment on the schema without seeing the SELECTs you will use.

Options: ReplyQuote


Subject
Written By
Posted
November 18, 2010 03:27PM
Re: Structure Critique
November 19, 2010 06:42PM
November 23, 2010 05:46PM
January 31, 2011 04:49AM


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.