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 41

Multiple Choice

Review LaterAdd Note

Review Later

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

A) The DBMS automatically creates application software for users, based on data dictionary parameters.
B) The DBMS automatically maintains the data dictionary.
C) Users' requests for information are transmitted to the DBMS through application software.
D) The DBMS uses special languages to perform specific functions.

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

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

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

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

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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?

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

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

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

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

The logical view of a database system refers to

All of the following are benefits of the database approach except

The logical structure of a database is described by the

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 update anomaly in non-normalized database tables

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

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

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

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

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

In a well-structured relational database,

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

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