Question 1

A relation in an ER model is the same as an entity in the REA model.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is an attribute but least likely to be 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 3

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 4

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

Accepted Answer

Referentia

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Customers of Hanson Company,a home furnishings wholesaler,place orders by contacting a sales representative via a toll-free number.Which is the appropriate relationship type for this relationship?

Accepted Answer

A)  1:1 
B)  1:N 
C)  N:M 
D)  N:1 
A)  1:1 
B)  1:N 
C)  N:M 
D)  N:1

Question 7

Based on the following abbreviated description of Avery University's course scheduling and student advising procedures,prepare an Entity-Relationship (E-R)diagram that reflects the key entities and relationships.
Course Scheduling:
In consultation with the vice-president of Academic Affairs and the Registrar's Office,each academic department chair decides which courses will be offered each semester and how many sections of each course will be scheduled.Courses are scheduled in sections meeting at different times over the course of the week.Some courses are scheduled in multiple sections.The department chair also assigns a faculty member who teaches for his/her department to teach each course-section.Students enroll in courses-sections by submitting their schedule selections to the Registrar's Office.In assigning students to sections,the Registrar gives preference to students based on their class standing (i.e. ,Senior,Junior,Sophomore,and Freshman).
Student Advising:
Student academic advising is done according to each student's major.Each student chooses a faculty advisor from his/her major department.While each student has only one "official" academic advisor,each faculty person advises several students,up to a maximum of 15 advisees.

Accepted Answer

See Figure

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

____ 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

Question 10

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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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

a.
SELECT
Employee_No,Date,Hours,Billing

Question 15

REA stands for ______________________________,______________________________ and ______________________________.

Accepted Answer

resources,events,agents
resour

Question 16

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 17

The cardinality constraint is used less frequently than the participation constraint.

Accepted Answer

A) True 
 B)False

Question 18

______________________________ values waste memory space and may cause problems when running queries.

Accepted Answer

The answer of ______________________________ values waste memory space and may...

Question 19

Which of the following is a composite 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

A missing value is called a non-null.

Accepted Answer

A) True 
 B)False

A relation in an ER model is the same as an entity in the REA model.

Which of the following is an attribute but least likely to be the key attribute?

Common aspects of business intelligence include:

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

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

Customers of Hanson Company,a home furnishings wholesaler,place orders by contacting a sales representative via a toll-free number.Which is the appropriate relationship type for this relationship?

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

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

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

Which of the following is the key attribute?

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

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

REA stands for , and __.

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.

The cardinality constraint is used less frequently than the participation constraint.

______________________________ values waste memory space and may cause problems when running queries.

Which of the following is a composite attribute?

A missing value is called a non-null.

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 relation in an ER model is the same as an entity in the REA model.

Which of the following is an attribute but least likely to be the key attribute?

Common aspects of business intelligence include:

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

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

Customers of Hanson Company,a home furnishings wholesaler,place orders by contacting a sales representative via a toll-free number.Which is the appropriate relationship type for this relationship?

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

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

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

Which of the following is the key attribute?

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

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

REA stands for ______________________________,______________________________ and ______________________________.

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.

The cardinality constraint is used less frequently than the participation constraint.

______________________________ values waste memory space and may cause problems when running queries.

Which of the following is a composite attribute?

A missing value is called a non-null.

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

REA stands for , and __.