December 2020
Beginner
640 pages
14h 45m
English
Answers to Review Questions
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:
One-to-one
One-to-many
Many-to-many
7. You retrieve data in a relational database primarily by using SQL, Structured Query Language.
8. These are the ...