Question 1

Explain the two advantages semantic data modeling has over normalization when designing a relational database.

Accepted Answer

Semantic data modeling takes advantage o

Question 2

The problem of changes being incorrectly recorded in a database is known as

Accepted Answer

A)  an update anomaly. 
B)  an insert anomaly. 
C)  a delete anomaly. 
D)  a memory anomaly. 
A)  an update anomaly. 
B)  an insert anomaly. 
C)  a delete anomaly. 
D)  a memory anomaly.

Question 3

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

Accepted Answer

A DBMS will use data definition,data man

Question 4

In a relational database,requiring that every record in a table have a unique identifier is called the

Accepted Answer

A)  entity integrity rule. 
B)  referential integrity rule. 
C)  unique primary key rule. 
D)  foreign key rule. 
A)  entity integrity rule. 
B)  referential integrity rule. 
C)  unique primary key rule. 
D)  foreign key rule.

Question 5

What are the basic requirements when logically designing a relational database model?

Accepted Answer

Every row in every table must have a uni

Question 6

Using the database depicted below,how many primary keys are in the database?

Accepted Answer

A)  0 
B)  3 
C)  4 
D)  5 
A)  0 
B)  3 
C)  4 
D)  5

Question 7

Cornelia Cassidy is a telecom equipment sales representative.Her company has provided her with a laptop computer that uses wireless connectivity to access the accounting information system from virtually anywhere in the country.She has access to view customer and product information.She also has access that allows her to enter and cancel customer orders.The permissions for Cornelia (and other sales reps)define a ________ in the company's database management system.

Accepted Answer

A)  conceptual-level schema 
B)  data dictionary 
C)  external-level schema 
D)  physical view 
A)  conceptual-level schema 
B)  data dictionary 
C)  external-level schema 
D)  physical view

Question 8

Which is probably the most immediate and significant effect of database technology on accounting?

Accepted Answer

A)  replacement of the double entry-system 
B)  change in the nature of financial reporting 
C)  elimination of traditional records such as journals and ledgers 
D)  quicker access to and greater use of accounting information in decision-making 
A)  replacement of the double entry-system 
B)  change in the nature of financial reporting 
C)  elimination of traditional records such as journals and ledgers 
D)  quicker access to and greater use of accounting information in decision-making

Question 9

Explain the relational database data model.

Accepted Answer

A data model is an abstract representati

Question 10

A set of individual user views of the database is called the

Accepted Answer

A)  conceptual-level schema. 
B)  internal-level schema. 
C)  external-level schema. 
D)  meta-schema. 
A)  conceptual-level schema. 
B)  internal-level schema. 
C)  external-level schema. 
D)  meta-schema.

Question 11

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.

Accepted Answer

Customer table; ID (primary key),name,st

Question 12

Using the database depicted below,how many foreign keys are in the database?

Accepted Answer

A)  0 
B)  3 
C)  4 
D)  5 
A)  0 
B)  3 
C)  4 
D)  5

Question 13

Which of the statements below is incorrect?

Accepted Answer

A)  Semantic data modeling facilitates the efficient design of databases. 
B)  Semantic data modeling facilitates communicating with the intended users of the system. 
C)  Semantic data modeling allows a database designer to use knowledge about business processes to design the database. 
D)  Semantic data modeling follows the rules of normalization in the design of a database. 
A)  Semantic data modeling facilitates the efficient design of databases. 
B)  Semantic data modeling facilitates communicating with the intended users of the system. 
C)  Semantic data modeling allows a database designer to use knowledge about business processes to design the database. 
D)  Semantic data modeling follows the rules of normalization in the design of a database.

Question 14

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

Accepted Answer

A)  marmosets. 
B)  parental relationships. 
C)  registration numbers. 
D)  names. 
A)  marmosets. 
B)  parental relationships. 
C)  registration numbers. 
D)  names.

Question 15

How do users retrieve data stored in a database?

Accepted Answer

A)  by viewing the appropriate data tables 
B)  by executing a query 
C)  by performing a search 
D)  by specifying the primary keys 
A)  by viewing the appropriate data tables 
B)  by executing a query 
C)  by performing a search 
D)  by specifying the primary keys

Question 16

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

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D)

Question 17

List the four DBMS "languages" and describe who uses each and for what purpose.

Accepted Answer

DDL is the data definition language used

Question 18

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

Accepted Answer

A)  A foreign key cannot be null. 
B)  A primary key cannot be null. 
C)  Every column in a row must be single valued. 
D)  All nonkey attributes in a table must describe a characteristic of the object identified by the primary key. 
A)  A foreign key cannot be null. 
B)  A primary key cannot be null. 
C)  Every column in a row must be single valued. 
D)  All nonkey attributes in a table must describe a characteristic of the object identified by the primary key.

Question 19

The use of a data warehouse in strategic decision making is often referred to as

Accepted Answer

A)  business intelligence. 
B)  managerial accounting. 
C)  data analysis. 
D)  analytical modeling. 
A)  business intelligence. 
B)  managerial accounting. 
C)  data analysis. 
D)  analytical modeling.

Question 20

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

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D)

Explain the two advantages semantic data modeling has over normalization when designing a relational database.

The problem of changes being incorrectly recorded in a database is known as

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

In a relational database,requiring that every record in a table have a unique identifier is called the

What are the basic requirements when logically designing a relational database model?

Using the database depicted below,how many primary keys are in the database?

Which is probably the most immediate and significant effect of database technology on accounting?

Explain the relational database data model.

A set of individual user views of the database is called the

Using the database depicted below,how many foreign keys are in the database?

Which of the statements below is incorrect?

How do users retrieve data stored in a database?

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

List the four DBMS "languages" and describe who uses each and for what purpose.

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

The use of a data warehouse in strategic decision making is often referred to as

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

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

Explain the two advantages semantic data modeling has over normalization when designing a relational database.

The problem of changes being incorrectly recorded in a database is known as

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

In a relational database,requiring that every record in a table have a unique identifier is called the

What are the basic requirements when logically designing a relational database model?

Using the database depicted below,how many primary keys are in the database?

Which is probably the most immediate and significant effect of database technology on accounting?

Explain the relational database data model.

A set of individual user views of the database is called the

Using the database depicted below,how many foreign keys are in the database?

Which of the statements below is incorrect?

How do users retrieve data stored in a database?

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

List the four DBMS "languages" and describe who uses each and for what purpose.

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

The use of a data warehouse in strategic decision making is often referred to as

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

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