Exam 5: Database Processing

To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.

Developers generally construct a logical representation of database data, called a data model, after building a database.

What is a database application?

In an E-R diagram, a line between two entities represents a(n) ________.

Every table in a normalized database has a ________.

The columns in a database are called ________.

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.

A(n) ________ is a request for data from a database.

Most organizations develop their own DBMS software in order to obtain control over data.

The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________.

In an entity-relationship (E-R) diagram, an entity is represented by a triangle, and the relationships between entities are represented by dotted lines.

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.

Which of the following is a nonrelational data store developed by Google?

An identifier is an attribute or a group of attributes whose value is associated with one, and only one, entity instance.

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

The format of metadata depends on the software product that is processing the database.

Database applications must present data to the users in the same format as the database table.

A primary key used in a database is a ________.

When you modify or delete data present in a database, you are ________.

Describe entities in the context of data models.