A) has become the de facto standard database language B) can be used to define database systems C) both a. and b. D) none of the above A) has become the de facto standard database language B) can be used to define database systems C) both a. and b. D) none of the above

Exam 6: Relational Databases and SQL

Explore all topics

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

(Short Answer)

4.9/5

(30)

Question 61

The sequence of steps in identifying relationships in a model is:

(Multiple Choice)

4.7/5

(39)

Question 62

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

(True/False)

5.0/5

(38)

Question 63

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

(True/False)

4.8/5

(40)

Question 64

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

(Multiple Choice)

4.9/5

(36)

Question 65

Spreadsheets that are kept offline to an organization's enterprise systems can improve internal control.

(True/False)

4.9/5

(34)

Question 66

The ______________________________ specifies how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship.

(Short Answer)

4.8/5

(33)

Question 67

A missing value is called a non-null.

(True/False)

4.8/5

(37)

Question 68

______________________________ uses state-of-the-art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

(Short Answer)

4.7/5

(32)

Question 69

SQL

(Multiple Choice)

4.8/5

(41)

Question 70

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

(True/False)

4.7/5

(38)

Question 71

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

(Multiple Choice)

4.8/5

(37)

Question 72

A(n) ______________________________ is a primary key that is inserted into other tables to establish links among the tables.

(Short Answer)

4.8/5

(42)

Question 73

Knowledge management uses state-of-the art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

(True/False)

4.8/5

(40)

Question 74

An entity can be classified as all of the following except:

(Multiple Choice)

4.8/5

(34)

Question 75

The first step in identifying all the relationships that should be included in a model is to identify users' existing and desired information.

(True/False)

4.9/5

(32)

Question 76

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

(Multiple Choice)

4.9/5

(47)

Question 77

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

(Multiple Choice)

4.8/5

(25)

Question 78

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

(True/False)

4.8/5

(44)

Question 79

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

(Short Answer)

4.9/5

(44)

Question 80

Showing 61 - 80 of 103

______________________________ 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 sequence of steps in identifying relationships in a model is:

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

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

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

Spreadsheets that are kept offline to an organization's enterprise systems can improve internal control.

The ______________________________ specifies how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship.

A missing value is called a non-null.

______________________________ uses state-of-the-art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

SQL

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

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

A(n) ______________________________ is a primary key that is inserted into other tables to establish links among the tables.

Knowledge management uses state-of-the art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

An entity can be classified as all of the following except:

The first step in identifying all the relationships that should be included in a model is to identify users' existing and desired information.

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

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

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

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

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