Exam 9: Data Design

To bridge the gap between a database and the Internet,it is necessary to use _____,which is software that integrates different applications and allows them to exchange data.

-In the accompanying figure,a _____ is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.

Web-based designs are dependent on a specific combination of hardware and software.

Like a primary key,a foreign key must be unique.

A schema is a set of letters or numbers that represents a data item.

Audit log files,which record details of all accesses and changes to a file or database,can be used to recover changes made since the last backup.

The three normal forms constitute a progression in which second normal form represents the best design.

Describe how middleware is used.

Field X is functionally dependent on field Y if the value of field X depends on the value of field Y.

_____ is an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data.

A common field is an attribute that appears in only one entity.

An M:N relationship is different from 1:1 or 1:M relationships because the event or transaction that links the two entities is actually a third entity,called an associative entity,that has its own characteristics.

A _____ controls database operations,including storing,retrieving,updating,and deleting data.

_____ is an integrated collection of data that can include seemingly unrelated information,no matter where it is stored in the company.

A table design is in third normal form (3NF)if it is in 2NF and if all nonkey fields are dependent on one another.

The data mining technique that relies on association rule learning is often called _____.

In a table or file,each column represents a record and each row represents a field.

A _____,which is not unique,is a field or combination of fields that can be used to access or retrieve records.

A secondary key is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.

_____ is the process of converting readable data into unreadable characters to prevent unauthorized access to the data.