Exam 4: Relational Databases

Dana Halsey is chair of the Purebred Marmoset Society,which maintains a database of registered purebred marmosets and their breeding history.Each marmoset is uniquely identified by a registration number.Originally,the database was stored on index cards,but recently Dana has been exploring the use of a computerized system.One file in the system will store the name,birth date,and other characteristics of all of the marmosets that have been registered.A second file will contain data that link each marmoset to its male and female parents by means of their serial numbers.The entities described by the first file are:

Scuz Bootes is a sexagenarian who has been doing custom choppers,piercings,and tattoos for over thirty years.His home and place of business is a garage in the harbor district of Seattle,Washington.He has meticulous records of every job he has ever done.These have been entered into a computerized accounting information system that his accountant refers to as a "data warehouse." Scuz is considering an expansion of his business into scarification,and has asked his accountant to identify past customers who might be likely candidates for this service.Scuz wants his accountant to engage in

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

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

The logical structure of a database is described by the

A DBMS must provide a way to define,manipulate,and query data in a database.This is accomplished by the use of three different languages.The language that is used to provide the function of data maintenance in a DBMS is

A database system separates the logical and physical view of data.Such separation facilitates the development of new applications since programmers can concentrate their efforts on coding application logic.The term physical view refers to

An attribute in a table that is a primary key in another table.

Redundancy can be a major problem in the design and operation of relational databases.If a database uses only one relation to store data,several problems may subsequently occur.The problem of changes (or updates)to data values being incorrectly recorded is known as

File-oriented approaches create problems for organizations because of

Which of the following would not be found in a data dictionary entry for a data item?

The problem of inability to add new data without violating the basic integrity of the database is referred to as the

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

Briefly explain the two advantages semantic data modeling has over normalization when designing a relational database.

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

The person responsible for the database is the

Scuz Bootes is a sexagenarian who has been doing custom choppers,piercings,and tattoos for over thirty years.His home and place of business is a garage in the harbor district of Seattle,Washington.He has meticulous records of every job he has ever done,carefully hand written with the customer name and address,a description of the job,and an attached picture of the bike or body part before and after customization.His unique style has recently attracted the attention of national media after several celebrities sought him out and showcased his work.Business is booming.Consequently,Scuz has hired you to construct an accounting information system,beginning with the historical records.As you read through the records,you notice that some customer last names have different first names in different records.For example,R.Framington Farnsworth (custom chopper),Bob Farnsworth (tattoo),and Snake Farnsworth (tattoos and piercings)all seem to be the same person.This is an example of what type of problem in the existing records?

Dana Halsey is chair of the Purebred Marmoset Society,which maintains a database of registered purebred marmosets and their breeding history.Originally,the database was stored on index cards,but recently Dana has been exploring the use of a computerized system.One file in the system will store the name,birth date,and other characteristics of all of the marmosets that have been registered.Each marmoset is uniquely identified by a registration number.A second file will contain data that link each marmoset to its male and female parents by means of their serial numbers.The primary key in the second file is:

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

A set of interrelated,centrally coordinated files is called