MIS 5 – Flashcards

A database is required instead of a spreadsheet when ________.

Which of the following is the smallest data element in a database?

In a database, ________ are grouped into columns.

The columns in a database are called ________.

The rows in a database are called ________.

The tables that appear in a database are known as ________.

Which of the following data elements is placed higher than records in the database hierarchy?

A primary key used in a database is a ________.

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

Columns that are keys to different tables than the ones in which they reside are called ________.

Relational databases represent relationships using ________.

Metadata are ________.

A(n) ________ is a program used to create, process, and administer a database.

Which of the following is an example of a database management system?

Identify the open source DBMS product among the following.

Which of the following is true of MySQL?

When you modify or delete data present in a database, you are ________.

Which of the following is an international standard language for processing a database?

Which of the following is a developmental task of database administration?

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.

The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.

Which of the following database administration tasks is related to adaptation?

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

________ are used by users to read, insert, modify, and delete data in a database.

A(n) ________ is a request for data from a database.

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.

Which of the following is true of single-user databases?

Which of the following is true of traditional database application programs?

Traditional database applications programs are ________.

Browser applications are thin-client applications that ________.

Which of the following is used to process and display browser database application forms, reports, and queries?

Browser-based applications ________.

Browser-based applications ________.

Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?

A ________ describes the data and relationships that will be stored in a database.

An administrator should create a ________ before developing a database design.

A data model is a ________.

In a data model, a(n) ________ is something that a user wants to track.

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, percentage completed, and employee name. These aspects that Brad wants to track are called ________.

Entities in a data model have ________ that describe the characteristics of the entity.

Each entity in a database has a unique attribute called a(n) ________.

In an E-R diagram, a line between two entities represents a(n) ________.

The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________.

Which of the following is true of N:M relationships?

A student management system allows students to have multiple majors, and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.

________ in an E-R diagram refer to the least number of entities required in a relationship.

Constraints on the number of entities in a relationship are called ________ cardinalities.

In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

________ is the process of converting a data model into tables, relationships, and data constraints.

________ is the process of converting a poorly-structured table into two or more well-structured tables.

In a database, when data items disagree with one another, it leads to a(n) ________.

A data integrity problem will occur only if ________.

Every table in a normalized database has a ________.

Identify the first step in transforming a data model into a relational database design.

When using the relational model to represent two tables, one must ________.

Which of the following is true about the database development process?

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Which of the following is a nonrelational data store developed by Amazon?

Which of the following is a nonrelational data store developed by Google?

________ is the term used to describe data collections that are characterized by huge volume, rapid velocity, and great variety.