1/20
Comprehensive practice flashcards covering core database concepts, relational vs. non-relational database architectures, transaction models, and entity-relationship diagram (ERD) design principles.
What is the technical definition of a database?
A structured collection of data stored electronically, purpose-built for rapid search, retrieval, and management to replace scattered physical records.
What is the distinction between data and information?
Data represents raw, unprocessed material (such as unranked test scores), whereas information is the engineered output created by processing data into a meaningful structure (such as a valedictorian ranking list).
What is a Database Management System (DBMS)?
A specialized software application that sits between end users or applications and the physical database itself to capture, store, organize, and analyze data.
What are the four pillars of database management?
Data Persistence, Data Integrity, Concurrency Control, and Backup & Security.
What are the three abstraction layers of the 3-Schema Architecture?
What were the primary limitations of early flat files and hierarchical data systems?
They were rigid, difficult to navigate, and prone to extreme data redundancy.
What are the core components of a relational database table?
What are primary keys and foreign keys, and how do they function together?
A Primary Key (PK) is a unique identifier for an entity that acts as the absolute source of truth. A Foreign Key (FK) is an attribute referencing the primary key of another table to establish structural relationships and enforce referential integrity.
What catalyst prompted the development of Non-Relational (NoSQL) databases?
The internet explosion generated massive volumes of unstructured data (such as social media posts, sensor readings, and streaming video) that did not fit into rigid, predefined tables.
What are the four primary NoSQL architectures and their prominent use cases or examples?
How do RDBMS and NoSQL systems differ in scaling and schema flexibility?
RDBMS uses locked, predefined schemas (requiring ALTER TABLE) and scales vertically by adding RAM/CPU to a single server. NoSQL uses unlocked, dynamic schemas (schema-on-read) and scales horizontally by distributing workloads across clusters of smaller servers.
What do the ACID and BASE transaction models stand for?
ACID stands for Atomicity, Consistency, Isolation, Durability (guaranteeing 100% immediate data accuracy). BASE stands for Basically Available, Soft state, Eventual consistency (prioritizing extreme speed and high availability over immediate synchronization).
Why is an RDBMS architecture selected for banking and financial transactions?
Only RDBMS provides strict ACID compliance; if a network crash occurs during a transfer between accounts, the transaction is locked and rolled back completely to prevent money from being lost.
Why do social media and streaming platforms utilize NoSQL architectures?
They prioritize high availability (keeping video streaming smoothly) over immediate synchronization. Eventual consistency allows non-critical data, like 'Like' counts, to take a couple of seconds to update globally without impacting service.
Which specific database models are best suited for real-time multiplayer leaderboards and logistics GPS routing?
High-speed Key-Value NoSQL databases power real-time gaming leaderboards, while Graph NoSQL databases excel at calculating and recalculating billions of dynamic GPS routing relationships for cargo tracking.
What is an Entity-Relationship Diagram (ERD) and what are its key use cases?
A visual representation of a database structure used to design and understand how data entities relate before implementation. Key use cases include database design, data modeling, and system architecture planning.
What are the standard visual shapes used to represent ERD components?
Entities (nouns) are drawn as rectangles, Relationships (verbs) are drawn as diamonds or connecting lines, and Attributes (properties) are drawn as ovals.
What are the three mathematical relationship types (cardinality) in an ERD?
What is the 5-step blueprint methodology for building an ERD?
In the E-Commerce ERD practice workshop, what was defined as in-scope versus out-of-scope?
In-scope included the core purchasing flow: users buying items and recording transactions. Out-of-scope included shipping logistics, payment gateway routing, and inventory restock alerts.
In the final E-Commerce workshop ERD, how are Customer, Order, and Product related?
Customer connects to Order via a 'Places' relationship with a 1:M cardinality (one customer can place many orders). Order connects to Product via a 'Contains' relationship with an M:N cardinality (many orders can contain many products).