Generalization, Specialization and Aggregation in ER Model – GeneralizationGeneralization is a process of generalizing an entity which. Generalization Aggregation – Learn DBMS in simple and easy steps starting from its The reverse is called specialization where a person is a student, and that. Generalization Aggregation – The concept of generalization (specialization) is associated with special types of entities known as superclasses and subclasses, .
|Published (Last):||15 March 2016|
|PDF File Size:||3.28 Mb|
|ePub File Size:||2.25 Mb|
|Price:||Free* [*Free Regsitration Required]|
The entity shall be a student, and further, the student is a person. For example, Saving and Current account types entities can be generalised and an entity with name Account can be created, which covers both. In this way, the specializatjon deliberation instruments used to model data: Hence, as part of the Enhanced ER Modelalong with other improvements, three new concepts were added to the existing ER Model, they were:.
Going up in this structure is called generalization, where entities are associated together xggregation represent a more generalized view. In basic terms, a gathering of substances in specialization can be classified into sub-bunches in view of their attributes.
In aggrregation words, aggregation is a process where the relation between two entities is treated as a single entity. In generalization, some entities are accommodated together into one generalized agggregation or category based on their similar characteristics.
So it is a top-down methodology in which one larger amount substance can be separated into two lower level element. Hence, entities are combined to form a more generalised entity, in other words, sub-classes are combined to form a super-class.
A distinct sub-grouping of occurrences of an entity type that require being represented in a data model. The relationship between a superclass and a subclass is one-to-one 1: In generalization, a number of entities aggregatlon brought together into one generalized entity based on their similar characteristics.
The normal qualities implies here properties or techniques.
This special kind of relationship is termed as an aggregation. Comments Edit Question Edit Categories. Similarly, in a school database, persons can be specialized as teacher, student, or a staff, based on what role they play in school as entities.
Generalization, Specialization and Aggregation Concepts in DBMS
As the hierarchy goes up, it generalizes the view of entities, and as we go deep in the hierarchy, it gives us the detail of every entity included. It is a top down approach in which we first define the super class and then sub class and then their attributes and relationships. Specialization is the opposite of generalization. In generalization, the higher level entity can also combine with other lower level entities to make further higher level entity.
Speculation Specialization is the opposite procedure of Generalization Collection Generalization in DBMS Speculation is an abstracting procedure of review sets of items as a solitary general class by focusing on the general attributes of the constituent sets while stifling or overlooking their disparities.
In the diagram above, the relationship between Center and Course together, is acting as an Entity, which is in relationship with another entity Visitor.
Generalization, Specialization and Aggregation in DBMS
Hence some improvements or enhancements were made to un existing ER Model to make it able to handle the complex applications better. Specialization is the abstracting procedure of acquainting new qualities with a current class of items to make one or all the more new classes of articles.
In specialization, a higher level entity may not have any lower-level entity specalization, it’s possible. In this way, it is a base up methodology as two or lower lever substances are consolidated to shape a more elevated amount element. Hence, as part of the Enhanced ER Modelalong with other improvements, three new concepts were spceialization to the existing ER Model, they were: An entity type that includes one or more dissimilar sub-groupings of its occurrences that is required to be represented in a data model.
Aggregration is a process when relation between two entities is treated as a single entity.
For example, a particular student named Mira can be generalized along with all the students. But in a company, persons can be identified as employee, employer, customer, or vendor, based on what role they play in the specialiaation. As the complexity of data increased in the late s, it became more aggregztion more difficult to use the traditional ER Model for database modelling. Generalization is a process of generalizing an entity which contains generalized attributes or properties of generalized entities.
Generalization, Specialization and Aggregation in ER Model
Responsive Theme powered by WordPress. The reverse is called specialization where a person is a student, and that student is Mira. A generalization is a bottom-up approach. These properties are common in all persons, human beings. We beneralization all the above features of ER-Model in order to create classes of objects in geheralization programming. It is a form of abstraction that specifies two or more entities sub class having common characters that can be generalized into one single entity super class at higher level hiding all the differences.