Exam 5: Database Processing

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

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

The crow's-foot notation of an E-R diagram shows the maximum number of entities that can be involved in a relationship.

Columns that belong to a different table than the one in which they reside are called ________.

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

A ________ is a request for data from a database.

A data model is a ________.

Developers need to construct a data model before building a database.

Describe the elements of a data model.Provide examples.

Define primary key, foreign key, and metadata.

An administrator should create ________ before developing a database design.

Minimum cardinalities in an E-R diagram refer to the minimum number of entities required in a(n)________.

Special data that describes the structure of a database is called metadata.

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

In a database, when data items disagree with one another, this leads to a(n)________.

In data models, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

A data model describes data, whereas a database explains the relationships among the data that will be stored in the database.

A spreadsheet should be used to store data if the structure of the list is simple.

To modify an existing table, a developer opens the metadata form for that table and adds a new row of metadata.

Application programs process logic that is specific to a given business need.