Exam 14: Databases and Database Management Systems

Many-to-many entity relationships exist when one entity can be related to more than one other entity,and those entities can be related to multiple entities of the same type as the original entity.

-The figure above illustrates a ____,created from data contained in a database.

Describe a database and a database management system (DBMS).

Explain in-memory databases

Some database programs allow you to create a table by just entering data,and then the program will create the ____________________ based on the data entered.

-The figure above shows an n-tier database model.

Repairing or restoring data that has become corrupt,perhaps as the result of a storage media error or computer virus,is a database analysis activity.

Continuing to evaluate and improve the security measured used with the database is a database ____ activity.

One of the properties that can be assigned to a field is a(n)____ to specify the format (such as letters,numbers,or symbols)that must be entered into a field.

The growth and importance of data warehousing today has led to another type of database model-the ______________________________.

The ____________________ in a database system are the ones who enter data,update data,and retrieve information from the database when necessary.

The ____ contains all data definitions for a database,including table structures,security information,relationships between the tables in the database,and so on.

Data integrity refers to the accuracy of data.

The JL Group is in the process of creating dynamic Web pages to poll politically aware young adults. They are interested in creating scripts that are compatible with many types of databases, so they are using the ____ language.

With a ____,a database is located in its entirety on a single computer,such as a server or mainframe computer.

A(n)____ is a small table consisting only of a list of the primary key field for each record in a table along with location information for that record.

Virtually all DBMSs include a ____ for easy data input,modification,and retrieval.

Arranging data for efficient retrieval is called data organization.

During ____________________,the fields in the tables are adjusted,if needed,to fit the criteria of first normal form before moving on to second normal form,and so forth.

At the top of the data hierarchy is the database,which consists of a group of related tables.