Chapter 1

Question 1

T||F : The purpose of a database is to help people keep track of things

Answer 1

True

Question 2

T||F : A possible problem with keeping data in lists is that if you delete a row a data from a list, you may also delete some data items that you want to keep.

Answer 2

True

Question 3

T||F : One problem with storing duplicated data is the potential for inconsistent values

Answer 3

True

Question 4

T||F : An advantage of keeping data in lists is that if you update a data value in one row of data in a list, other occurrences of the same data item in other rows will be automatically updated as well.

Answer 4

False

Question 5

T||F : A SQL stands for Structural Question Language.

Answer 5

False

Question 6

A database may be used to help people ______

Answer 6

track which student is assigned to a particular advisor

Question 7

A relational database stores data in the form of _______

Answer 7

Tables

Question 8

A relational database is _______________

Answer 8

a self-describing collection of related tables

Question 9

Which of the following is a function of the DBMS in a database system?

Answer 9

Perform backup and recover

Question 10

What problems with storing data on two themes in a are addressed by database technology?

Answer 10

Problems with multiple themes in list are update, insertion, and deletion

Question 11

Briefly describe the four components of a database system.

Answer 11

• User: tracks things, create things, uses data apps
• Database Applications: serves as intermediary between user and DBMS
• Database Management Systems: serves as intermediary between database apps and database
• Database: self-describing collection of relational data tables

Question 12

What are “referential integrity constraints”?

Answer 12

Ensure that values are valid from values in another table