Database Management Systems
Chapter notes, video classes, MCQ practice tests and quick-revision one-liners for Information Technology and Digital Banking (Elective) — CAIIB.
One-liners from this chapter
Free sample — 8 of 65 rapid-fire Q&A cards.
What is a Database Management System (DBMS)?
A DBMS is software that manages, stores, retrieves, and manipulates structured data in a database, providing an interface between users and the underlying data storage.
What is the Second Normal Form (2NF) in database normalisation?
Relation in 1NF with no partial dependency on primary key.
What is the primary difference between a database and a flat file system?
A database avoids data redundancy, ensures data integrity, and supports concurrent access by multiple users, whereas flat files store data in isolation without these controls.
What is the Third Normal Form (3NF) and its relevance in banking databases?
Eliminates transitive dependencies, ensuring data consistency in bank records.
What does the term 'data independence' mean in the context of DBMS?
Data independence means that changes to the data storage structure do not require changes to the application programs that use the data, achieved through logical and physical abstraction layers.
What is Boyce-Codd Normal Form (BCNF) in relational databases?
Stricter version of 3NF where every determinant must be a candidate key.
What are the three levels of the ANSI-SPARC architecture in a DBMS?
The three levels are the External level (user views), the Conceptual level (logical structure of the entire database), and the Internal level (physical storage details).
What is a candidate key in a relational database?
Minimal set of attributes uniquely identifying each tuple in a relation.
Video classes for this chapter
Master the full ITDB syllabus
Every chapter of Information Technology and Digital Banking (Elective) — videos, tests, notes and one-liner decks in one place.