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 31

Multiple Choice

Review LaterAdd Note

Review Later

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

A) name.
B) birth date.
C) the primary key in the second table.
D) a foreign key in the second table.

E) A) and D)
F) A) and B)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

The ________ is responsible for the database.

A) database master
B) database manager
C) database administrator
D) data coordinator

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

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

Data dictionary can be used as part of the audit trail.

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

Databases were originally developed to address which problem?

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

The schema that provides an organization-wide view of the entire database is known as the

Pat Owen is chair of the National Grizzly Society,which maintains a database of all grizzly bears within the United States.One table will store the name,birth date,and other characteristics of all of the grizzly bears that have been registered.Each grizzly bear is uniquely identified by a registration number.A second table will contain data that link each grizzly bear to its male and female parents by means of their registration numbers.The entities described by the second table are

________ in a well-structured relational database.

A fully normalized database is called

File-oriented approaches create problems for organizations because of

Explain the types of attributes that tables possess in a relational database.

Explain the difference between file-oriented transaction processing systems and relational database systems.Discuss the advantages and disadvantages of each system.

-Using the database depicted above,"Date" is best described as

What acts as an interface between the database and the various application programs?

A data warehouse

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.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

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

Emma Kolb is a system analyst at a manufacturing company located in the Midwest.She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements.After noting that the same production files have been saved and stored independently on several databases,she recommends that they be stored only once.Implementation of her recommendation would benefit the company by contributing to