Exam 4: Relational Databases

Explore all topics

Kekoa Konani is chairman of the Chatty Chihuahua Club,where he maintains a database of registered purebred Chihuahuas and their breeding history.One table will store the name,birth date,and other characteristics of all of the registered Chihuahuas.Each Chihuahua is uniquely identified by a registration number.A second table will contain data that link each Chihuahua to its male and female parents by means of their registration numbers.The entities described by the first table are

(Multiple Choice)

4.7/5

(40)

Question 81

Which of the following is false regarding a well-structured relational database?

(Multiple Choice)

4.9/5

(38)

Question 82

Seacrest Bedding is changing from a file-oriented system to a relational database system.Identify and design at least three tables that would be needed to capture data for a sales transaction.Each table should include a primary key,three non-key attributes,and foreign keys as necessary.Make up data values for two records within each table.

(Essay)

4.7/5

(47)

Question 83

The database design method in which a designer uses knowledge about business processes to create a diagram of the elements to be included in the database is called

(Multiple Choice)

4.9/5

(40)

Question 84

In the Customer table below,"Customer #" is best described as

(Multiple Choice)

4.7/5

(39)

Question 85

The logical structure of a database is described by the

(Multiple Choice)

4.8/5

(29)

Question 86

Which statement is true regarding file systems?

(Multiple Choice)

4.8/5

(35)

Question 87

Describe the information that is contained in the data dictionary.

(Essay)

4.9/5

(31)

Question 88

In a well-designed and normalized database,which of the following attributes would be a foreign key in a cash receipts table?

(Multiple Choice)

5.0/5

(41)

Question 89

Record layouts,definitions,addresses,and indexes will be stored at the ________ level schema.

(Multiple Choice)

4.8/5

(35)

Question 90

In a well-structured relational database,

(Multiple Choice)

4.8/5

(30)

Question 91

Identify one potential outcome of the delete anomaly.

(Multiple Choice)

4.9/5

(37)

Question 92

The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

(Multiple Choice)

4.8/5

(41)

Question 93

Which one of the following results corresponds to the query below?

(Multiple Choice)

4.9/5

(38)

Question 94

Creating an empty table in a relational database requires use of the ,and populating that table requires the use of .

(Multiple Choice)

4.8/5

(39)

Question 95

Describe a major advantage of database systems over file-oriented transaction processing systems.

(Essay)

4.8/5

(38)

Question 96

Using the database depicted below,"Date" is best described as

(Multiple Choice)

4.8/5

(35)

Question 97

The combination of the database,the DBMS,and the application programs that access the database through the DBMS is referred to as the

(Multiple Choice)

4.8/5

(34)

Question 98

Showing 81 - 98 of 98

Which of the following is false regarding a well-structured relational database?

The database design method in which a designer uses knowledge about business processes to create a diagram of the elements to be included in the database is called

In the Customer table below,"Customer #" is best described as

The logical structure of a database is described by the

Which statement is true regarding file systems?

Describe the information that is contained in the data dictionary.

In a well-designed and normalized database,which of the following attributes would be a foreign key in a cash receipts table?

Record layouts,definitions,addresses,and indexes will be stored at the ________ level schema.

In a well-structured relational database,

Identify one potential outcome of the delete anomaly.

The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

Which one of the following results corresponds to the query below?

Creating an empty table in a relational database requires use of the ,and populating that table requires the use of .

Describe a major advantage of database systems over file-oriented transaction processing systems.

Using the database depicted below,"Date" is best described as

The combination of the database,the DBMS,and the application programs that access the database through the DBMS is referred to as the

Accounting Information Systems: an Overview

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design,implementation,and Operation

Filters

Exam 4: Relational Databases

Which of the following is false regarding a well-structured relational database?

The database design method in which a designer uses knowledge about business processes to create a diagram of the elements to be included in the database is called

In the Customer table below,"Customer #" is best described as

The logical structure of a database is described by the

Which statement is true regarding file systems?

Describe the information that is contained in the data dictionary.

In a well-designed and normalized database,which of the following attributes would be a foreign key in a cash receipts table?

Record layouts,definitions,addresses,and indexes will be stored at the ________ level schema.

In a well-structured relational database,

Identify one potential outcome of the delete anomaly.

The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

Which one of the following results corresponds to the query below?

Creating an empty table in a relational database requires use of the ________,and populating that table requires the use of ________.

Describe a major advantage of database systems over file-oriented transaction processing systems.

Using the database depicted below,"Date" is best described as

The combination of the database,the DBMS,and the application programs that access the database through the DBMS is referred to as the

Accounting Information Systems: an Overview

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design,implementation,and Operation

Filters

Creating an empty table in a relational database requires use of the ,and populating that table requires the use of .