FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Relational Databases

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

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

A) primary keys
B) foreign keys
C) semantic keys
D) link keys

E) A) and C)
F) B) and C)

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

Which statement is true regarding file systems?

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.

E) A) and C)
F) None of the above

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

The physical view of a database system refers to

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

Databases were originally developed to address which problem?

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

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?

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

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

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

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

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

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

What is the difference in logical view and physical view?

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

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