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. Terms such as superclass, subclass, or inheritance come to mind when thinking about the object-oriented approach. These concepts are very important when. Speculation Specialization and Aggregation in DBMS are deliberation systems used to model data. The reflection is the instrument used to shroud the.

Author: Fauk Daimi
Country: Hungary
Language: English (Spanish)
Genre: Relationship
Published (Last): 5 July 2015
Pages: 458
PDF File Size: 16.5 Mb
ePub File Size: 1.11 Mb
ISBN: 388-9-31619-183-7
Downloads: 85634
Price: Free* [*Free Regsitration Required]
Uploader: Shale

This special kind of relationship is termed as an aggregation.

As the hierarchy goes up, it generalizes the view of entities, and as you go deep in the hierarchy, it will provide with the detail of every entity included. In the below-mentioned figure, whale, shark, and dolphin are generalized as fish, i. The relationship between a superclass and a subclass is one-to-one 1: In this way, it is a base up methodology as two or lower lever substances are consolidated to shape a more elevated amount element. In this chapter, you will learn about the main two important concepts.

The Enhanced ER Model

The specialization of student allows us to distinguish among students according to whether they are Ex-Student or Current Student. JavaScript Tutorials jQuery Tutorials. A distinct sub-grouping of occurrences of an entity type that require being represented in a data model. Aggregation represents relationship between a whole object and its component. In specialization, a group of entities geberalization divided into sub-groups based on their characteristics.

The entity shall be a student, and further, the student is a person. A person has name, date of birth, gender, etc. Hence some improvements or enhancements were made to the existing ER Model aggregwtion make it able to handle the complex applications better.


It is a top-down approach in which one higher level entity can be broken down into two lower level entity. 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 is a Bottom up process. On the basis of the commonalities, generalization synthesizes these entity sets into a single, higher-level entity set.

Aggregration is a process when relation between two entities is treated as a single entity. Specialization It is opposite to Generalization.

As the complexity of data increased in the late s, it became more and more difficult to use the traditional ER Model for database modelling.

Another type of total says that it is abstracting a relationship in the middle of articles and survey the relationship as an item. It is a top down approach in which we first define the super class and then sub class and then their attributes and relationships. Notation of Generalization Generalization is represented by a triangle with a line.

We use all the above features of ER-Model in order to create classes of objects in object-oriented programming. Comments Edit Answer Report. In basic terms, Generalization is a procedure of removing normal attributes from two generalziation more classes and joining them into a summed up superclass.

Generalization, Specialization and Aggregation in ER Model | Studytonight

Specialization is the opposite of generalization. Specialization is dbmss to Generalization. In this way, the two deliberation instruments used to model data: 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. For example, the aggrfgation of a Person class such as name, age, and gender can be inherited by lower-level entities such as Student or Teacher.


Download our mobile app and study on-the-go. Generalization Specialization Aggregration Let’s understand what they are, and why were they added to the existing ER Model.

These properties are common in all persons, human beings. In simple terms, Aggregation is a process when relation between two entities is treated as a single entity. The entity that is created will contain the common features. In generalization, a number of entities are brought together into one generalized entity based on their similar characteristics.

Explain Generalization, Specialization & Aggregation with the help of an example

Generalization proceeds from the recognition that a number of entity sets share some common features. 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. Aggregation does not change the meaning of navigation and routing across the relationship between the whole and its parts.

An entity type that includes one or more dissimilar sub-groupings of its occurrences that is required to be represented in a data model. In generalization, the higher level entity can also combine with other lower level entity to make further higher level entity. It allows lower-level entities to inherit the attributes of higher-level entities.

Sometimes you may want to model a ‘has-a,’ ‘is-a’ or ‘is-part-of’ relationship, in which one entity represents a larger entity the ‘whole’ that will consist of smaller entities the ‘parts’. Aggregation is an abstraction through which relationships are treated as higher-level entities.

Subscribe US Now