04Module 4 of 5

Predicate Logic

Quantifiers, relations, and structure

∀
Universal QuantifierExistential QuantifierNested QuantifiersSQL Parallels

Module Complete

Predicate Logic — Quick Reference

0%

Completion

Quantifiers

SymbolNameTruth Condition
∀xUniversal (For all)Every x satisfies the predicate
∃xExistential (There exists)At least one x satisfies
∃!xUnique ExistenceExactly one x satisfies

Negation Rules

¬(∀x P(x)) ≡ ∃x ¬P(x)

¬(∃x P(x)) ≡ ∀x ¬P(x)

SQL Equivalents

LogicSQL Pattern
∃x P(x)EXISTS (SELECT ... WHERE P)
∀x P(x)NOT EXISTS (... WHERE NOT P)

Key Takeaways

1

∀ = all, ∃ = some

2

Quantifier ORDER matters: ∀x∃y ≠ ∃y∀x

3

Negating ∀ gives ∃¬, negating ∃ gives ∀¬

4

Universal in SQL = NOT EXISTS (counterexample)

◊

Up Next

Module 5: Applications

Fallacies, puzzles, and real-world reasoning

→