Review Questions

1.

Name the two main types of databases in use today.

2.

What type of data does an analytical database store?

3.

True or False: An operational database is used primarily in on-line transaction processing (OLTP) scenarios.

4.

What two data models were commonly used in the days before the relational database model?

5.

Describe a parent/child relationship.

6.

What is a set structure?

7.

Name one of the branches of mathematics on which the relational model is based.

8.

How does a relational database store data?

9.

Name the three types of relationships in a relational database.

10.

How do you retrieve data in a relational database?

11.

State two advantages of a relational database. ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second 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.