Exam 4: Relational Databases

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

Discuss redundancy as it applies to database design.

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 REA is an example of a database that uses a ________ data modeling approach to database design.

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

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

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.

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

The ________ contains information about the structure of the database.

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

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

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

________ in a well-structured relational database.

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

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?

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

A data warehouse

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

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?

Describe a data dictionary.