Database Fundamentals
This type of database stores data in a single table without defined relationships, often resulting in redundancy and inefficiency when scaling up.
What is a flat file database?
This process organizes data into tables to reduce redundancy.
What is normalization?
This SQL command is used to retrieve data from a table.
What is SELECT?
This rule ensures that any foreign key value always corresponds to an existing primary key.
What is referential integrity?
In a relational database, this key uniquely identifies each record within a table and is essential for data integrity.
What is a primary key?
This normal form requires that every field contains only atomic (indivisible) values.
What is First Normal Form (1NF)?
This SQL clause filters records based on specified criteria.
What is WHERE?
This ACID property means that a transaction is all-or-nothing.
What is atomicity?
This key links tables together by referencing a primary key in another table.
What is a foreign key?
This normal form eliminates partial dependencies by ensuring non-key attributes depend on the whole primary key.
What is Second Normal Form (2NF)?
This command adds new data into a table.
What is INSERT?
This ACID property ensures that once a transaction is committed, its results persist even after a failure.
What is durability?
This key is used to facilitate searching and sorting even though it may not uniquely identify records.
What is a secondary key?
This diagrammatic tool shows tables, keys, and the relationships (such as one-to-many) between them in a database.
What is an entity relationship diagram?
This command removes specific records from a table.
What is DELETE?
This common text-based file format is used to exchange data and can easily be opened in a spreadsheet.
What is CSV?
This modeling method uses diagrams to represent tables, keys, and relationships like one-to-many.
What is entity relationship modeling?
This normal form removes transitive dependencies to further reduce data anomalies.
What is Third Normal Form (3NF)?
This SQL operation combines rows from two tables based on a related column.
What is JOIN?
This technique locks records during transactions to prevent simultaneous changes that could lead to conflicts.
What is record locking?