Question 1

____ are defined as a set of data that describes an instance of the entity represented by a relation.

Accepted Answer

A)  Attributes 
B)  Tuples 
C)  Primary keys 
D)  Candidate keys 
A)  Attributes 
B)  Tuples 
C)  Primary keys 
D)  Candidate keys B

Question 2

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

Question 3

The notation 1:N is used to specify the relationship type of one-to-many.

Accepted Answer

A) True 
 B)False  True

Question 4

A(n) ______________________________ a simplified representation of a complex entity or phenomenon.

Accepted Answer

The answer of A(n) ______________________________ a simplified representation of a...

Question 5

Composite attributes consist of multiple subattributes.

Accepted Answer

A) True 
 B)False

Question 6

A(n) ____ of an entity is one specific thing of the type defined by the entity.

Accepted Answer

A)  agent 
B)  composite attribute 
C)  attribute 
D)  instance 
A)  agent 
B)  composite attribute 
C)  attribute 
D)  instance

Question 7

The following table is a view of TRAINING_COMPLETED from the various data elements in High-Tech Corp.'s relational database:
   Required:
a. Using proper SQL commands, develop a query to extract training data for employee Missy Pitman (employee number 11111), showing the date, hours, and training code.
b. Design a table showing the output that would be generated based upon your query created above.

Accepted Answer

The answer of The following table is a view of...

Question 8

Legacy systems do not usually have which of the following characteristics?

Accepted Answer

A)  developed on previous hardware (and/or software) platforms 
B)  are easily adaptable to enterprise systems 
C)  have been used by an organization for a long period of time 
D)  all of the above are typical characteristics of legacy systems 
A)  developed on previous hardware (and/or software) platforms 
B)  are easily adaptable to enterprise systems 
C)  have been used by an organization for a long period of time 
D)  all of the above are typical characteristics of legacy systems

Question 9

Which of the following is the entity or agent?

Accepted Answer

A)  Client 
B)  client number 
C)  client name 
D)  client street address 
A)  Client 
B)  client number 
C)  client name 
D)  client street address

Question 10

A collection of data representing multiple occurrences of a resource, event, or agent is known as a relation.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Exhibit 6-1
The following table is a view of BILLING_HOURS from the various data elements in High-Tech Corp.'s relational database.$\begin{array}{|c|c|c|c|c|c|}
\hline\text { I BILLING HOURS }& \text { Employee No } & \text { Clieat No } & \text { Date } & \text { Hours } & \text { Ballizug Rate } \
\hline &\text { B122 } & \text { F26768 } & 20010823 & 8 & 150 \
\hline &\text { A632 } & \text { F11555 } & 20010823 & 7 & 100 \
\hline& \text { B122 } & \text { F26768 } & 20010824 & 8 & 150 \
\hline& \text { A632 } & \text { F11555 } & 20010824 & 6 & 100 \
\hline& \text { B122 } & \text { F26768 } & 20010825 & 9 & 150 \
\hline &\text { A632 } & \text { F11555 } & 20010825 & 10 & 100 \
\hline
\end{array}$

-Refer to Exhibit 6-1. Which of the following SQL statements would extract the client number and date for every instance that an employee worked less than 8 hours any particular day?

Accepted Answer

A)  QUERY BILLING_HOURS
SELECT Client_No, Date
WHERE Hours8 
C)  SELECT Client_No, Date
WHERE Hours<8 
D)  SELECT Client_No, Date
FROM BILLING_HOURS
WHERE Hours<8 
A)  QUERY BILLING_HOURS
SELECT Client_No, Date
WHERE Hours8 
C)  SELECT Client_No, Date
WHERE Hours<8 
D)  SELECT Client_No, Date
FROM BILLING_HOURS
WHERE Hours<8

Question 13

The ______________________________ command demonstrates one of the weaknesses in most forms of SQL because the database will not enforce referential integrity.

Accepted Answer

The answer of The ______________________________ command demonstrates one of the...

Question 14

Attributes are often called fields.

Accepted Answer

A) True 
 B)False

Question 15

SQL 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

A) True 
 B)False

Question 16

Most DBMS available today that include SQL also include mechanisms within the DBMS itself for establishing and enforcing referential integrity.

Accepted Answer

A) True 
 B)False

Question 17

The following table is a view of BILLING_HOURS from the various data elements in ABC's relational database:
   
Required:
a. Using proper SQL commands, develop a query to extract billing data for Fleet Services (client number F11555), showing the employee number, date, hours, and billing rate.
b. Design a table showing the output that would be generated based upon your query created above.

Accepted Answer

The answer of The following table is a view of...

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

Which of the following is the key attribute?

Accepted Answer

A)  Client 
B)  client number 
C)  client name 
D)  client street address 
A)  Client 
B)  client number 
C)  client name 
D)  client street address

Question 20

Which of the following is a valid SQL command?

Accepted Answer

A)  MODIFY 
B)  INSERT 
C)  ADD 
D)  APPEND 
A)  MODIFY 
B)  INSERT 
C)  ADD 
D)  APPEND

____ are defined as a set of data that describes an instance of the entity represented by a relation.

The cardinality constraint:

The notation 1:N is used to specify the relationship type of one-to-many.

A(n) ______________________________ a simplified representation of a complex entity or phenomenon.

Composite attributes consist of multiple subattributes.

A(n) ____ of an entity is one specific thing of the type defined by the entity.

Legacy systems do not usually have which of the following characteristics?

Which of the following is the entity or agent?

A collection of data representing multiple occurrences of a resource, event, or agent is known as a relation.

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

The ______________________________ command demonstrates one of the weaknesses in most forms of SQL because the database will not enforce referential integrity.

Attributes are often called fields.

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

Most DBMS available today that include SQL also include mechanisms within the DBMS itself for establishing and enforcing referential integrity.

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

Which of the following is the key attribute?

Which of the following is a valid SQL command?

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

____ are defined as a set of data that describes an instance of the entity represented by a relation.

The cardinality constraint:

The notation 1:N is used to specify the relationship type of one-to-many.

A(n) ______________________________ a simplified representation of a complex entity or phenomenon.

Composite attributes consist of multiple subattributes.

A(n) ____ of an entity is one specific thing of the type defined by the entity.

Legacy systems do not usually have which of the following characteristics?

Which of the following is the entity or agent?

A collection of data representing multiple occurrences of a resource, event, or agent is known as a relation.

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

The ______________________________ command demonstrates one of the weaknesses in most forms of SQL because the database will not enforce referential integrity.

Attributes are often called fields.

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

Most DBMS available today that include SQL also include mechanisms within the DBMS itself for establishing and enforcing referential integrity.

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

Which of the following is the key attribute?

Which of the following is a valid SQL command?

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