A3.1.1 Features, Benefits, and Limitations of a Relational Database

18 flashcards

A3.2.1 Database Schemas

17 flashcards

A3.2.2 Constructing Entity Relationship Diagrams (ERDs)

20 flashcards

A3.2.3 Different Data Types Used in Relational Databases

18 flashcards

A3.2.4 Constructing Tables for Relational Databases

15 flashcards

A3.2.5 Differences Between Normal Forms

16 flashcards

A3.2.6 Constructing a Database Normalized to 3NF for Real-World Scenarios

18 flashcards

A3.2.7 Evaluating the Need for Denormalizing Databases

18 flashcards

A3.3.1 Differences Between Data Language Types in SQL

13 flashcards

A3.3.2 Constructing Queries Between Two Tables in SQL

17 flashcards

A3.3.3 Using SQL to Update Data in a Database

16 flashcards

A3.3.4 Constructing Calculations Within a Database Using SQL’s Aggregate Functions (HL only)

17 flashcards

A3.3.5 Different Database Views (HL only)

19 flashcards

A3.3.6 How Transactions Maintain Data Integrity in a Database (HL only)

19 flashcards

A3.4.1 Different Types of Databases as Approaches to Storing Data (HL only)

17 flashcards

A3.4.2 Primary Objectives of Data Warehouses in Data Management and Business Intelligence

16 flashcards

A3.4.3 Role of Online Analytical Processing (OLAP) and Data Mining for Business Intelligence

20 flashcards

A3.4.4 Features of Distributed Databases

17 flashcards