Exam 4: Relational Databases

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

All of the following are benefits of the database approach except

Creating an empty table in a relational database requires use of the ________,and populating that table requires the use of ________.

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

A row in a table that contains data about a specific item in a database table is call

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

Identify one potential outcome of the update anomaly.

When the human resources manager wants to build a data dictionary,the manager would use which language?

Explain the relational database data model.

The problem of changes being incorrectly recorded in a database is known as

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

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

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

Describe a data dictionary.

The update anomaly in non-normalized database tables

Mary Lamb is an insurance 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 insurance product information.All sales reps also have access that allows them to enter and cancel customer orders.The permissions for Mary define a ________ in the company's database management system.

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

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

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

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.As you look over her 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 bear statue,and Mike M.all seem to be the same person.This is an example of what type of problem in the existing records?