Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database Management System (Structured Query Language(SQL) (Overview of…
Database Management System
Introduction to Database
Introduction, characteristics of databases
File System v/s Database System
Users of database systems
Data independence
DBMS System Architecture
Database Administrator
Relational Model & Relational Algebra
Mapping the ER and EER Model to the Relational Model
Introduction to the Relational Model, relational schema and
concept of keys
Relational Algebra – unary and set operations, Relational
Algebra Queries
Structured Query Language(SQL)
Overview of SQL
Data Definition Commands
Set and string operations, aggregate function - group by, having
Views in SQL, joins , Nested and complex queries
Triggers
Referential constraints :- key constraints, Domain Constraints, Referential
Integrity constraints :- key constraints, Domain Constraints
Transaction Control Commands
Data
Control commands
Data Manipulation commands
Relational Database Design
Pitfalls in Relational-Database designs
Function Dependencies, First Normal Form
Concept of normalization
Multi valued dependencies
First Normal Form
4NF
2nd & 3rd BCNF
Transaction Management & Concurrency
Transaction concept, Transaction states
ACID properties
Transaction States
Concurrent Executions, Serializability – Conflict and View,
Concurrency Control: Lock-based, Timestamp-based protocols.
Recovery System: Failure Classification, Log based recovery,
ARIES, Checkpoint, Shadow paging.
Deadlock handling
Entity–Relationship Data Model
The Entity-Relationship (ER) Model: Entity types : Weak and strong entity sets, Entity sets
Types of Attributes, Keys
Relationship constraints : Cardinality and Participation, Extended
Entity-Relationship (EER) Model : Generalization, Specialization
Aggregation