Question 1

Which statement is true regarding file systems?

Accepted Answer

A) Transaction files are similar to ledgers in a manual AIS. 
B) Multiple master files create problems with data consistency. 
C) Transaction files are permanent. 
D) Individual records are never deleted in a master file.

Question 2

Explain the relational database data model.

Accepted Answer

The answer of Explain the relational database data model....

Question 3

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

Accepted Answer

The answer of Explain the two advantages semantic data modeling...

Question 4

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.

Accepted Answer

A) purge 
B) erase 
C) delete 
D) integrity

Question 5

Discuss redundancy as it applies to database design.

Accepted Answer

The answer of Discuss redundancy as it applies to database...

Question 6

Mary Lamb is an insurance 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,and other sales reps,have access to view customer and insurance product information.All sales reps also have access that allows them to enter and cancel customer orders.The permissions for Mary define a ________ in the company's database management system.

Accepted Answer

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

Question 7

The ________ contains information about the structure of the database.

Accepted Answer

A) data definition language 
B) data dictionary 
C) data warehouse 
D) database management system

Question 8

Describe what you think will be the main impact of database technology in your career.

Accepted Answer

The answer of Describe what you think will be the...

Question 9

Identify the statement below that is false with regards to basic requirements of a relational database model.

Accepted Answer

A) Primary keys can be null. 
B) Foreign keys,if not null,must have values that correspond to the value of a primary key in another table. 
C) All non-key attributes in a table should describe a characteristic about the object identified by the primary key. 
D) Every column in a row must be single-valued.

Question 10

Describe a data dictionary.

Accepted Answer

The answer of Describe a data dictionary....

Question 11

Abby Burke has created custom statues made out of scrap metal for over ten years.Abby has kept detailed records of every statue she has ever created.For every sale,she obtains the customer's name and address,a description of the statue,and a picture of the statue sold to the customer.Her unique style has recently attracted the attention of several celebrities.Ready to take her business to the next level,Abby has hired you to construct an accounting information system,which she wants modeled after her paper records.As you look over her records,you realize that sometimes the same customer is recorded by a slightly different name.For example,Mike Mulligan bought a horse statue,M.Mulligan bought a bear statue,and Mike M.all seem to be the same person.This is an example of what type of problem in the existing records?

Accepted Answer

A) entity integrity 
B) referential integrity 
C) update anomaly 
D) insert anomaly

Question 12

The update anomaly in non-normalized database tables

Accepted Answer

A) occurs because of data redundancy. 
B) restricts addition of new fields or attributes. 
C) results in records that cannot be updated. 
D) is usually easily detected by users.

Question 13

Suppose a relational database contained two linked tables.Assuming the organization wants the database to be normalized,which of the following items represents a problem to normalization?

Accepted Answer

A) The database contains only one primary key. 
B) The database contains two foreign keys. 
C) The database contains two primary keys. 
D) The database contains only one foreign key.

Question 14

Tom Wilson is chairman of the Rare Car Club,where he maintains a database of registered rare cars and their history.One table will store the model,make,vehicle identification number,and other characteristics of all of the registered rare cars.Each rare car is uniquely identified by a registration number.A second table will contain data that link each rare car to its most recent estimated fair market value by means of their registration numbers.The entities described by the first table are

Accepted Answer

A) rare cars. 
B) estimated fair market value. 
C) registration numbers. 
D) vehicle identification numbers.

Question 15

Using a file-oriented approach to data and information,data is maintained in

Accepted Answer

A) a centralized database. 
B) many interconnected files. 
C) many separate files. 
D) a decentralized database.

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) 
 
B) 
 
C) 
 
D)

Question 18

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

Accepted Answer

A) 
 
B) 
 
C) 
 
D)

Question 19

What are the two ways to query a database using Microsoft Access?

Accepted Answer

The answer of What are the two ways to query...

Question 20

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

Accepted Answer

The answer of What are the basic requirements when logically...

Exam 4: Relational Databases

Which statement is true regarding file systems?

Explain the relational database data model.

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

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.

Discuss redundancy as it applies to database design.

The ________ contains information about the structure of the database.

Describe what you think will be the main impact of database technology in your career.

Identify the statement below that is false with regards to basic requirements of a relational database model.

Describe a data dictionary.

The update anomaly in non-normalized database tables

Suppose a relational database contained two linked tables.Assuming the organization wants the database to be normalized,which of the following items represents a problem to normalization?

Using a file-oriented approach to data and information,data is maintained in

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

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

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

What are the two ways to query a database using Microsoft Access?

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