Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

The constraint that is specifies the degree of minimum participation of one entity in the relationship with the other entity is called:

Accepted Answer

A) cardinality constraint 
B) participation constraint 
C) economic constraint 
D) logical constraint 
A) cardinality constraint 
B) participation constraint 
C) economic constraint 
D) logical constraint

Question 7

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 8

The SELECT statement has all but one of the following parts
a.a list of attributes that we wish to SELECT from the database
b.a WHEN clause
c.a list of tables where these attributes can be found
d.a WHERE clause

Accepted Answer

B
The following table is a vie

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

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 13

A situation in which a particular supplier provides more than one type of inventory item to a firm and a particular type of inventory item is acquired from more than a single supplier is called a(n):

Accepted Answer

A) one-to-one relationship 
B) one-to-many relationship 
C) many-to-many relationship 
D) entity relationship 
A) one-to-one relationship 
B) one-to-many relationship 
C) many-to-many relationship 
D) entity relationship

Question 14

In a relational database, the entity is represented as a(n):

Accepted Answer

A) table 
B) network 
C) field 
D) attribute 
A) table 
B) network 
C) field 
D) attribute

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Customers of Hanson Company, a home furnishings wholesaler, place orders by contacting a sales representative via a toll-free number.Identify the constraints of the following data model 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 17

Attributes that consist of multiple subattributes are referred to as _________________________.

Accepted Answer

composite

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

The mapping of the relationships between entities would be used in the development of a(n):

Accepted Answer

A) context diagram 
B) logical DFD 
C) physical DFD 
D) REA Model 
A) context diagram 
B) logical DFD 
C) physical DFD 
D) REA Model

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

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

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

Which of the following is the key attribute?

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

The constraint that is specifies the degree of minimum participation of one entity in the relationship with the other entity is called:

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.

The SELECT statement has all but one of the following parts a.a list of attributes that we wish to SELECT from the database b.a WHEN clause c.a list of tables where these attributes can be found d.a WHERE clause

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

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

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

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

A situation in which a particular supplier provides more than one type of inventory item to a firm and a particular type of inventory item is acquired from more than a single supplier is called a(n):

In a relational database, the entity is represented as a(n):

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

Customers of Hanson Company, a home furnishings wholesaler, place orders by contacting a sales representative via a toll-free number.Identify the constraints of the following data model relationship.

Attributes that consist of multiple subattributes are referred to as _________________________.

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

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

The mapping of the relationships between entities would be used in the development of 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 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 set of data that describes an instance of the entity represented by a relation is known as a(n) ____.

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

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

Which of the following is the key attribute?

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

The constraint that is specifies the degree of minimum participation of one entity in the relationship with the other entity is called:

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.

The SELECT statement has all but one of the following parts a.a list of attributes that we wish to SELECT from the database b.a WHEN clause c.a list of tables where these attributes can be found d.a WHERE clause

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

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

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

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

A situation in which a particular supplier provides more than one type of inventory item to a firm and a particular type of inventory item is acquired from more than a single supplier is called a(n):

In a relational database, the entity is represented as a(n):

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

Customers of Hanson Company, a home furnishings wholesaler, place orders by contacting a sales representative via a toll-free number.Identify the constraints of the following data model relationship.

Attributes that consist of multiple subattributes are referred to as _________________________.

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

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

The mapping of the relationships between entities would be used in the development of 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 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