Database Systems

Public Deck • Created by DBAExpert

15 cards
Card 1
Term
Database
Definition
Organized collection of data
Card 2
Term
SQL
Definition
Structured Query Language
Card 3
Term
Table
Definition
Collection of related data entries
Card 4
Term
Primary Key
Definition
Unique identifier for a record
Card 5
Term
Foreign Key
Definition
Links two tables together
Card 6
Term
Normalization
Definition
Organizing data to reduce redundancy
Card 7
Term
Index
Definition
Improves database search speed
Card 8
Term
Transaction
Definition
Sequence of database operations
Card 9
Term
ACID
Definition
Atomicity, Consistency, Isolation, Durability
Card 10
Term
NoSQL
Definition
Non-relational database
Card 11
Term
Schema
Definition
Structure of a database
Card 12
Term
Query
Definition
Request for data
Card 13
Term
Join
Definition
Combines rows from two tables
Card 14
Term
View
Definition
Virtual table based on query
Card 15
Term
Replication
Definition
Copying data across databases