Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
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. |
| 12: | What is a relational database management system? |
| 13: | What is the premise behind the object-relational model? |
| 14: | What is the purpose of a data warehouse? |
| 15: | What is XML and why is it significant? |
| |
| Top |