📝 One-liners · 65 cards
Database Management Systems
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.
🔒
Unlock 65 revision one-liners
Interactive flashcard deck — flip every card to drill questions and answers, mark the ones you got wrong, and revise smarter for Database Management Systems.
🪙
Unlock cost
300 coins
30-day access · re-unlocks free for 30 days