Question 1

The goal of ______________________________ is to produce a database model that contains relationships that are in 3NF.

Accepted Answer

The answer of The goal of ______________________________ is to produce...

Question 2

A DBMS is a set of integrated computer programs designed to simplify the tasks of creating, accessing, and managing a centralized database.

Accepted Answer

A) True 
 B)False

Question 3

The ______________________________ approach to database design attempts to describe all aspects of the business events and processes under consideration.

Accepted Answer

The answer of The ______________________________ approach to database design attempts...

Question 4

Which of the following statements is true of a network database model?

Accepted Answer

A)  child records can have more than one parent record 
B)  parent records can have many child records 
C)  both a and b 
D)  none of the above 
A)  child records can have more than one parent record 
B)  parent records can have many child records 
C)  both a and b 
D)  none of the above

Question 5

A data model depicts the requirements for data as specified by the:

Accepted Answer

A)  database 
B)  enterprise 
C)  user 
D)  database administrator 
A)  database 
B)  enterprise 
C)  user 
D)  database administrator

Question 6

______________________________ is the most popular data modeling approach.

Accepted Answer

Entity-relationship

Question 7

Another name for sequential coding is block coding.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

A description of a portion of a schema is referred to as a(n) ______________________________.

Accepted Answer

The answer of A description of a portion of a...

Question 10

A table is in first normal form (1NF) if it has no partial dependencies; that is, no non-key attribute is dependent on only a portion of the primary key.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

The answer of A(n) ______________________________ depicts user requirements for data...

Question 12

A resource, event, or agent about which data are collected is called:

Accepted Answer

A)  an attribute 
B)  an entity 
C)  a relationship 
D)  a query 
A)  an attribute 
B)  an entity 
C)  a relationship 
D)  a query

Question 13

A relation is in second normal form (2NF) if it is in first normal form (1NF) and:

Accepted Answer

A)  if the only determinants it contains are candidate keys. 
B)  no non-key attribute is dependent on only a portion of the primary key. 
C)  it does not contain any repeating groups. 
D)  computed fields are eliminated. 
A)  if the only determinants it contains are candidate keys. 
B)  no non-key attribute is dependent on only a portion of the primary key. 
C)  it does not contain any repeating groups. 
D)  computed fields are eliminated.

Question 14

A(n) ______________________________ happens when an attribute is dependent on a portion of the primary key not on the entire key.

Accepted Answer

The answer of A(n) ______________________________ happens when an attribute is...

Question 15

An attribute is ______________________________ on a second attribute if the value for the first attribute determines a value for the second attribute at any time.

Accepted Answer

functional

Question 16

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

Accepted Answer

None

Question 17

Which of the following is not a database model discussed in Chapter 5:

Accepted Answer

A)  Relational 
B)  Hierarchical 
C)  Network 
D)  Physical 
A)  Relational 
B)  Hierarchical 
C)  Network 
D)  Physical

Question 18

In developing a data model, the term ______________________________ describes an association between entities.

Accepted Answer

The answer of In developing a data model, the term...

Question 19

In a(n) ____ database model, a child record may have more than one parent.

Accepted Answer

A)  hierarchical 
B)  relational 
C)  network 
D)  object-oriented 
A)  hierarchical 
B)  relational 
C)  network 
D)  object-oriented

Question 20

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

Accepted Answer

A) True 
 B)False

The goal of ______________________________ is to produce a database model that contains relationships that are in 3NF.

A DBMS is a set of integrated computer programs designed to simplify the tasks of creating, accessing, and managing a centralized database.

The ______________________________ approach to database design attempts to describe all aspects of the business events and processes under consideration.

Which of the following statements is true of a network database model?

A data model depicts the requirements for data as specified by the:

______________________________ is the most popular data modeling approach.

Another name for sequential coding is block coding.

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

A description of a portion of a schema is referred to as a(n) ______________________________.

A table is in first normal form (1NF) if it has no partial dependencies; that is, no non-key attribute is dependent on only a portion of the primary key.

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

A resource, event, or agent about which data are collected is called:

A relation is in second normal form (2NF) if it is in first normal form (1NF) and:

A(n) ______________________________ happens when an attribute is dependent on a portion of the primary key not on the entire key.

An attribute is ______________________________ on a second attribute if the value for the first attribute determines a value for the second attribute at any time.

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

Which of the following is not a database model discussed in Chapter 5:

In developing a data model, the term ______________________________ describes an association between entities.

In a(n) ____ database model, a child record may have more than one parent.

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

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 Oes Process

The Billingaccounts Receivablecash Receipts Barcr Process

The Purchasing Process

The Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

The General Ledger and Business Reporting GLBR Process

Acquiring and Implementing Accounting Information Systems

Filters

Exam 5: Database Management Systems

The goal of ______________________________ is to produce a database model that contains relationships that are in 3NF.

A DBMS is a set of integrated computer programs designed to simplify the tasks of creating, accessing, and managing a centralized database.

The ______________________________ approach to database design attempts to describe all aspects of the business events and processes under consideration.

Which of the following statements is true of a network database model?

A data model depicts the requirements for data as specified by the:

______________________________ is the most popular data modeling approach.

Another name for sequential coding is block coding.

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

A description of a portion of a schema is referred to as a(n) ______________________________.

A table is in first normal form (1NF) if it has no partial dependencies; that is, no non-key attribute is dependent on only a portion of the primary key.

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

A resource, event, or agent about which data are collected is called:

A relation is in second normal form (2NF) if it is in first normal form (1NF) and:

A(n) ______________________________ happens when an attribute is dependent on a portion of the primary key not on the entire key.

An attribute is ______________________________ on a second attribute if the value for the first attribute determines a value for the second attribute at any time.

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

Which of the following is not a database model discussed in Chapter 5:

In developing a data model, the term ______________________________ describes an association between entities.

In a(n) ____ database model, a child record may have more than one parent.

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

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 Oes Process

The Billingaccounts Receivablecash Receipts Barcr Process

The Purchasing Process

The Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

The General Ledger and Business Reporting GLBR Process

Acquiring and Implementing Accounting Information Systems

Filters