A. Answers to Review Questions

Chapter 1

1. The two main types of databases in use today are operational and analytical.

2. An analytical database stores static data.

3. True. An operational database is used primarily in OLTP scenarios.

4. The hierarchical and network database models were commonly used in the days before the relational database model.

5. In a parent/child relationship, a parent table can be associated with one or more child tables, but a single child table can be associated with only one parent table.

6. A set structure is a transparent construction that establishes and represents a relationship in a network database.

7. The relational model is based on two branches of mathematics—set theory and first-order predicate logic.

Get Database Design for Mere Mortals®: A Hands-on Guide to Relational Database Design, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.