Reading:  

Introduction to database management systems


Entity Relation Diagram Generalization Aggregation

Generalization

Generalization is a bottom-up approach in which two lower level entities combine to form a higher level entity.

 

Specialization

Specialization is a top-down approach in which one higher level entity can be broken down into two lower level entity.

Specialization

Aggregation

Aggregation is a process when relation between two entities is treated as a single entity.

DBMS aggregation

 

 

 

Description

This free tutorial covers the basics of database management system to help you with your understanding on the topic, Please note that this tutorial assumes that either you are a beginner or just want to brush up your understanding on DBMS

Tutorial covers the topics below

  • What is DBMS?
  • Architecture
  • Data Models
  • Data Schemas
  • Data Independence
  • Entity-Relation Model Basic Concept
  • Entity-Relation Diagram Representation
  • Generalization, Aggregation
  • Codd's 12 Rules
  • Relational Data Model
  • Relational Algebra
  • Structured Query Language
  • Normalization
  • Database Joins
  • Storage System
  • Indexing
  • Hashing
  • Transaction
  • Concurrency Control and Deadlock
  • Data Backup and Recovery

 



Audience

Absolute beginners or students who wish to brush up their understanding on DBMSes

Author: Subject Coach
Added on: 16th Sep 2015

You must be logged in as Student to ask a Question.

None just yet!