Question 1

The ______________________________ specifies the degree of minimum participation of one entity in the relationship with the other entity.

Accepted Answer

participat

Question 2

REA stands for resources, entities and agents.

Accepted Answer

A) True 
 B)False

Question 3

The ______________________________ command is used when we want to change one or more attribute values for one or more tuples in a table.

Accepted Answer

The answer of The ______________________________ command is used when we...

Question 4

Which of the following is not a relationship type?

Accepted Answer

A)  one-to-many 
B)  one-to-one 
C)  one-to-few 
D)  many-to-many 
A)  one-to-many 
B)  one-to-one 
C)  one-to-few 
D)  many-to-many

Question 5

The fundamental requirement for moving toward an event-driven model is the complete integration of data related to an organization's business events.

Accepted Answer

A) True 
 B)False

Question 6

A set of data that describes a single instance of the entity represented by a relation is known as a(n) ______________________________.

Accepted Answer

The answer of A set of data that describes a...

Question 7

The notation of (1,1) is used to specify the relationship type of one-to-many.

Accepted Answer

A) True 
 B)False

Question 8

The ______________________________ command is used to add new tuples to a relation.

Accepted Answer

The answer of The ______________________________ command is used to add...

Question 9

Relational integrity specifies that for every attribute value in one relation that has been specified to allow reference to another relation, the tuple being referenced must remain intact.

Accepted Answer

A) True 
 B)False

Question 10

A(n) ______________________________ is an item of data that characterizes an entity or relationship.

Accepted Answer

The answer of A(n) ______________________________ is an item of data...

Question 11

The notation 1:N is used to specify the relationship type of ______________________________.

Accepted Answer

one to man

Question 12

Common aspects of business intelligence include:

Accepted Answer

A)  access to massive amounts of data 
B)  use spreadsheets 
C)  does not require an extensive overhaul of the information system 
D)  all of the above 
A)  access to massive amounts of data 
B)  use spreadsheets 
C)  does not require an extensive overhaul of the information system 
D)  all of the above

Question 13

In an REA diagram, the rectangle is used to represent the composite attribute.

Accepted Answer

A) True 
 B)False

Question 14

The secondary key is specified to uniquely identity each tuple in the relation.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following commands allow us to join data across multiple tables to link specific pieces of information that are of interest?

Accepted Answer

A)  Select 
B)  Project 
C)  Join 
D)  Display 
A)  Select 
B)  Project 
C)  Join 
D)  Display

Question 16

Representing supervisors and their employees as separate entities in the model can lead to data redundancy.

Accepted Answer

A) True 
 B)False

Question 17

For the following entity and attribute model, what would be the key attribute of the Students entity?

Accepted Answer

A)  social security number 
B)  name 
C)  address 
D)  street 
A)  social security number 
B)  name 
C)  address 
D)  street

Question 18

______________________________ 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 19

A(n) ______________________________ relationship occurs between two different instances of an entity.

Accepted Answer

The answer of A(n) ______________________________ relationship occurs between two different...

Question 20

Queries of a database are driven by SELECT commands.

Accepted Answer

A) True 
 B)False

The ______________________________ specifies the degree of minimum participation of one entity in the relationship with the other entity.

REA stands for resources, entities and agents.

The ______________________________ command is used when we want to change one or more attribute values for one or more tuples in a table.

Which of the following is not a relationship type?

The fundamental requirement for moving toward an event-driven model is the complete integration of data related to an organization's business events.

A set of data that describes a single instance of the entity represented by a relation is known as a(n) ______________________________.

The notation of (1,1) is used to specify the relationship type of one-to-many.

The ______________________________ command is used to add new tuples to a relation.

Relational integrity specifies that for every attribute value in one relation that has been specified to allow reference to another relation, the tuple being referenced must remain intact.

A(n) ______________________________ is an item of data that characterizes an entity or relationship.

The notation 1:N is used to specify the relationship type of ______________________________.

Common aspects of business intelligence include:

In an REA diagram, the rectangle is used to represent the composite attribute.

The secondary key is specified to uniquely identity each tuple in the relation.

Which of the following commands allow us to join data across multiple tables to link specific pieces of information that are of interest?

Representing supervisors and their employees as separate entities in the model can lead to data redundancy.

For the following entity and attribute model, what would be the key attribute of the Students entity?

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

A(n) ______________________________ relationship occurs between two different instances of an entity.

Queries of a database are driven by SELECT commands.

Introduction to Accounting Information Systems

Enterprise Systems

Electronic Business E-Business Systems

Documenting Information Systems

Database Management Systems

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 6: Relational Databases and SQL

The ______________________________ specifies the degree of minimum participation of one entity in the relationship with the other entity.

REA stands for resources, entities and agents.

The ______________________________ command is used when we want to change one or more attribute values for one or more tuples in a table.

Which of the following is not a relationship type?

The fundamental requirement for moving toward an event-driven model is the complete integration of data related to an organization's business events.

A set of data that describes a single instance of the entity represented by a relation is known as a(n) ______________________________.

The notation of (1,1) is used to specify the relationship type of one-to-many.

The ______________________________ command is used to add new tuples to a relation.

Relational integrity specifies that for every attribute value in one relation that has been specified to allow reference to another relation, the tuple being referenced must remain intact.

A(n) ______________________________ is an item of data that characterizes an entity or relationship.

The notation 1:N is used to specify the relationship type of ______________________________.

Common aspects of business intelligence include:

In an REA diagram, the rectangle is used to represent the composite attribute.

The secondary key is specified to uniquely identity each tuple in the relation.

Which of the following commands allow us to join data across multiple tables to link specific pieces of information that are of interest?

Representing supervisors and their employees as separate entities in the model can lead to data redundancy.

For the following entity and attribute model, what would be the key attribute of the Students entity?

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

A(n) ______________________________ relationship occurs between two different instances of an entity.

Queries of a database are driven by SELECT commands.

Introduction to Accounting Information Systems

Enterprise Systems

Electronic Business E-Business Systems

Documenting Information Systems

Database Management Systems

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