CS-502 Database Management Systems Notes
5 notes for Database Management Systems, unit by unit.
Notes for CS-502
- Unit 1 · Short notes DBMS Concepts and Architecture Introduction, Database approach vs Traditional file accessing approach · Advantages of database systems · Data models, Schemas and instances · Data independence · Database language and interfaces · Overall database structure
- Unit 2 · Short notes Relational Data Models Domains, tuples, attributes, relations and characteristics of relations · Keys and key attributes of relation · Relational database schemas and integrity constraints · Referential integrity, intension and extension · SQL – DDL and DML, integrity constraints, complex queries, various joins, indexing, triggers, assertions · Relational algebra and relational calculus
- Unit 3 · Short notes Database Design and Query Optimization Introduction to normalization, normal forms, functional dependency · Decomposition, dependency preservation and lossless join · Problems with null‑valued and dangling tuples, multivalued dependencies · Query optimization: introduction, steps of optimization, algorithms for select, project and join · Optimization methods – heuristic based and cost‑estimation based
- Unit 4 · Short notes Transaction Processing and Concurrency Control Transaction system, testing of serializability, serializable schedules, conflict & view serializable schedules · Recoverability and recovery from transaction failures, log‑based recovery, checkpoints, deadlock handling · Concurrency control techniques: locking, time‑stamping protocols, validation‑based protocol, multiple granularity · Multiversion concurrency control and recovery with concurrent transactions · Introduction to distributed databases, data mining, data warehousing · Object technology and DBMS, comparative study of OODBMS vs DBMS
- Unit 5 · Short notes Relational DBMS (Oracle/PL‑SQL/MySQL) Architecture, physical files, memory structures, background processes · Table spaces, segments, extents and blocks; dedicated server and multi‑threaded server · Distributed database, database links, snapshots · Data dictionary, dynamic performance views · Security, role management, privilege management, profiles, invoker‑defined security model · SQL queries, data extraction from single/multiple tables, equi‑join, non‑equi‑join, self‑join, outer join
More for CS-502
Other 5th semester CSE subjects
- CS-501 Theory of Computation
- CS-503 (A) Data Analytics
- CS-503 (B) Pattern Recognition
- CS-503 (C) Cyber Security
- CS-504 (A) Internet and Web Technology
- CS-504 (B) Object Oriented Programming
- CS-504 (C) Introduction to Database Management Systems
- CS-505 Linux (LAB)
- CS-506 Python