×
12 Lessons
12 Lessons

A3: Databases.

IB DP Computer Science Syllabus content focus:
Theme A: Concepts of computer science
A3.1 Database fundamentals
A3.1.1 Explain the features, benefits and limitations of a relational database.


A3.2 Database design
A3.2.1 Describe database schemas.
A3.2.2 Construct ERDs.
A3.2.3 Outline the different data types used in relational databases.
A3.2.4 Construct tables for relational databases.
A3.2.5 Explain the difference between normal forms.
A3.2.6 Construct a database normalized to 3NF for a range of real-world scenarios.
A3.2.7 Evaluate the need for de-normalizing databases.


A3.3 Database programming
A3.3.1 Outline the differences between data language types within SQL.
A3.3.2 Construct queries between two tables in SQL.
A3.3.3 Explain how SQL can be used to update data in a database.
A3.3.4 Construct calculations within a database using SQL’s aggregate functions. (HL only)
A3.3.5 Describe different database views. (HL only)
A3.3.6 Describe how transactions maintain data integrity in a database. (HL only)


A3.4 Alternative databases and data warehouses (HL only)
A3.4.1 Outline the different types of databases as approaches to storing data.
A3.4.2 Explain the primary objectives of data warehouses in data management and business intelligence.
A3.4.3 Explain the role of online analytical processing (OLAP) and data mining for business intelligence.

13 Lessons
15 Lessons
This content is protected, please Login and enroll course to view this content!