Re: About Entity Relation Diagram

From: Silver <argytzak_at_med.auth.gr>
Date: Fri, 17 Dec 2004 21:28:47 +0300
Message-ID: <cpvc1c$7mi$1@nic.grnet.gr>

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

I have a table called "EyeColor" with the columns eyeColodCode and Description. I then include in the entity member the foreign key eyeColorCode
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 - 12:28:47 CST