Please enable JavaScript.
Coggle requires JavaScript to display documents.
DBMS (Introduction Database Concepts: (Introduction, Characteristics of…
DBMS
Introduction Database Concepts:
Introduction, Characteristics of databases
Users of Database system
Data Independence
DBMS system architecture
Database Administrator
File system v/s Database system
Structured Query Language (SQL)
Overview of SQL
Data Definition Commands, Data Manipulation commands, Data
Control commands, Transaction Control Commands.
Set and string operations, aggregate function - group by, having.
Views in SQL, joins , Nested and complex queries, Integrity
constraints :- key constraints, Domain Constraints, Referential
integrity , check constraints
Triggers
Transactions Management and Concurrency
Transaction concept, Transaction states, ACID properties
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
Relational Model and relational Algebra
Introduction to the Relational Model, relational schema and
concept of keys.
Mapping the ER and EER Model to the Relational Model
Relational Algebra – unary and set operations, Relational
Algebra Queries
Entity–Relationship Data Model
Entity types
Weak entity sets,
Strong entity sets
Relationship constraints
Cardinality
Participation
Extended
Entity-Relationship (EER) Model
Aggregation
Generalization,
Specialization
Relational–Database Design
Pitfalls in Relational-Database designs , Concept of normalization
Function Dependencies , First Normal Form, 2nd , 3rd , BCNF,
multi valued dependencies , 4NF