AD-402 Database Management System Notes
5 notes for Database Management System, unit by unit.
Notes for AD-402
- Unit 1 · Short notes DBMS Concepts and Architecture DBMS concepts and architecture introduction · Database approach versus traditional file‑accessing approach · Advantages of database systems · Data models, schemas and instances · Data independence · Database language and interfaces
- Unit 2 · Short notes Relational Data Models Domains, tuples, attributes, relations and characteristics of relations · Keys and key attributes of a relation · Relational database schemas · Integrity constraints and referential integrity · Intension vs. extension · Relational query languages: SQL DDL and DML
- Unit 3 · Short notes Database Design and Query Optimization Normalization: introduction, normal forms, functional dependency · Decomposition, dependency preservation and lossless join · Issues with null‑valued and dangling tuples · Multivalued dependencies · Query optimization: introduction and optimization steps · Algorithms for implementing select, project, and join operations
- Unit 4 · Short notes Transaction Processing and Distributed Databases Transaction processing concepts and transaction system · Testing of serializability, conflict‑serializable and view‑serializable schedules · Recoverability and recovery from transaction failures · Log‑based recovery and checkpoints · Deadlock handling · Concurrency control techniques: locking, timestamp protocols, validation‑based protocols, multiple granularity locking
- Unit 5 · Short notes Relational DBMS Study and NoSQL Study of RDBMS through Oracle/PL‑SQL/MySQL: architecture, physical files, memory structures, background processes · Concepts of tablespaces, segments, extents and blocks · Dedicated server vs. multi‑threaded server · Distributed database features: database links and snapshots · Data dictionary and dynamic performance views · Security, role management, privilege management, profiles, invoker‑defined security model
More for AD-402
Other 4th semester AD subjects
- AD-403 Software Engineering with Agile Methodology
- AD-404 DATA SCIENCE
- AD-405 Operating Systems
- BT-401 Mathematics-III