Chapter 1

   

---

1:	Name the two main types of databases in use today.
A1:	The two main types of databases in use today are operational and analytical .
2:	What type of data does an analytical database store?
A2:	An analytical database stores dynamic data.
3:	True or False: An operational database is used primarily in on-line transaction processing (OLTP) scenarios.
A3:	True. An operational database is used primarily in OLTP scenarios.
4:	What two data models were commonly used in the days before the relational database model?
A4:	The hierarchical and network database models were commonly used in the days before the relational database model.
5:	Describe a parent/child relationship.
A5:	In a parent/child relationship, a parent table can be associated with one or more child tables, but a single child table can be associated with only one parent table.
6:	What is a set structure?
A6:	A set structure is a transparent construction that establishes and represents a relationship in a network database.
7:	Name one of the branches of mathematics on which the relational model is based.
A7:	The relational model is based on two branches of mathematics set theory and first-order predicate logic .
8:	How does a relational database store data?
A8:	A relational database stores data in relations , which the user perceives as tables.
9:	Name the three types of relationships in a relational database.
A9:	The three types of relationships in a relational database are one-to-one , one-to-many , and many-to-many .
10:	How do you retrieve data in a relational database?
A10:	You retrieve data in a relational database by using SQL.
11:	State two advantages of a relational database.
A11:	The advantages of a relational database include built-in multilevel integrity, logical and physical data independence from database applications, guaranteed data consistency and accuracy, and easy data retrieval.
12:	What is a relational database management system?
A12:	A relational database management system, or RDBMS, is a software program you use to create, maintain, modify, and manipulate a relational database.
13:	What is the premise behind the object-relational model?
A13:	The object-relational model extends the relational database model by incorporating various object-oriented elements and characteristics, such as classes, encapsulation, and inheritance.
14:	What is the purpose of a data warehouse?
A14:	A data warehouse allows organizations to access data stored in any number of relational and nonrelational databases.
15:	What is XML and why is it significant?
A15:	XML stands for eXtensible Markup Language and is quickly becoming a de facto data-transfer standard for sharing data across heterogeneous systems.

---

Top