Timedora

Database Fundamentals - CS 220

Introduces relational databases, tables, keys, normalization, SQL queries, joins, transactions, and basic database design.

Study Tools

All

Study guides

7

7 Basic Relational Database Design

Learn how to turn real-world requirements into relational tables, connect them with keys, enforce rules with constraints, and review a design for data integrity.
Study guide · Updated

5 Normalization and Data Integrity

Learn how functional dependencies guide relational database normalization, how 1NF, 2NF, and 3NF address different forms of redundancy, and how keys and constraints support data integrity.
Study guide · Updated

4 SQL Joins

Learn how SQL joins combine related table rows, how join types handle unmatched rows, and how to write clear queries that avoid common pitfalls.
Study guide · Updated

6 Transactions and Concurrency Basics

Learn how database transactions group operations, how ACID properties support reliability, and how transaction control and isolation help manage concurrent work.
Study guide · Updated

2 Keys and Relationships

Learn how database keys identify rows, how relationships connect tables, and how constraints preserve data consistency.
Study guide · Updated

3 SQL Fundamentals

Learn how SQL defines relational tables, retrieves and filters rows, orders results, and summarizes data with aggregates.
Study guide · Updated

1 Relational Database Foundations

Understand how relational databases represent information with tables, how schemas and data types structure that information, and how a SQL definition creates a table.
Study guide · Updated

Quizzes

7

6 Transactions and Concurrency Basics

A medium-difficulty quiz on transaction behavior, ACID properties, transaction control, and concurrent work.
Quiz · Updated

4 SQL Joins

A medium-difficulty quiz on choosing, writing, and reasoning about SQL joins, including their behavior with unmatched rows, multiple relationships, and filters.
Quiz · Updated

7 Basic Relational Database Design

Assess understanding of relational database design, keys, constraints, normalization, historical data, and schema decisions.
Quiz · Updated

3 SQL Fundamentals

A medium-difficulty quiz on SQL fundamentals, including table constraints, query clauses, filtering, sorting, and aggregation.
Quiz · Updated

5 Normalization and Data Integrity

A medium-difficulty quiz on functional dependencies, normalization, anomalies, and database constraints.
Quiz · Updated

1 Relational Database Foundations

A medium-difficulty quiz on relational database structure, SQL table definitions, and data types.
Quiz · Updated

2 Keys and Relationships

A medium-difficulty quiz on choosing keys, modeling table relationships, and applying database constraints.
Quiz · Updated

Flashcards

7

7 Basic Relational Database Design

Learn how to model relational data, choose keys and constraints, normalize tables, and preserve accurate order information.
Flashcards · Updated

5 Normalization and Data Integrity

Review functional dependencies, candidate keys, normalization from 1NF through 3NF, and constraints that help preserve data integrity.
Flashcards · Updated

6 Transactions and Concurrency Basics

Review transaction fundamentals, the ACID properties, transaction-control commands, and how isolation affects concurrent database work.
Flashcards · Updated

4 SQL Joins

Review how SQL joins combine related table rows, preserve unmatched rows, and shape query results.
Flashcards · Updated

3 SQL Fundamentals

Learn how SQL defines relational tables, retrieves and filters data, orders results, and summarizes rows with aggregate functions.
Flashcards · Updated

2 Keys and Relationships

Learn how database keys identify rows, connect tables, represent relationships, and enforce data rules.
Flashcards · Updated

1 Relational Database Foundations

Learn how relational databases organize information into tables, how schemas and data types structure those tables, and how SQL implementations differ from the pure relational model.
Flashcards · Updated