Question 1

A partial dependency happens when an attribute that is dependent on a portion of the primary key not on the entire key.

Accepted Answer

A) True 
 B)False

Question 2

The approach to business event processing in which facts are stored in a relational database is

Accepted Answer

A) the database approach 
B) the applications approach 
C) the logical approach 
D) none of the above 
A) the database approach 
B) the applications approach 
C) the logical approach 
D) none of the above

Question 3

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 4

The normalization process involves various steps (called normal forms) that transform an original database design into an equivalent design that is free of problems.

Accepted Answer

A) True 
 B)False

Question 5

____ databases include abstract data types that allow users to define characteristics of the data to be stored when developing an application.

Accepted Answer

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

Question 6

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 7

In an entity-relationship diagram, _____________ are used to show the characteristics of relationships.

Accepted Answer

A) squares 
B) circles 
C) diamonds 
D) parallelograms 
A) squares 
B) circles 
C) diamonds 
D) parallelograms

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

primary ke

Question 10

Another name for sequential coding is ____________________ coding.

Accepted Answer

The answer of Another name for sequential coding is ____________________...

Question 11

Running an applications approach to sales and inventory programs leads to

Accepted Answer

A) a central database 
B) data redundancy 
C) higher efficiencies 
D) reports that are easier to query 
A) a central database 
B) data redundancy 
C) higher efficiencies 
D) reports that are easier to query

Question 12

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 13

A data model depicts user requirements for data stored in a database.

Accepted Answer

A) True 
 B)False

Question 14

An attribute is equivalent to a field and may also be known as a row.

Accepted Answer

A) True 
 B)False

Question 15

The database approach to business event processing, in which facts about events are stored in relational database tables instead of separate files, solves many of the problems caused by data redundancy.

Accepted Answer

A) True 
 B)False

Question 16

A(n) ____________________ table contains repeating attributes (or fields) within each row (or record).

Accepted Answer

The answer of A(n) ____________________ table contains repeating attributes (or...

Question 17

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 18

Both the mnemonic and the hierarchical coding schemes attach specific meaning to particular character positions.

Accepted Answer

A) True 
 B)False

Question 19

In a DBMS, an item that describes a portion of the elements of the record types and data items above it is called a

Accepted Answer

A) query language 
B) subschema 
C) Schema 
D) DML 
A) query language 
B) subschema 
C) Schema 
D) DML

Question 20

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...

A partial dependency happens when an attribute that is dependent on a portion of the primary key not on the entire key.

The approach to business event processing in which facts are stored in a relational database is

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

The normalization process involves various steps (called normal forms) that transform an original database design into an equivalent design that is free of problems.

____ databases include abstract data types that allow users to define characteristics of the data to be stored when developing an application.

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

In an entity-relationship diagram, _____________ are used to show the characteristics of relationships.

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

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

Another name for sequential coding is ____________________ coding.

Running an applications approach to sales and inventory programs leads to

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

A data model depicts user requirements for data stored in a database.

An attribute is equivalent to a field and may also be known as a row.

The database approach to business event processing, in which facts about events are stored in relational database tables instead of separate files, solves many of the problems caused by data redundancy.

A(n) ____________________ table contains repeating attributes (or fields) within each row (or record).

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.

Both the mnemonic and the hierarchical coding schemes attach specific meaning to particular character positions.

In a DBMS, an item that describes a portion of the elements of the record types and data items above it is called a

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 Receivable Cash Receipts Barcr Process

The Purchasing Process

Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

General Ledger and Business Reporting Glbr Process

Acquiring and Implementing Accounting Information Systems

Filters

Exam 5: Database Management Systems

A partial dependency happens when an attribute that is dependent on a portion of the primary key not on the entire key.

The approach to business event processing in which facts are stored in a relational database is

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

The normalization process involves various steps (called normal forms) that transform an original database design into an equivalent design that is free of problems.

____ databases include abstract data types that allow users to define characteristics of the data to be stored when developing an application.

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

In an entity-relationship diagram, _____________ are used to show the characteristics of relationships.

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

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

Another name for sequential coding is ____________________ coding.

Running an applications approach to sales and inventory programs leads to

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

A data model depicts user requirements for data stored in a database.

An attribute is equivalent to a field and may also be known as a row.

The database approach to business event processing, in which facts about events are stored in relational database tables instead of separate files, solves many of the problems caused by data redundancy.

A(n) ____________________ table contains repeating attributes (or fields) within each row (or record).

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.

Both the mnemonic and the hierarchical coding schemes attach specific meaning to particular character positions.

In a DBMS, an item that describes a portion of the elements of the record types and data items above it is called a

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 Receivable Cash Receipts Barcr Process

The Purchasing Process

Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

General Ledger and Business Reporting Glbr Process

Acquiring and Implementing Accounting Information Systems

Filters