O'Reilly logo

Database Design for Mere Mortals®: A Hands-on Guide to Relational Database Design, Third Edition by Michael J. Hernandez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required