Question 1

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

Accepted Answer

key

Question 2

The following E-R diagram shows a M:N relationship between two relations.To map this E-R diagram into a logical database model:

Accepted Answer

A)  divide the content of the Course relation to establish two relations having 1:N relationships 
B)  add the primary key of the Student relation as an attribute in the Course relation 
C)  create a new relation whose primary key is a composite of the primary keys of two relations 
D)  add the primary key of the Course relation as an attribute in the Student relation 
A)  divide the content of the Course relation to establish two relations having 1:N relationships 
B)  add the primary key of the Student relation as an attribute in the Course relation 
C)  create a new relation whose primary key is a composite of the primary keys of two relations 
D)  add the primary key of the Course relation as an attribute in the Student relation C

Question 3

The UPDATE command demonstrates one of the weaknesses in most forms of SQL.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

A set of data that describes a single instance of the entity represented by a relation is known as a tuple.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

Refer to Exhibit 6-1.Which of the following SQL statements would extract the client number and date for every instance that had a billing rate of $150?

Accepted Answer

A)  QUERY BILLING_HOURS
SELECT Client_No,Date
WHERE Rate=150 
B)  QUERY Client_No,Date
FROM BILLING_HOURS
WHERE Rate=150 
C)  SELECT Client_No,Date
WHERE Rate=150 
D)  SELECT Client_No,Date
FROM BILLING_HOURS
WHERE Rate=150 
A)  QUERY BILLING_HOURS
SELECT Client_No,Date
WHERE Rate=150 
B)  QUERY Client_No,Date
FROM BILLING_HOURS
WHERE Rate=150 
C)  SELECT Client_No,Date
WHERE Rate=150 
D)  SELECT Client_No,Date
FROM BILLING_HOURS
WHERE Rate=150

Question 8

The customer street address is often used as the key attribute in an REA diagram.

Accepted Answer

A) True 
 B)False

Question 9

A legacy system is one that has existed in an organization for less than one year.

Accepted Answer

A) True 
 B)False

Question 10

A primary attribute is the attribute whose value is unique for every entity that will appear in the database.

Accepted Answer

A) True 
 B)False

Question 11

A model is a complex representation of a simple entity or phenomenon.

Accepted Answer

A) True 
 B)False

Question 12

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 13

Students at Macom University use a Web-based course registration system.Identify the participation constraint of the following data model relationship.The university maintains student records until they graduate or do not enroll in a course for a 3-year period.

Accepted Answer

A)  N:M 
B)  1:N 
C)  (1,1):(0,N) 
D)  (1,1):(1,N) 
A)  N:M 
B)  1:N 
C)  (1,1):(0,N) 
D)  (1,1):(1,N)

Question 14

The cardinality constraint:

Accepted Answer

A)  specifies the degree of minimum participation of one entity in the relationship with the other entity. 
B)  provides more information than the participation constraint. 
C)  is the most common constraint specified in E-R diagrams. 
D)  all of the above. 
A)  specifies the degree of minimum participation of one entity in the relationship with the other entity. 
B)  provides more information than the participation constraint. 
C)  is the most common constraint specified in E-R diagrams. 
D)  all of the above.

Question 15

A(n)______________________________ in an accounting system can be classified as a resource,event,or agent about which data is collected.

Accepted Answer

The answer of A(n)______________________________ in an accounting system can be...

Question 16

Which of following is not a step in the process for specifying relations based on REA diagrams?

Accepted Answer

A)  Determine the attributes for each of the entities. 
B)  Determine the number of tables. 
C)  Create a separate relational table for each entity. 
D)  Implement the relationships among the entities. 
A)  Determine the attributes for each of the entities. 
B)  Determine the number of tables. 
C)  Create a separate relational table for each entity. 
D)  Implement the relationships among the entities.

Question 17

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

Accepted Answer

A)  Cardinality constraint 
B)  Participation constraint 
C)  Referential integrity 
D)  Economic constraint 
A)  Cardinality constraint 
B)  Participation constraint 
C)  Referential integrity 
D)  Economic constraint

Question 18

Business intelligence (BI)has been ranked as one of the top nine "key areas" of current developments in business information technology.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

participat

Question 20

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

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

The following E-R diagram shows a M:N relationship between two relations.To map this E-R diagram into a logical database model:

The UPDATE command demonstrates one of the weaknesses in most forms of SQL.

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

A set of data that describes a single instance of the entity represented by a relation is known as a tuple.

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

Refer to Exhibit 6-1.Which of the following SQL statements would extract the client number and date for every instance that had a billing rate of $150?

The customer street address is often used as the key attribute in an REA diagram.

A legacy system is one that has existed in an organization for less than one year.

A primary attribute is the attribute whose value is unique for every entity that will appear in the database.

A model is a complex representation of a simple entity or phenomenon.

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

Students at Macom University use a Web-based course registration system.Identify the participation constraint of the following data model relationship.The university maintains student records until they graduate or do not enroll in a course for a 3-year period.

The cardinality constraint:

A(n)______________________________ in an accounting system can be classified as a resource,event,or agent about which data is collected.

Which of following is not a step in the process for specifying relations based on REA diagrams?

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

Business intelligence (BI)has been ranked as one of the top nine "key areas" of current developments in business information technology.

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

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

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

Exam 6: Relational Databases and SQL

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

The following E-R diagram shows a M:N relationship between two relations.To map this E-R diagram into a logical database model:

The UPDATE command demonstrates one of the weaknesses in most forms of SQL.

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

A set of data that describes a single instance of the entity represented by a relation is known as a tuple.

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

Refer to Exhibit 6-1.Which of the following SQL statements would extract the client number and date for every instance that had a billing rate of $150?

The customer street address is often used as the key attribute in an REA diagram.

A legacy system is one that has existed in an organization for less than one year.

A primary attribute is the attribute whose value is unique for every entity that will appear in the database.

A model is a complex representation of a simple entity or phenomenon.

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

Students at Macom University use a Web-based course registration system.Identify the participation constraint of the following data model relationship.The university maintains student records until they graduate or do not enroll in a course for a 3-year period.

The cardinality constraint:

A(n)______________________________ in an accounting system can be classified as a resource,event,or agent about which data is collected.

Which of following is not a step in the process for specifying relations based on REA diagrams?

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

Business intelligence (BI)has been ranked as one of the top nine "key areas" of current developments in business information technology.

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

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

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