Exam 11: Databases

Case-Based Critical Thinking Questions Case 11-1 Janet has been hired to design a database for a music store called WebMusic. The store sells CDs, which are to be included in the database. Janet plans to include many of the customers that visit the store in the database as well. She has designed fields for the database. -The list of field names that will be used to hold WebMusic's customer information will be defined as a template called a ____.

Modern database software is designed to support data dependence.

A ____ update changes data in more than one record at a time.

An encrypted database can be queried quickly.

The ____ database model uses a mesh-like structure,which allows for the definition of many-to-many relationships.

A lookup ____________________ validates an entry by searching for the same data in a file or database table.

-In the accompanying figure,the middle row shows a relationship where one album contains many songs,and one song may appear on many albums._________________________

Case-Based Critical Thinking Questions Case 11-1 Janet has been hired to design a database for a music store called WebMusic. The store sells CDs, which are to be included in the database. Janet plans to include many of the customers that visit the store in the database as well. She has designed fields for the database. -In the WebMusic database,all previous and current CD orders will be included for each customer.Basic customer information,such as name,address,phone,and e-mail,will also be included for each customer.The relationship between the customer and his/her CD orders will likely be which of the following?

Poorly designed custom database software can result in data independence._________________________

A database ____ contains a list of keys,and each key provides a pointer to the record that contains the rest of the fields related to that key.

The SQL query language provides a collection of special command words called SQL ____________________,such as SELECT,FROM,INSERT,and WHERE.

A relational database stores data in a collection of related tables.

-The accompanying figure shows a(n)____ document.

-In the query illustrated in the accompanying figure,the SELECT command is used to link the Albums and Tracks tables._________________________

In the context of object-oriented databases,a(n)____________________ defines a group of objects by specifying the attributes and methods these objects share.

In SQL terminology,creating a relationship between tables is referred to as ____ tables.

When no ____________________ order is specified,new records are appended to the end of the database file.

The term ___________________________________ refers to software that is designed to manage data stored in a database.

In a flat file,each row in the table is a(n)field._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Diagram of the relationship between record types