View all subjects

Database Management System

Students studying Computer Science will find this subject very useful. Hundreds of important topics on Database Management System are organized neatly into lessons below.

Add to your library

Overview

Topics Covered


As per Choice Based Grading System


1.0 Introduction Database Concepts:

1.1 Introduction, Characteristics of databases, File system v/s Database system, Users of Database system

1.2 Data Independence, DBMS system architecture, Database Administrator

2.0 Entity–Relationship ...

Read more

As per Choice Based Grading System


1.0 Introduction Database Concepts:

1.1 Introduction, Characteristics of databases, File system v/s Database system, Users of Database system

1.2 Data Independence, DBMS system architecture, Database Administrator

2.0 Entity–Relationship Data Model

2.1 The Entity-Relationship (ER) Model: Entity types: Weak and strong entity sets, Entity sets, Types of Attributes, Keys,

2.2 Relationship constraints: Cardinality and Participation, Extended

2.3 Entity-Relationship (EER) Model: Generalization, Specialization and Aggregation

3.0 Relational Model and relational Algebra

3.1 Introduction to the Relational Model, relational schema and concept of keys. Mapping the ER and EER Model to the Relational Model

3.2 Relational Algebra – Unary and set operations, Relational Algebra Queries.

4.0 Structured Query Language (SQL)

4.1 Overview of SQL, Data Definition Commands, Data Manipulation commands, Data Control commands, Transaction Control Commands.

4.2 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

4.3 Triggers

5.0 Relational–Database Design

5.1 Pitfalls in Relational-Database designs , Concept of normalization, Function Dependencies , First Normal Form, 2nd , 3rd , BCNF, multi valued dependencies , 4NF.

6.0 Transactions Management and Concurrency

6.1 Transaction concept, Transaction states, ACID properties, Concurrent Executions, Serializability – Conflict and View, Concurrency Control: Lock-based, Timestamp-based protocols.

6.2 Recovery System: Failure Classification, Log based recovery, ARIES, Checkpoint, Shadow paging. Deadlock handling

Read less

Question Papers