Question 1

____________________ is a powerful database language that can be used to define database systems, query the database for information, generate reports from the database, and access databases from within programs using embedded commands.

Accepted Answer

The answer of ____________________ is a powerful database language that...

Question 2

A(n) ______________________________ system is a computer-based system that supports collaborative intellectual work such as idea generation, elaboration, analysis, synthesis, information sharing, and decision making.

Accepted Answer

The answer of A(n) ______________________________ system is a computer-based system...

Question 3

List 1 shows the coding schemes discussed and illustrated in Chapter 5, while List 2 contains eight coding examples.List 1 - Coding Schemes
  List 2 - Coding Examples
           Required:
On your solution sheet, list the numbers 1 through 8 from List 2.Next to each number, show the capital letter from List 1 that best describes the coding type represented by each example.HINT: Some letters from List 1 may be used for more than one coding example, while some letters may not be used at all.

Accepted Answer

The answer of List 1 shows the coding schemes discussed...

Question 4

A relation is in ______________________________ if it does not contain repeating groups.

Accepted Answer

The answer of A relation is in ______________________________ if it...

Question 5

___________________________________ is the process of capturing, storing, retrieving, and distributing the knowledge of the individuals in an organization for use by others in the organization to improve the quantity and/or efficiency of decision making.

Accepted Answer

The answer of ___________________________________ is the process of capturing, storing,...

Question 6

Given the following:
List 1 - Terms
A.data mining
B.data warehousing
C.decision support system
D.executive information system
E.expert system
F.group support system
G.intelligent agent
H.knowledge management
I.neural network
List 2 - Descriptions
1.This applies expertise extracted from a human expert to provide specific recommendations on problems or decisions.
2.These systems are mainly bout collecting and presenting information and often have the ability to drill down.
3.This is a computer hardware and software system that mimics the human brain's ability to recognize patterns or predict outcomes using less than complete information.
4.This is a computer-based system that supports collaborative intellectual work such as idea generation, elaboration, analysis, synthesis, information sharing, and decision making.
5.This is a software program that may be integrated into a decision support system or other software tool (such as word processing, spreadsheet, or database packages).
6.A spreadsheet is a typical component of this sytem.
7.This is the process of capturing, storing, retrieving, and distributing the knowledge of the individuals in an organization for use by others in the organization to improve the quality and efficiency of decision making across the firm.
8.This is the use of information systems facilities to focus on the collection, organization, integration, and long-term storage of entity-wide data.
9.This is used to better understand an organization's business processes, trends within these processes, and potential opportunities to improve the effectiveness and efficiency of the organization.
Required:
On your solution sheet, list the numbers 1 through 9 from List 2.Next to each number, show the capital letter from List 1 that best fits the description from List 2.

Accepted Answer

The answer of Given the following:
List 1 - Terms
A.data mining
B.data...

Question 7

In set theory, a two-dimensional collection of information is called a(n) ____________________.

Accepted Answer

The answer of In set theory, a two-dimensional collection of...

Question 8

Normalize the database structure in Figure TB 5.1 by transforming it into first normal form (1NF).

Accepted Answer

The answer of Normalize the database structure in Figure TB...

Question 9

_________________________ is a measure of the highest level of participation that one entity can have in another entity.

Accepted Answer

The answer of _________________________ is a measure of the highest...

Question 10

_________________________ are problems in a relation table caused by the existence of functional dependencies.

Accepted Answer

The answer of _________________________ are problems in a relation table...

Question 11

A computer's ability to imitate human decision making when confronting complex situations is called _____________.

Accepted Answer

The answer of A computer's ability to imitate human decision...

Question 12

_____________________________________________are mainly about collecting and presenting information and less about doing additional processing and calcuations.

Accepted Answer

The answer of _____________________________________________are mainly about collecting and presenting information...

Question 13

A(n) ___________________________________ is the attribute whose value is unique for every entity that will appear in the database.

Accepted Answer

The answer of A(n) ___________________________________ is the attribute whose value...

Question 14

A(n) ______________________________ is a computer hardware and software system that mimics the human brain's ability to recognize patterns or predict outcomes using less than complete information.

Accepted Answer

The answer of A(n) ______________________________ is a computer hardware and...

Question 15

A(n) ______________________________ is a software program integrated into a decision support system or other software tool that can perform tasks without further direction from the user.

Accepted Answer

The answer of A(n) ______________________________ is a software program integrated...

Question 16

________________________________________ are information systems that assist managers with unstructured decisions by retrieving and analyzing data for purposes of identifying and generating useful information.

Accepted Answer

The answer of ________________________________________ are information systems that assist managers...

Question 17

_________________________ can be used to capture and retain the expertise of retiring employees.

Accepted Answer

The answer of _________________________ can be used to capture and...

Question 18

A table is in ______________________________ if it is in first normal form and no non-key attribute is dependent on only a portion of the primary key.

Accepted Answer

The answer of A table is in ______________________________ if it...

Question 19

Transform the relation in Figure TB 5.3 to second normal form (2NF).Label each new relation with a name that describes the attributes.

Accepted Answer

The answer of Transform the relation in Figure TB 5.3...

Question 20

Transform the relation in Figure TB 5.5 to third normal form (3NF).Label each new relation with a name that describes the attributes.

Accepted Answer

The answer of Transform the relation in Figure TB 5.5...

Quiz 5: Database Management Systems