Exam 4: Relational Databases

Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice?

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

Which statement below concerning the database management system (DBMS)is false?

Kai Keoni has created custom statues made out of scrap metal for over ten years.He lives above his shop in Martha's Vinyard,Maryland.Kai is an accounting fanatic and has kept detailed records of every statue he has ever created.For every sale,he obtains the customer's name and address,a description of the statue,and a picture of the statue sold to the customer.His unique style has recently attracted the attention of several celebrities.Ready to take his business to the next level,Kai has hired you to construct an accounting information system,which he wants modeled after his paper records.You begin development of the relational database that will form the core of the AIS by envisioning the record stored in a single table with a column that represents each attribute.You then begin to break this table down into smaller tables.This process is called

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

The ________ contains information about the structure of the database.

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

Discuss redundancy as it applies to database design.

The logical view of a database system refers to

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

The ________ handles the link between the way data are physically stored and each user's logical view of that data.

How do users retrieve data stored in a database?

In the Inventory table below,"Item number" is best described as

Identify one potential drawback in the design and implementation of database systems for accounting.

The REA is an example of a database that uses a ________ data modeling approach to database design.

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

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

Using the database depicted below,in the Sales table,"Customer #" is best described as

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 primary key in the second table is

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