Downloaded 118 times
Uploaded byNirali Akabari
Ppt of dbms e r features
This document discusses entity-relationship (E-R) modeling concepts including specialization, generalization, aggregation, and redundant relationships. It provides definitions and examples of each concept. Specialization defines subclasses based on distinguishing attributes. Generalization defines a superclass from common attributes of subclasses. Aggregation treats relationships as higher-level entities. An E-R diagram example shows representing aggregation. Another example shows a diagram with redundant relationships.
In this document
Powered by AI
Introduction of Gandhinagar Institute of Technology, Department of IT, and group members details.
Overview of key topics in the presentation: E-R concept, specialization, generalization, aggregation, and E-R diagram notation.
Introduction to E-R model by Chen (1976), explaining it as a high-level data model for conceptual schemas.
Basics of E-R diagram notation including entity sets, attributes, and relationship sets.
Definition of specialization as subclass formation based on distinguishing features within E-R models.
Definition of generalization as the process of forming a superclass from subclasses based on common characteristics.
Explains the relationship between specialization and generalization, noting their similar representation in E-R diagrams.
Definition of aggregation as abstracting relationships as higher level entities within E-R diagrams.
Illustration of E-R diagram specifically exemplifying aggregation concepts.
Representation of E-R diagrams that illustrate redundant relationships.
More Related Content
Similar to Ppt of dbms e r features
Ppt of dbms e r features
- 1. GANDHINAGAR INSTITUTE OF TECHNOLGY Departmentof Information Technology E-R Features Group ID: IT_A1_10 Students Names: Akabari Nirali (130120116002) Akanksha Sharma (130120116003) Guided By: Prof. Anirudhdha Nayak Database Management System(2130703)
- 2. Presentation outlines: E-Rconcept Specialization Generalization Aggregation E-R diagram notation for representing specialization E-R diagram with redundant relationship E-R diagram with Aggregation
- 3. Basic E-R concepts The original concept of the entity- relationship model was given by Chen in 1976. High level conceptual(logical) data model. Widely used in database design to represent a conceptual schema. A conceptual schema represented by the E-R model is called an E-R schema.
- 4. The basic notationused in E-R diagram are illustrated below: An entity set An Attribute A Relationship set Link between an entity set & attribute
- 5. Specialization Specialization isthe process of defining sub-class based on some distinguishing characteristics. In other words, specialization identifies the sub-sets possesses some attributes Specialization is a top-down process to define super-class/sub-class relationships.
- 7. Generalization Generalization isthe process of defining a super-class from sub- classes based on some common characteristics. In other words, generalization identifies a super-class from different entity-sets(or sub-classes). Generalization is a bottom-up process to define super-class/sub-class relation.
- 8. A bottom-updesign process – combine a number of entity sets that share the same features into a higher-level entity set. Specialization and generalization are simple inversions of each other; they are represented in an E-R diagram in the same way. The terms specialization and generalization are used interchangeably.
- 10. Aggregation Aggregation isan abstraction through which relationships are treated as higher level entities. Thus, for our example, we regard the relationship set works on as a higher- level entity set called works on. Such an entity set is treated in the same manner as is any other entity set. Figure shows a notation for aggregation commonly used to represent this situation.
- 11.
- 12. E-R Diagram With RedundantRelationships