In this post, I will discuss about how to identify Entity Type in Data Base Designing, Property of entity types, How to make good definition of an Entity Type in Data Modeling.
How to identify Entity Type in Data Base Designing?
Below mentioned are the points to be considered:
- What information is required by business?
- Things that are of interest to the business that needs to be remembered in order to manage and track them.
- Things belong to the same entity type have common characteristics.
Property of entity types:
Property of entity types are as mentioned below:
- Name
- Description
- Identifier
- Properties: Estimated number (Max, min, average) of entity instances.
- Expected growth rate of entity instances
- Subject Area in which the Entity type resides.
- Attributes the describe the entity types
- Examples of entity instances.
How to make good definition of an Entity Type?
We can derive good definition for entities if we can satisfy below mentioned parameters:
- Compatible
- Precise
- Concise
- Clear
- Complete