Exam 5: Database Processing

When a database form is processed to add a new record into a table, the DBMS converts the contents of the form into a ________statement.

Data type and description are examples of________ .

MySQL is popular because it is a(n) __________DBMS.

___________ is a query language that is portable between all relational DBMSs.

__________level DBMS like DB2 are designed for large, corporate database applications.

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

In E- R diagrams, attributes are represented with crow's feet.

In order to represent a ________type of relationship, a third table is created using the keys from the two entities being related.

Because database designs are often cumbersome, designers use ________diagrams.

The notation N:N indicates a many- to- many relationship.

The__________ is responsible for database backup.

A(n)__________ diagram is like a blueprint of a database application.

Data entry forms:

Each entity should have one unique identifier.

What is meant by a relational database? What are the advantages of relational database technology?

Lists with simple structures require databases.

The most complex type of a relationship is the__________ relationship.

An easy way to find out what is contained in a database is to look at the ________ .

"Name" would be a good identifier for a customer entity in a database application.

A__________ is a self- describing collection of integrated records.