Skip to content
CampusPrep
AL-502 · Database Management Systems/Official Syllabus

Database Management Systems (AL-502) - Official Syllabus

1
Unit 1

DBMS Concepts and architecture

  • Introduction
  • Database approach v/s Traditional file accessing approach
  • Advantages of database systems
  • Data models
  • Schemas and instances
  • Data independence
  • Data Base Language and interfaces
  • Overall Database Structure
  • Functions of DBA and designer
  • ER data model: Entitles and attributes
  • Entity types
  • Defining the E-R diagram
  • Concept of Generalization, Aggregation and Specialization
  • Transforming ER diagram into the tables
  • Various other data models object oriented data Model
  • Network data model
  • Relational data model
  • Comparison between the three types of models
  • Storage structures: Secondary Storage Devices
  • Hashing & Indexing structures: Single level & multilevel indices
2
Unit 2

Relational Data models

  • Domains
  • Tuples
  • Attributes
  • Relations
  • Characteristics of relations
  • Keys
  • Key attributes of relation
  • Relational database
  • Schemas
  • Integrity constraints
  • Referential integrity
  • Intension and Extension
  • Relational Query languages: SQL-DDL
  • DML
  • integrity constraints
  • Complex queries
  • various joins
  • indexing
  • triggers
  • assertions
  • Relational algebra and relational calculus
  • Relational algebra operations like select, Project, Join, Division, outer union
  • Types of relational calculus i.e. Tuple oriented and domain oriented relational calculus and its operations
3
Unit 3

Data Base Design

  • Introduction to normalization
  • Normal forms- 1NF
  • 2NF
  • 3NF
  • BCNF
  • Functional dependency
  • Decomposition
  • Dependency preservation and lossless join
  • problems with null valued and dangling tuples
  • multivalued dependencies
  • Query Optimization: Introduction
  • steps of optimization
  • various algorithms to implement select, project and join operations of relational algebra
  • optimization methods: heuristic based
  • cost estimation based
4
Unit 4

Transaction Processing Concepts

  • Transaction System
  • Testing of Serializability
  • Serializability of schedules
  • conflict & view serializable schedule
  • recoverability
  • Recovery from transaction failures
  • Log based recovery
  • Checkpoints deadlock handling
  • Concurrency Control Techniques: Concurrency Control
  • locking Techniques for concurrency control
  • timestamping protocols for concurrency control
  • validation based protocol
  • multiple granularity
  • Multi version schemes
  • Recovery with concurrent transaction
  • Introduction to Distributed databases
  • data mining
  • data warehousing
  • Object Technology and DBMS
  • Comparative study of OODBMS Vs DBMS
  • Temporal, Deductive, Multimedia, Web & Mobile database
5
Unit 5

Case Study of Relational Database Management Systems through Oracle/PostgreSQL /MySQL

  • Architecture
  • physical files
  • memory structures
  • background process
  • Data dictionary
  • dynamic performance view
  • Security
  • role management
  • privilege management
  • profiles
  • invoker defined security model
  • SQL queries
  • Hierarchical quires
  • inline queries
  • flashback queries
  • Introduction of ANSI SQL
  • Cursor management: nested and parameterized cursors
  • Stored procedures
  • usage of parameters in procedures
  • User defined functions their limitations
  • Triggers
  • mutating errors
  • instead of triggers

Reference Books

  • Database System:Design Implementation& Management — Rob — Cengage Learning
  • Introduction to Database Management System — Atul Kahate — Pearson Educations
  • Oracle 9i Database Administration Fundamental-I, Volume I — Oracle Press, TMH
  • Database Management System — Paneerselvam — PHI Learning
  • Database Systems — Korth H.F., Silberschatz A., Sudarshan — McGraw-Hill
  • A Guide to SQL Standard — Chris J. Date, Hugh Darwin — Addison-Wesley
  • Fundamentals of Database Systems — Elmasri R., Navathe S.B. — Pearson
Go to where you left off?

Quick Add to Notes

Save questions, your own notes and screenshots into notes filed by unit. It takes a free account.

Create free account

Have an account? Log in