Exam 5: Database Processing

A(n)________ is a self-describing collection of integrated records.

Which of the following is a valid observation of MySQL?

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

________ is the process of converting a data model into tables, relationships, and data constraints.

A ________ is a request for data from a database.

A database is best described as a collection of tables which are not related to each other.

Microsoft's SQL Server is an example of a personal DBMS product.

A(n)________ is a program used to create, process, and administer a database.

Which of the following refers to the problem that exists in database applications when two users update the same data item, but only one of those changes is recorded?

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

The small oval on a line in an E-R diagram means that the relationship is optional.

MySQL is an open-source DBMS product which is license-free for most database applications.

The lost-update problem can be resolved by implementing multi-user database processing.

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

Attributes are used to describe characteristics of entities.

Describe a database and its various elements.

A foreign key is essential in relational databases to represent the relationship between two tables.

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

Microsoft Access is both a DBMS and an application development product.

From among the following, identify the open source DBMS product.