Question

Topic: Database Design - Entity Relationship Modeling (Please answer the below question in 250 words or more). Thank you!

If you have an entity with 100 different attributes, what would be some strategies to model this entity? Why/Why not would you want to use a single entity? What are some questions you would want to know about the individual attributes?

Answer 1

Entity can be person,place,event or object that is relevant to the system.and attribute is properties or characterstixs of entity.,attribute represents certain characcterstics of entity for a person attributes might be name ,age,address etc.sometimes we use more attributes because it gives unique identification for all other elements.

if there are 100 attributes we shoukd first check if there are repeated scheme or not and there may be many distinct values entered for same coloum of its row.suppose a company can have many divisons some of them may be in different cities here company will be entity and division name will be attribute head quarters attribute will be single valued attribute. so the startegies will be first we shoul classify which entity and attributes and classify them and accordingly we should see which all re single valued attribute which all are multivalued attribute and which all attributes classify the entity then we can make the ER model .for this first we should identify entity and identify all the relationships and then add all the attributes.if we use single entity it will be complex and restrictive .and single entity we can use if there are similar kind of id.individual attribute gives details of each entity set so for each and ever entity set we should check attributes