Theory Notes/🗄️ Topic 4: Data & Information Management, Solution Development/11.4.4

11.4.4Grade 11

Complex Boolean Logic

Scaling up your Boolean skills from 10.4.4 to handle more variables and apply them fluently across search engines, code, and SQL.

At Grade 11 level, you're expected to construct and evaluate truth tables with up to four variables, and confidently write/evaluate complex nested Boolean expressions combining AND, OR and NOT with brackets.

Example

Complex condition: (age >= 18 AND hasLicense) OR (age >= 16 AND hasSupervisor AND NOT isNightTime) This reads as: the person may drive if they're a licensed adult, OR a supervised minor driving during the day.

These same skills apply across three contexts you'll be tested on:

Search engines (11.2.6) — combining multiple keywords and operators for precise results.
Programming language conditions (11.4.8) — controlling program flow with if statements and loops.
SQL statements (11.4.11) — filtering database queries with WHERE clauses.

💡 Exam Tip

When a Boolean expression question feels overwhelming, build a small truth table for it — systematically working through T/F combinations is more reliable under exam pressure than trying to reason it out purely mentally.