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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.