Chapter 39 — Quiz (Synthesis)

12 questions tying the whole book together. Answers at the bottom.

Multiple choice

Q1. The capstone primarily demonstrates: - A) Memorized syntax - B) Integration — designing, building, optimizing, securing, and documenting a real database - C) One advanced feature - D) A NoSQL migration

Q2. What most sets a portfolio capstone apart? - A) The number of tables - B) The design-decisions document explaining why - C) Using the newest database - D) Avoiding documentation

Q3. A capstone schema should be: - A) Denormalized everywhere for speed - B) In 3NF, fully constrained, with denormalizations deliberate and documented - C) Schemaless - D) Without foreign keys

Q4. Each index in the capstone should be: - A) On every column - B) Justified by a query pattern and verified with EXPLAIN - C) Avoided - D) Random

Q5. Application access in the capstone must be: - A) String-concatenated SQL - B) Parameterized, via a least-privilege role - C) As superuser - D) Unsecured for simplicity

Q6. "Realistic data" matters because: - A) It looks nice - B) An empty database demonstrates nothing and makes indexing/optimization meaningless - C) It's required by SQL - D) It encrypts the schema

Q7. A complete capstone includes a tested: - A) NoSQL backend - B) backup (restored to verify) - C) microservice - D) blockchain

Q8. In an interview, the most impressive thing to show is: - A) That you memorized syntax - B) Reasoning about a design decision, a slow-query fix, and how you'd scale it - C) The largest possible schema - D) That you used every NoSQL database

Q9. The capstone's documentation should let a reader: - A) Guess how it works - B) Set up and run it in minutes, and understand the design - C) Only see the SQL - D) Nothing

Q10. Choosing PostgreSQL for the capstone should be: - A) Unjustified - B) Justified via the decision framework (Chapter 37) - C) Apologized for - D) Hidden

True/False

Q11. The capstone is new material unrelated to the rest of the book. (True / False)

Q12. Being able to reason about your database (not just build it) is what most helps in interviews. (True / False)

Short answer

Q13. List five deliverables of a complete capstone and the chapter(s) each draws on.

---

Answer key

Q1 — B. Integration of the whole book into a real, finished database.

Q2 — B. The why — the design-decisions document.

Q3 — B. 3NF, fully constrained, denormalizations justified.

Q4 — B. Justified by a query and EXPLAIN-verified.

Q5 — B. Parameterized + least privilege.

Q6 — B. Empty demonstrates nothing; data makes optimization real.

Q7 — B. A tested (restored) backup.

Q8 — B. Reasoning about design, performance, and scale.

Q9 — B. Set up/run in minutes and understand the design.

Q10 — B. Justified via the decision framework.

Q11 — False. It's integration of everything you already built.

Q12 — True. Judgment and reasoning, not just mechanics, get people hired.

Q13. (Examples) ER model (Ch. 17); normalized DDL with constraints (Ch. 14, 18–19); realistic data (Ch. 13, 31); core queries answering requirements (Part II); justified indexes (Ch. 23–24); transactions/concurrency handling (Ch. 26–27); security/roles (Ch. 32); Python data-access layer (Ch. 29–30); a tested backup (Ch. 38); documentation + design-decisions doc (Ch. 17, 37).

Scoring: 11–12 your capstone will shine; 8–10 revisit the deliverables checklist; below 8, re-read the chapter and work the Group A–D exercises.