Exam 12: Databases and Database Management Systems

Some client-server database systems just have two parts (the clients and the server), others have at least one middle component between the client and the server; these systems are referred to as n-tier database systems.

One advantage of the n-tier architecture is that it allows the program code used to access the database to be separate from the database, and the code can be divided into any number of logical components. _________________________

A ____ holds a single category of data (such as customer names or employee phone numbers) that will be stored in a database.

____________________ databases are also known as Database-as-a-Service (DBaaS).

The key characteristics for an OODBMS (including objects, attributes, methods, ____, and inheritance) are similar to the object-oriented programming principles.

Object-oriented and multidimensional databases are two examples of NoSQL (Not Only SQL) databases.

Individual database tables are often referred to as ____.

The data dictionary includes data located in the database tables.

The characteristics of an entity are called ____.

Data about data, such as the data contained in a data dictionary, is called ____________________ .

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

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 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; therefore, they decide to use the ____ language.

After all the tables in a database application have been created and their primary keys designated, the tables can be related to one another via their primary keys so that a primary key for one table can be used to extract data from other tables as needed. _________________________

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

The ____ is the most widely used database model today.

A field is also called a ____.

Arranging data for efficient retrieval is called data organization.

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

With a ____, the databases used by the system are all located on a single computer, such as a server or mainframe computer.

Describe a purpose of databases and the functions of a database management system (DBMS).