views:

222

answers:

1

if the dgree of an entity is 8. What is the minimum number of attributes required to form the primary key??...Thanks.....

+1  A: 

Entitys don;t have "degree". What you may be referring to is the Degree of a relationship, and what is sometimes referred to as a "Dgeree of an Entity" relationship. If this is what you are asking about then the "Degree of a Relationship" in an RDBMS is the count of entities involved in that relationship.

i.e., in a relationship between a product and the store that carries it, there are two entities (product and Store) and so it is a binary relationship (Degree = 2) In a relationship between vendor and store, there could be three entities involved (vendor, product, and store) so this would be a ternary relationship (Degree=3)

In general RDBMS do not model ternary or higher degree relationships directly, they require that you implement them with multiple binary relationships (in e.g., you would need Vendor-> Product and Product-> Store relationships...

Charles Bretana