Answer it
P1 a3 library update
3 marksYou mark it yourself against the marking points
The school library's Loan table has these records. The field returned is a BOOLEAN.
| loan_id | book_id | student_name | due_date | returned |
|---|---|---|---|---|
| 1 | 3 | Ana | 2026-11-02 | FALSE |
| 2 | 1 | Ben | 2026-10-20 | TRUE |
| 3 | 2 | Chloe | 2026-10-28 | FALSE |
| 4 | 3 | Dev | 2026-10-15 | TRUE |
Chloe brings her book back.
(a) Construct an SQL statement that records that loan 3 has been returned, and changes nothing else. [2]
(b) A librarian runs your statement with its WHERE clause left out by mistake. State what happens to the table. [1]
[3]