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

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

A) Customer Order
B) Customer
C) Sales
D) Sales Order

Correct Answer

verified

Show Answer

Question 32

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

A) name.
B) birth date.
C) the same as the primary key in the first table.
D) a combination of primary keys in the first table.

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

Using a file-oriented approach to data and information,data is maintained in

Discuss redundancy as it applies to database design.

Suppose a relational database contained two linked tables.Assuming the organization wants the database to be normalized,which of the following items represents a problem to normalization?

________ is a feature in many database systems that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output.

Cornelia Cassidy is a telecom equipment sales representative.Her company has provided her with a laptop computer that uses wireless connectivity to access the accounting information system from virtually anywhere in the country.She,and other sales reps,have access to view customer and product information.All sales reps also have access that allows them to enter and cancel customer orders.The permissions for Cornelia define a ________ in the company's database management system.

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

In the Customer table below,"Customer #" is best described as

________ in a well-structured relational database.

The REA is an example of a database that uses a ________ data modeling approach to database design.

A data warehouse

Reports produced using the data dictionary could include all of the following except a list of

Shahnaz Vijaya is a new graduate who has been hired by a family-owned furniture manufacturing company in the south.She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements.After noting that the production and sales departments use database systems that are entirely separated,she recommends that they be combined.Implementation of her recommendation would benefit the company by contributing to data

The ________ occurs when more than one occurrence of a specific data item in a database exists.

In the database design approach known as normalization,the first assumption made about data is

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 notice that some customer last names have different first names in different records.For example,R.Framington Farnsworth,Bob Farnsworth,and Snake Farnsworth all seem to be the same person.You explain to Kai that every customer must be identified by a unique customer number in the AIS.You are referring to the

The ________ contains information about the structure of the database.

Record layouts,definitions,addresses,and indexes will be stored at the ________ level schema.

Describe a data dictionary.