MIS chapter 5 quiz - test #2

A group of similar rows or records is known as ________.

a table

A primary key in a database is a ________.

column or group of columns that identifies a unique row in a table

A ________ describes the data and relationships that will be stored in a database.

data model

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

database application

ANo ________ is a program used to create, process, and administer a database.

database management system

Which of the following is a developmental task of database administration?

evaluating application design

Each table in a database must have at least one foreign key.

false

Relational databases represent relationships using ________.

foreign keys

Each entity in a database has a unique attribute called aNo ________.

identifier

Charles and Irene are editors at a content development firm. Both of them, unknowingly, are working on the same copy of the annual report. Irene finishes editing the report and saves her copy; Charles saves his report an hour after Irene. Charles's report overwrites Irene's, and her changes are lost. This scenario is an example of the

lost-update problem

________ in an E-R diagram refer to the least number of entities required in a relationship.

minimum cardinalities

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. She should use a ________ to obtain the information that she wants from the database.

query

The rows in a database are also called ________

records

In an E-R diagram, a line between two entities represents aNo ________.

relationship

Metadata refers to special data that describes the structure of a database.

true

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

true