Exam 5: Database Management Systems

Data independence refers to decoupling the data from the system applications,and it is a major difference between the centralized database approach and the applications approach.

(True/False)

4.8/5

(79)

Question 101

Which of the following is not a relationship type?

(Multiple Choice)

4.9/5

(77)

Question 102

The traditional applications approach to business event processing concentrates on the process being performed.

(True/False)

4.8/5

(74)

Question 103

The model that only works well for simple data structures is the:

(Multiple Choice)

4.9/5

(77)

Question 104

The uniform product codes (UPCs)used by supermarkets and other retailers are examples of a(n)______________________________ coding scheme.

(Essay)

5.0/5

(77)

Question 105

An unnormalized table is a table that contains repeating attributes (or fields)within each row (or record).

(True/False)

4.8/5

(69)

Question 106

A(n)______________________________ depicts user requirements for data stored in a database.

(Essay)

4.8/5

(82)

Question 107

A secondary key uniquely identifies any row within a relational table.

(True/False)

4.9/5

(66)

Question 108

Data warehousing is the use of information systems facilities to focus on the collection,organization,integration,and long-term storage of entity-wide data.

(True/False)

4.8/5

(77)

Question 109

A record layout depicts:

(Multiple Choice)

4.9/5

(75)

Question 110

A description of a portion of a schema is referred to as a subschema.

(True/False)

5.0/5

(83)

Question 111

The centralized database approach to data management concentrates on the process being performed,rather than on the data themselves.

(True/False)

4.8/5

(76)

Question 112

Group Support Systems (GSS)focus on such functions as e-mail,scheduling,and document sharing.

(True/False)

4.8/5

(79)

Question 113

Executive information systems use complex processing and calculations to determine a solution to a problem.

(True/False)

4.7/5

(71)

Question 114

Given the following: 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.

(Essay)

4.7/5

(87)

Question 115

Data redundancy allows non-technical users to bypass the programmer and to access the database directly.

(True/False)

4.8/5

(85)

Question 116

Data flows that mirror and monitor business operations are called ____ flows.

(Multiple Choice)

4.9/5

(88)

Question 117

A company uses a 7-digit number to identify customers.For example,the customer 1532789 indicates the following information: Digits 1-2,state,15 = Georgia Digit 3,type of organization,3 = government agency Digit 4,credit terms,2 = 2/10,n/30 Digits 5-7,unique customer identifier,789 This type of coding scheme is:

(Multiple Choice)

4.9/5

(98)

Question 118

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

(Essay)

5.0/5

(86)

Question 119

A(n)____ depicts user requirements for data stored in a database.

(Multiple Choice)

4.7/5

(73)

Question 120

Showing 101 - 120 of 175

Data independence refers to decoupling the data from the system applications,and it is a major difference between the centralized database approach and the applications approach.

Which of the following is not a relationship type?

The traditional applications approach to business event processing concentrates on the process being performed.

The model that only works well for simple data structures is the:

The uniform product codes (UPCs)used by supermarkets and other retailers are examples of a(n)______________________________ coding scheme.

An unnormalized table is a table that contains repeating attributes (or fields)within each row (or record).

A(n)______________________________ depicts user requirements for data stored in a database.

A secondary key uniquely identifies any row within a relational table.

Data warehousing is the use of information systems facilities to focus on the collection,organization,integration,and long-term storage of entity-wide data.

A record layout depicts:

A description of a portion of a schema is referred to as a subschema.

The centralized database approach to data management concentrates on the process being performed,rather than on the data themselves.

Group Support Systems (GSS)focus on such functions as e-mail,scheduling,and document sharing.

Executive information systems use complex processing and calculations to determine a solution to a problem.

Given the following: 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.

Data redundancy allows non-technical users to bypass the programmer and to access the database directly.

Data flows that mirror and monitor business operations are called ____ flows.

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

A(n)____ depicts user requirements for data stored in a database.

Introduction to Accounting Information Systems

Enterprise Systems

Electronic Business E-Business-Systems

Documenting Information Systems

Relational Databases and SQL

Controlling Information Systems: Introduction to Enterprise Risk Management and Internal Control

Controlling Information Systems: Introduction to Pervasive Controls

Controlling Information Systems: Business Process and Application Controls

The Order Entrysales Oesprocess

The Billingaccounts Receivablecash Receipts Barcrprocess

The Purchasing Process

The Accounts Payablecash Disbursements Apcdprocess

The Human Resources Process Hrmanagement and Payroll Processes

Integrated Production Processes IPP

The General Ledger and Business Reporting Glbrprocess

Acquiring and Implementing Accounting Information Systems

Filters