Page 6 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

SYLLABUS
Database Management Systems/Managing Database

Objectives: The course aims at providing the students through insight on database management principles and practices. The
major objectives of the course are to: Knowledge of DBMS and in terms of use and design

 Describe the main features and function of the DBMS;
 Describe the features of relational database and E-R models;
 Experience with SQL queries;

 Experience ER diagrams;
 Discuss the concept of Transaction, Recovery, Concurrency and Security of DBMS
DCAP402 Database Management Systems
Sr. No. Description
1. Database Fundamentals: Database systems, Database Architecture Relational Model, Structure of Relational
databases, fundamental, additional and extended relational algebra operations
2. SQL: Data Definition, datatypes, schema definition, Basic structure of SQL Queries, Creating tables, DML
operations, DDL commands for creating and altering, Set Operations, Aggregate Functions, NULL values
3. Advanced SQL: Subqueries, Nested subqueries, Complex queries, Views, Joined relations, Integrity
constraints, Authorization, DCL Commands, Embedded SQL, Dynamic SQL
4. Relational Languages: Tuple Relational calculus, Domain relational calculus, Query by Example Database
design and ER model: Overview of Design process, Entity relationship model, constraints, ER Diagrams, ER
Design issues, Weak entity sets, extended ER features
5. Relational Database Design: Features, Atomic Domains and first normal form, Functional
dependency theory decomposition using functional dependencies, decomposition using Multivalued
dependencies, database design process Normalization: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF.
6. Transaction Management: Concept of Transaction, Transaction State, Implementation of atomicity and
durability, concurrent execution, Serializability, Recoverability, Implementation of Isolation, testing for
Serializability.n Concurrency Control: Lock based protocols, Timestamp based protocols, Validation based
protocols, Deadlock handling, Insert and Delete operations, Weak levels of consistency
7. Recovery system: Failure classification, storage structure, recovery and atomicity, log-based recovery,
recovery with concurrent transactions, buffer management, failure with loss of non-volatile storage
8. Query Processing: Overview, measures of query cost, selection operation, sorting, join operation, evaluation
of expressions Query Optimization: Transformation of relational expressions, estimating statistics of
expression results, Choice of evaluation plans
9. Parallel Databases: I/O parallelism, Interquery parallelism, Intraquery parallelism, Intraoperation
parallelism, Interoperation parallelism
10. Application development and administration: web interfaces to databases, performance tuning