Databases
Answers are for parents and teachers.
1
Using the Loans, Members and Books tables, which book did Karim borrow?
Loan L5 has M4 (Karim) and B2: Maps and Stars.
2
Which members borrowed a Science book? Name the operations in order.
Join, select Topic = Science, project Name: Hana, Omar, Karim.
3
Explain in two sentences why a pile of separate lists can become inconsistent.
The same fact is copied into several lists. If one copy is changed and another is forgotten, the lists disagree.
4
Match: (a) records each sale, (b) weekly totals for managers, (c) one system for all departments. Choices: ERP, transaction processing, management information.
(a) transaction processing, (b) management information, (c) ERP.