IT-405 Data Base Management System Notes
5 notes for Data Base Management System, unit by unit.
Notes for IT-405
- Unit 1 · Short notes Basic Concepts Introduction to DBMS · File system versus DBMS comparison · Advantages of database systems · Database system architecture · Data models, schemas and instances · Data independence
- Unit 2 · Short notes Relational Model Structure of relational databases · Domains and relations · Relational algebra – fundamental operators and syntax · Relational algebra queries · Entity‑Relationship model basics and design process · Constraints, keys, design issues
- Unit 3 · Short notes SQL Data Definition Language (DDL) in SQL · Update statements and views · Data storage definitions · Data retrieval queries · Query processing and optimization overview · Measures of query cost, selection, sorting, join operations
- Unit 4 · Short notes Relational Database Design Functional dependencies – definition, trivial and non‑trivial FD · Closure of FD set, irreducible set of FD · Normalization – 1NF, 2NF, 3NF · Decomposition preserving dependencies, lossless join · Boyce‑Codd Normal Form (BCNF) · Multivalued dependency, Fourth Normal Form (4NF)
- Unit 5 · Short notes Transaction Management and Concurrency Control Transaction concepts, processing and recovery · Concurrency control – lock management · Specialized locking techniques · Concurrency control without locking · Protection and security aspects