Exam 4: Relational Databases

In a well-structured relational database,

A ________ is an abstract representation of a database's contents.

The update anomaly in non-normalized database tables

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

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

Merlin Frodo has been doing custom piercings and tattoos for over thirty years.His home and place of business is a garage in the harbor district of Seattle,Washington.He keeps meticulous records of every job he has ever completed.These have been entered into a computerized accounting information system that his accountant refers to as a "data warehouse." Merlin is considering adding scarification to his service offerings and has asked his accountant to identify past customers who might be likely candidates for this service.Merlin wants his accountant to engage in

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 first table is

The logical view of a database system refers to

Suppose a relational database contained two linked tables.Which of the following items is not necessarily present in the database?

All of the following are benefits of the database approach except

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

Which would not generally be considered a data dictionary output report?

A low-level view of the database that describes how the data are actually stored and accessed is the

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

Ama Afolayan is chair of the National Owl Society,which maintains a database of all rare owls within the United States.One table will store the name,birth date,and other characteristics of all of the owls that have been registered.Each owl is uniquely identified by a registration number.A second table will contain data that link each owl to its male and female parents by means of their registration numbers.The primary key in the first table is

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

The logical structure of a database is described by the

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

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

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