Data Base Management System 

SYLLABUS

PART - A

UNIT - 1
DATABASES AND DATABASE USERS: Introduction, characteristics of data base approach, intended uses of a DBMS, advantages and implication of database approach.
2 Hours

DATABASE SYSTEMS CONCEPTS AND ARCHITECTURE: Data models, Schemas and instances, DBMS architecture and data independence, database languages and interfaces, database system environment, classification of data base management systems.
5 Hours
UNIT - 2
DATA MODELING: High level conceptual data models for database design. Entity types, entity sets, attributes, and keys. Relationships, relationship types, roles, and structural constraints. Weak entity types. ER diagrams
6 Hours

UNIT - 3
RECORD STORAGE AND PRIMARY FILE ORGANIZATIONS: Secondary storage devices, buffering of blocks, placing file records on disk, operations on files, heap files and sorted files, hashing techniques.
6 Hours

UNIT - 4
INDEX STRUCTURE OF FILES: Single-level and multilevel ordered indexes, dynamic multi level indexes using B-trees and B+trees.
6 Hours

PART - B

UNIT - 5
RELATIONAL DATA MODEL AND RELATIONAL ALGEBRA: Brief discussion on Codd rules, relational model concepts, constraints, and schemas. Update operation on relations, basic and additional relational algebra operations, and queries in relational algebra.
Structured Query Language (SQL): Data definition etc. in SQL2. Basic and complex queries in SQL. Insert, delete, update statements, and views in SQL, embedded SQL.
9 Hours
UNIT - 6
DATABASE DESIGN: Design guidelines for relational schemes, functional Dependencies, normalization -1st, 2nd, 3rd, 4th, and 5th normal forms. Database design process, factors influencing physical database design guidelines, and guidelines for relational systems.
6 Hours

UNIT - 7
SYSTEM IMPLEMENTATION: System catalog for RDBMSs, transaction processing and system concepts, properties of transactions, brief discussion on concurrency, control and recovery techniques, database security and authorization.
6 Hours

UNIT - 8
BRIEF DISCUSSION ON:  Distributed databases, Objected oriented databases, next generation databases, and interfacing with other technologies.
6 Hours