Exam 14: Databases and Database Management Systems

Explain in-memory databases

DBMSs available for use on personal computers include ____ and Corel Paradox.

If a new database is to be used with existing data, the data needs to be transferred from its existing form into the new system-a process called ____.

____________________ refers to the process of ensuring that the data entered into a database matches the specified type, format, and allowable value.

____________________ entity relationships exist when one entity is related to only one other entity of a particular type.

The ____ is the most widely used database model today.

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.

With ____, data is stored in single multidimensional database structures (sometimes called data cubes).

Web-based database requests are received by the Web server, which then converts the request into a database query and passes it on to the database server with the help of software called ____.

With indexed organization, a(n) ____________________ is used to keep track of where data is stored.

____________________ rules are used when the value of one field in the record needs to be checked against another field in that same record to be sure it is valid.

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

With ____, the computer uses each record's primary key field and a mathematical formula called a hashing algorithm to determine a unique address that identifies where the record is physically stored in the database file.

A(n) ____________________ is a specific field in a database table that uniquely identifies the records in that table.

____ are made up of related records.

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

A ____ extracts specific information from a database by specifying particular conditions (called criteria) about the data you would like to retrieve.

____________________ usually includes the programs used with the database and the programs needed to connect the client and server components of the database system.

Data definition involves describing the properties of the data that go into each database table, specifically the ____ that make up the database.

When you are beginning to design a new database, sketching a(n) ____________________ of the reports and other desired database output can be helpful in identifying the fields that need to be included in the database.