Re: About Entity Relation Diagram

Hi again,

before I continue, I must thank you all for replying to this post !!

After reading some things I begin to get a grasp of how things works.with database modelling. The question I have now has to do with the implementation of the database.

As you remember (I hope so...) it's about a dating site. I have to include in the entity member a whole lot of info, such as eyeColor, hairColor, bodyType, etc. This can be done with two ways

1. I have a table called "EyeColor" with the columns eyeColodCode and Description. I then include in the entity member the foreign key eyeColorCode
2. I introduce a third table (one is Member, two is EyeColor) where I list the memberID and the eyeColorCode.

Which of the above implementation is better? The 2. involves 3 tables but it seems to offer greater flexibility in making queries.

Thanks!! Received on Fri Dec 17 2004 - 19:28:47 CET