Page 7 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

DCAP204 Managing Database

Sr. No. Description
1. Introduction to fundamentals of DBMS: Database applications, Purpose of database systems, Views of data,
Database languages, Relational Databases, Database Design, Transaction Management

2. Relational Databases: Relational Model, Structure of Relational databases, fundamental, additional and
extended relational algebra operations, Null Values, Modification of database
3. SQL: Data Definition, datatypes, schema definition, Basic structure of SQL Queries, Creating tables, DML -
SELECT, INSERT, DELETE and UPDATE operations, DDL commands
4. SQL: Set Operations – UNION, INTERSECT, EXCEPT, Aggregate Functions, NULL values, Nested
subqueries, Complex queries, Views, Joined relations Advanced SQL: Integrity constraints, Authorization:
GRANT, REVOKE
5. Relational Languages: Tuple Relational calculus, Domain relational calculus, Query by Example, Datalog
6. Database design and ER model: Overview of Design process, Entity relationship model, constraints, ER
Diagrams, ER Design issues, Weak entity sets, extended ER features
7. Relational Database Design: Features, Atomic Domains and first normal form, Functional dependency theory
decomposition using functional dependencies, decomposition using Multivalued dependencies, More normal
forms, database design process

8. Transaction Management: Concept of Transaction, Transaction State, Implementation of atomicity and
durability, concurrent execution, Serializability, Recoverability, Implementation of Isolation, testing for
Serializability
9. Concurrency Control: Lock based protocols, Timestamp based protocols, Validation based protocols,
Deadlock handling, Insert and Delete operations, Weak levels of consistency
10. Recovery system: Failure classification, storage structure, recovery and atomicity, log-based recovery,
recovery with concurrent transactions, buffer management, failure with loss of nonvolatile storage