Introduction to database management systems
Chapters
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.
Aggregation
Aggregation is a process when relation between two entities is treated as a single entity.
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!