MySQL Forums
Forum List  »  Optimizer & Parser

Re: Selecting a proper table stucture
Posted by: Anthony Willard
Date: June 07, 2006 09:47AM

Your first solution is properly normalized. You can then create a view to provide a summary of a person's selected skills.

Your second solution is incomplete as it does not account for a person's skills, only the people and available skills. You need a third table to represent a person's skills - either like option 1 or with a snapshot of the skills selected. The latter is prone to problems with discontinued or relabeled skills and violates a normalization principle.

Options: ReplyQuote


Subject
Views
Written By
Posted
3201
June 07, 2006 04:07AM
Re: Selecting a proper table stucture
1982
June 07, 2006 09:47AM


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.