Images

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 relational model is based on two branches of mathematics—set theory and first-order predicate logic.

5. A relational database stores data in relations, which the user perceives as tables.

6. These are the types of relationships in a relational database:

  1. One-to-one

  2. One-to-many

  3. Many-to-many

7. You retrieve data in a relational database primarily by using SQL, Structured Query Language.

8. These are the ...

Get Database Design for Mere Mortals: 25th Anniversary Edition, 4th 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.

Start your free trial