Exam 14: Databases and Database Management Systems

The ____ is the most widely used database model today.

The field in a table that is used to relate that table to other tables is called the ____.

Case 14-1 James is a recent college graduate and has six months of IT experience.He is thinking about pursuing a certification program in order to demonstrate that he is serious about IT. -Database designers work with systems analysts and other individuals involved in ____.

To create a query,users can either type a query using SQL or,more commonly,use the query tools built into the DBMS (such as a query design screen or query ____)to create a query object.

____________________ databases are located on a PC and are designed to be accessed by one user.

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 ____.

To protect against data loss caused by a database failure,accidental deletion,or other problem that renders the main copy of a database unusable,stringent backup procedures should be implemented.

Case 14-1 James is a recent college graduate and has six months of IT experience.He is thinking about pursuing a certification program in order to demonstrate that he is serious about IT. -James is most interested in becoming a database designer.Another name for this career choice is database ____.

In a typical client-server database application,the client is called the ____.

Hashing procedures usually result in two or more records being assigned the same storage address,an event known as a collision.

Most DBMSs come bundled with a set of tools to perform a variety of necessary tasks,such as building user interfaces,creating forms and reports,and interfacing with query languages and ____ for complex applications.

A(n)file management system is a program that allows the creation of individual database tables,each of which is stored in its own physical file and is not related to any other file.

____________________ 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.

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.

-In Microsoft Access,tables can be created in either Datasheet view or ____________________ view,as shown in the figure above.

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 ____.

Primary keys can be a combination of two key fields (called composite primary keys),but single primary keys are more typical in simple databases.

With MOLAP (Multidimensional OLAP),the multidimensional information is stored in an existing relational database using tables to store the summary information.

A ____ is a collection of related fields.

Structured query language (SQL)is recognized as the standard query language for relational databases.