Exam 12: Databases and Database Management Systems

Typically, in hierarchical database management systems, a one-to-one relationship exists between data entities.

NoSQL databases are organized differently than relational databases are organized and therefore, they do not usually use tables and SQL. _________________________

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

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

In determining where to store specific data in a(n)  centralized DBMS , factors such as communications cost, response time, storage cost, and security are key considerations. _________________________

What is an in-memory database?

Case-Based Critical Thinking Questions 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 ____.

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

Discuss the advantages and disadvantages of the DBMS approach.

​One of the most common types of software used in conjunction with a multi-dimensional database is Online Analytical Processing (OLAP).

N-tier database systems provide a great deal of flexibility and scalability, allowing the system to be modified as new needs and opportunities arise.

In ____________________ organization, the order of the records is physically based on the content of the key field.

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 employees of JL Group who use the database of the company for their daily work, without having knowledge of how the underlying database is structured, interact with the database ____.

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

____ databases are designed to store a collection of summarized data for quick and easy data analysis.

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

In ____, the table field involved in the changes is locked until the changes to that field have been completed.

The growth and importance of data warehousing has led to another type of database model-the ______________________________.

When designing 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.

The ____ contains all data definitions for a database, including table structures, security information, relationships between the tables in the database, and so on.