Exam 4: Database Processing

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

Brenda,the sales manager of a firm,wants to generate a 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.

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

What is the purpose of a database?

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

Another important use of database application programs is to enable database processing over the Internet.

A group of related rows is called a table.

Entities in a data model have ________ that describe the characteristics of the entity.

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

Each entity in a database has a unique attribute called a(n)________.

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

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

Which of the following data elements is placed higher than records in the database hierarchy?

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

A NoSQL databases is a high-performance,special-requirements DBMS.

Foreign keys are commonly used to help link one table to another.

Normalization is the process of combining two or more tables into a single table.

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

Metadata are ________.

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.