BCOR 330 - Chapter 5

A __________ is a collection of forms, reports, queries, and programs that process a database.

database application

The purpose of a ________ is to create, process, and administer a database.

database management system (DBMS)

A one-to-many relationship is expressed by _____________.

1:N

Which of the following describes a database application?

A collection of forms, reports, queries, and programs that process a database

Which of the following best describes a primary key?

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

Which of the following is true of the components of an entity-relationship data model?

Attributes describe the characteristics of entities.

Which of the following actions follows the step of determining the requirements for new forms, reports, and queries during the development of a database application system?

Creating a data model

Which of the following best defines metadata?

Describes the structure of a database

Which of the following categories of new DBMS represents DBMS that process databases in main memory?

In-memory DBMS

Which of the following is true about a data model?

It describes the data and relationships that will be stored in the database.

Which of the following gives an accurate description of a data model?

It is a logical representation of the data in a database that describes the data and relationships that will be stored in the database.

Which of the following is true of a query?

It is a request that is executed to retrieve data from a database.

Which of the following describes the structure of a database?

Metadata

Which of the following is an open source document-oriented DBMS that is used by organizations because it does not require normalized data but manages collections of documents that have a variety of structures?

MongoDB

Which of the following is another name for a row in a database?

Record

The eHermes developers decide to use the SQL Server DBMS instead of MongoDB. What is the reason for this decision?

SQL Server will be less risky.

Which of the following is the primary purpose of using a database?

To keep track of data

Setting up user accounts, passwords, permissions, and limits for processing a database is part of database ________.

administration

All of the following are database administration activities EXCEPT ________.

creating the database tables, relationships, and other structures

Tables that are not normalized will likely have problems related to __________.

data integrity

Just as building architects create a blueprint before they start building, so, too, database developers create a __________ before they start designing the database.

data model

Keeping track of data is the primary purpose of a __________.

database

Changes in processing requirements for future IS systems have led to new categories of DBMS. All of the following are new DBMS categories EXCEPT ________.

output-memory DBMS

A column or group of columns that identifies a unique row in a table is a __________.

primary key

Attributes of an entity-relationship data model are best used to describe __________.

the characteristics of entities