Chapter 5 Quiz

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, productivity of an employee on a daily basis, and employee name. These aspects that Brad wants to track are called ________. a. entities b. records c. primary keys d. identifiers

a.

In the following image, the VEND_CODE in the PRODUCT table represents a(n) __________ because it creates the logical connection between the two tables. a. foreign key b. primary key c. linking key d. entity key

a.

______ is the standard language for inserting, updating, and deleting data in a database. a. SQL b. DBMS c. XML d. HTML

a.

_________ is the term used to describe non-relational databases that support very high transaction rates processing relatively simple data structures. a. NoSQL b. Thin-client c. Entity d. Spherical

a.

A student management system allows students to have multiple majors, and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship. a. 1:1 b. N:M c. 1:N d. M:1

b.

Every table in a normalized database has ________. a. data redundancy b. a single theme c. maximum cardinality d. a specialized query format

b.

________ refers to data collections that are characterized by huge volume, rapid velocity, and great variety. a. NoSQL b. BigData c. Hadoop d. Dynamo

b.

A(n) ________ is a program used to create, process, and administer a database. a. operating system b. information system c. database management system d. database system

c.

Phone number, email address, first and last name, are all examples of ___________ because they describe the characteristics of an entity. a. tables b. foreign keys c. attributes d. identifiers

c.

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another. a. Administrators b. Designers c. Users d. Developers

c.

A data integrity problem will occur only if ________. a. the database is very complex b. there are complex relationships between entities in a database c. a database has multiple administrators d. data are duplicated in a database

d.

A database developer is likely to use a(n) ____________ to serve as the blueprint for building a database. This tool describes the entities, attributes, and relationships among entities. a. normalization table b. database management system c. database design model d. entity-relationship data model

d.

A(n) ________ DBMS is designed to process large organizational and workgroup databases. a. operational b. process c. personal d. enterprise

d.

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________. a. primary record b. foreign key c. unique column d. primary key

d.

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. After accessing the DBMS, she should create a ________ to obtain the information that she wants. a. report b. reference c. data entry d. query

d.