Quick Links

LMS Syllabus All Notes Class Library
Past Lesson Note

This note is from 3 months ago. You're viewing content from a previous lesson.

Daily Note for February 19, 2026 Past Lesson

I'm not here today.

Your tests will be graded before break.

Please watch, study and carefully learn from this video. Ignore this at your own peril. https://www.youtube.com/watch?v=xsg9BDiwiJE

Please make an ERD diagram of a school database (students, teachers, classes, enrollments) and diagram cardinality. send to me via email. 

We will be using this file to work with databases.

  1. A3.1.1 Explain the features, benefits and limitations of a relational database.
  2. A3.2.1 Describe database schemas.
  3. A3.2.2 Construct ERDs.
  4. A3.2.3 Outline the different data types used in relational databases.
  5. A3.2.4 Construct tables for relational databases.
  6. A3.2.5 Explain the difference between normal forms.
  7. A3.2.6 Construct a database normalized to 3NF for a range of real-world scenarios.
  8. A3.2.7 Evaluate the need for denormalizing databases.

== test == 

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

== test ==

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