June 30, 2020   |   by admin

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: Gujind Kigasar
Country: Luxembourg
Language: English (Spanish)
Genre: Environment
Published (Last): 14 April 2015
Pages: 497
PDF File Size: 8.97 Mb
ePub File Size: 10.30 Mb
ISBN: 764-5-54131-661-8
Downloads: 13184
Price: Free* [*Free Regsitration Required]
Uploader: Samugis

Generalization, Specialization and Aggregation in ER Model | Studytonight

Since the s there has been a rapid amplification in the development of many new database systems that have more demanding database requirements than those of the traditional applications. As the basic concepts of ER modeling are often not enough to represent the requirements of the newer complex applications which therefore stimulated the need to develop additional ‘semantic’ modeling concepts.

Various semantic data models have been proposed, and some of the most important semantic concepts have been successfully incorporated into the original ER model.


In this chapter, you will learn about the main two important concepts. The concept of generalization specialization is associated with special types of entities known as superclasses and subclasses, and the process of attribute inheritance. The ER Model has the capability of articulating database entities in a conceptual hierarchical manner.

As the hierarchy goes up, it generalizes the view of entities, and as you go deep in the hierarchy, it will provide specializatioj the detail of every entity included.

Going up in this structure is called generalization, where entities are associated together to represent a more generalized view. A generalization is a bottom-up approach.

Generalization, Specialization and Aggregation Concepts in DBMS

In generalization, some entities are accommodated together into one generalized entity or category based on their similar characteristics. In the below-mentioned speciaization, whale, shark, and dolphin are generalized as fish, i. An entity type that includes one or more dissimilar sub-groupings of its occurrences that is required to be represented in a data model.

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: A relationship represents a connection between two entity types that are conceptually at the same level. Sometimes you may want to model a ‘has-a,’ ‘is-a’ or ‘is-part-of’ relationship, in which one entity ebms a larger entity the ‘whole’ that will consist of smaller entities the ‘parts’.


Generalization, Specialization and Aggregation in DBMS

This special kind of relationship is termed as an aggregation. Aggregation does not change the meaning of navigation and routing across the relationship between the whole and its parts. An example of aggregation is the ‘Teacher’ entity following the ‘syllabus’ entity act as a single entity in the relationship.

In simple words, aggregation is a process where the relation between two entities is treated as a single entity. C Tutorials C Programs. JavaScript Tutorials jQuery Tutorials.