FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Behind the Scenes: Databases and Information Systems

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Short Answer

Review LaterAdd Note

Review Later

In a relational database, a(n) ________ relationship indicates that a record that appears only one time in a table, may appear multiple times in a related table.

Correct Answer

verified

one-to-man...

View Answer

Show Answer

Question 2

Matching

Review LaterAdd Note

Review Later

Match each of the following terms to its definition:

Premises

Responses

decision support system (DSS)

helps managers develop solutions for specific problems

office support system (OSS)

assists employees in day-to-day tasks and communication

management information system (MIS)

software system that integrates multiple system data sources and ties together the various processes of an organization

enterprise resource planning (ERP) system

communicates with computer systems using a natural spoken or written language

natural language processing (NLP)

provides managers with timely and accurate information

Premises

decision support system (DSS)

office support system (OSS)

management information system (MIS)

enterprise resource planning (ERP) system

natural language processing (NLP)

Responses

helps managers develop solutions for specific problems

assists employees in day-to-day tasks and communication

software system that integrates multiple system data sources and ties together the various processes of an organization

communicates with computer systems using a natural spoken or written language

provides managers with timely and accurate information

Show Answer

Correct Answer

Premises

Responses

decision support system (DSS)

office support system (OSS)

management information system (MIS)

enterprise resource planning (ERP) system

natural language processing (NLP)

Premises

decision support system (DSS)

office support system (OSS)

management information system (MIS)

enterprise resource planning (ERP) system

natural language processing (NLP)

Responses

Question 3

Short Answer

Review LaterAdd Note

A business that updates its records all at once at the end of the business day uses ________ processing.

________ databases are the most commonly used electronic databases.

A street address field is an example of a field that should have a default value.

You would use a ________ in a database to temporarily display records of residents for the city of Boston.

A(n) ________ report provides a consolidated picture of detailed data and usually includes some calculation or visual displays of information and is generated by a MIS.

________ is the process of ensuring that the data entered into a field meets specified guidelines.

Management information systems (MIS) provide ________ reports, which show conditions that are unusual or need attention from users of the system.

You can set a ________, which is automatically displayed in a field unless the user enters something different.

Match each of the following terms to its definition:

In an employee database, an employee's ID number, last name, first name, company position, address, city, state, and Zip Code make up a record.

A group of related records is called a table.

A(n) ________ is a way of retrieving information from one or more tables that defines a particular subset of data.

In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.

________ is used to ensure that data is organized most efficiently in a database.

A data ________ is a large-scale collection of data that contains and organizes all of an organization's data in one place.

Data ________ helps to ensure data integrity by maintaining information in only one place.

The information in a data mart spans an entire enterprise.

________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize.