Question 1

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

Accepted Answer

The answer of A(n) _________________________ is the attribute whose value...

Question 2

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

The answer of Based on the following abbreviated description of...

Question 3

Which relationship type does (1, N) mean?

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 4

To generate a standard report of a relational database, which of the following SQL commands would be used?

Accepted Answer

A) Select report 
B) Select view 
C) Create report 
D) Create view 
A) Select report 
B) Select view 
C) Create report 
D) Create view

Question 5

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

Which of the following is not a proper SQL command for creating database relations?

Accepted Answer

A) Create table employee 
B) Create table training_completed 
C) Create client 
D) Alter table release_time 
A) Create table employee 
B) Create table training_completed 
C) Create client 
D) Alter table release_time

Question 7

Which is not a step in creating a relation using SQL?

Accepted Answer

A) assign the relation a name 
B) assign each attribute a name 
C) specify the constraints on the attributes 
D) specify the attributes of the constraints 
A) assign the relation a name 
B) assign each attribute a name 
C) specify the constraints on the attributes 
D) specify the attributes of the constraints

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

An entity can be classified as all of the following except

Accepted Answer

A) resource 
B) event 
C) tuple 
D) agent 
A) resource 
B) event 
C) tuple 
D) agent

Question 10

____________________ map and define the way in which data can be extracted from a database.

Accepted Answer

The answer of ____________________ map and define the way in...

Question 11

A data field in a traditional file is similar to a relational:

Accepted Answer

A) table 
B) attribute 
C) tuple 
D) row 
A) table 
B) attribute 
C) tuple 
D) row

Question 12

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

Accepted Answer

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

Question 13

Students at Macom University use an 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 ______________________________ specifies the degree of minimum participation of one entity in the relationship with the other entity.

Accepted Answer

participat

Question 15

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

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 19

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 20

___________________________________ 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

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

Which relationship type does (1, N) mean?

To generate a standard report of a relational database, which of the following SQL commands would be used?

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

Which of the following is not a proper SQL command for creating database relations?

Which is not a step in creating a relation using SQL?

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

An entity can be classified as all of the following except

____________________ map and define the way in which data can be extracted from a database.

A data field in a traditional file is similar to a relational:

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

Students at Macom University use an 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 ______________________________ specifies the degree of minimum participation of one entity in the relationship with the other entity.

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

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

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

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

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

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

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

Which relationship type does (1, N) mean?

To generate a standard report of a relational database, which of the following SQL commands would be used?

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

Which of the following is not a proper SQL command for creating database relations?

Which is not a step in creating a relation using SQL?

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

An entity can be classified as all of the following except

____________________ map and define the way in which data can be extracted from a database.

A data field in a traditional file is similar to a relational:

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

Students at Macom University use an 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 ______________________________ specifies the degree of minimum participation of one entity in the relationship with the other entity.

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

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

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

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

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

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