Exam 12: Databases and Database Management Systems

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

What are the major roles and responsibilities of database administrators?

A key component of a DBMS is the ____________________ , the part of the program that actually stores and retrieves data.

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.

Middleware for cloud database applications is commonly written as ____-short sections of code written in a programming or scripting language that are executed by another program.

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

In ASPs, the code to tie the database to the Web site is typically written in JavaScript or ____.

Case-Based Critical Thinking Questions Case 14-2 The JL Group is a political think tank that is incorporating new media into their analyses. The JL Group has gathered data on voting habits. In order to make sure that respondents cannot claim to have voted in more elections than is possible given their age, ____ rules can be assigned to the database tables.

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.

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

Views need to be designed to extract the requested information from a relational database, as efficiently as possible.

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

In the third normal form (3NF), a table has no ____________________ dependencies; that is, two fields that are not primary keys and are dependent on one another.

____ create the actual database based on the design generated by the database designer and get it ready for data entry.

A ____ is a collection of related fields.

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

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

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____.

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

What is a NoSQL database?