Exam 4: Relational Databases

Kai Keoni has created custom statues made out of scrap metal for over ten years.He lives above his shop in Martha's Vineyard,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.As you look over his 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 pig statue,and Mike M.all seem to be the same person.This is an example of what type of problem in the existing records?

Which statement is true regarding file systems?

Identify the aspect of a well-structured database that is incorrect.

What is the difference in logical view and physical view?

The physical view of a database system refers to

Which of the following elements link rows in one table to rows in another table?

Databases were originally developed to address which problem?

A relational database in which customer data is not maintained independently of sales invoice data will most likely result in

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

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

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

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

Inability to add new data to a database without violating the basic integrity of the database is referred to as the

Helen Fume is a recruiter with The Ladders in Nome,Alaska.The Ladders success is largely attributable to its accounting information system.When a client is hired by an employer,Helen creates a record that identifies the employment relationship.Helen follows up on placements by surveying both employers and clients about the employment experience and then entering the results into the AIS.Clients are uniquely identified by social security number.In records that contain client survey data,the social security number is likely to be

Using the database depicted below,"Item #" is best described as

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 entities described by the second table are

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

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