Exam 5: Database Processing

UML stands for ________.

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

If there is a small oval in the crow's foot notation,it means that there might not be any entity.

Managing the impact of database structure changes on applications and users is an operational task of the database administrator.

Describe a DBMS and its functions.List some of the popular DBMS softwares.

One of the development tasks of the database administrator is to develop a system to record and manage resolution of problems.

A collection of similar records is called a ________.

Databases that carry their data in the form of tables and that represent relationships using foreign keys are called foreign relationship databases.

List the various database administration tasks.Provide examples.

What are application programs and what are their functions?

The ________ data model is a tool for constructing data models.

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

One of the operational tasks of the database administrator is to determine processing rights/restrictions on each table and column.

If the same data element is stored differently in another table,this is said to be an issue of ________.

SQL is a(n)________.

Data-redundancy exemplifies one of the special characteristics of multi-user database processing.

Data aggregators obtain data from public and private sources and store and process it in sophisticated ways.

________ softwares assist in creating,maintaining,and manipulating databases.

In an entity-relationship diagram,a ________ on a line means that at least one entity type of that type is required.

The data integrity problem can occur only if ________.