CY-405 Data base Management System Notes
5 notes for Data base Management System, unit by unit.
Notes for CY-405
- Unit 1 · Short notes Basic Concepts of Data and DBMS Basic concepts of data and DBMS · File organization and access methods · Introduction to DBMS and differences with traditional file storage systems · Characteristics of DBMS · Data models, schemas, and instances · DBMS architecture and components
- Unit 2 · Short notes Relational Data Model and SQL Relational data model: domains, tuples, attributes, relations · Keys and key types · Integrity constraints · Relational algebra operations: select, project, rename, join, union, intersection, difference, division, product · Basic SQL queries and functions · SQL constraints, joins, and nested queries
- Unit 3 · Short notes Normalization Theory and Database Methodologies Normalization theory and database design methodologies · Relation schemas and functional dependencies · Axioms and inference rules for functional dependencies · Normal forms: 1NF, 2NF, 3NF, BCNF · Dependency preservation · Lossless‑join decomposition
- Unit 4 · Short notes Transaction Processing and Concurrency Control Transaction processing concepts and transaction states · ACID properties · Concurrency and recovery fundamentals · Schedules, recoverability, and serializability · Types of serializability and testing methods · Concurrency control mechanisms: two‑phase locking, timestamp‑based control
- Unit 5 · Short notes Storage Structures and Query Optimization Storage structures and secondary storage devices · Hashing and indexing structures: single‑level and multi‑level indices · Query processing and optimization algorithms for select, project, join · Complexity measures of query operations · Case study of a contemporary DBMS
More for CY-405
Other 4th semester CY subjects
- CY-401 Introduction to Linear Algebra
- CY-402 Fundamental of Cyber Security
- CY-403 Computer Networks
- CY-404 Operating Systems
- CY-406 Advance Python Programming