Exam 4: Relational Databases

What is a data dictionary?

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:

Many database systems include a feature that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output.This feature is named the __________.

Name the three "anomalies" that may occur in an improperly designed relational database?

Chelsana Washington is a medical 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 the other sales reps,have read access to customer and product information.They have write access that allows them to enter and cancel customer orders.These permissions define a(an)______ in the company's database management system.

Define and distinguish between these terms: database,database management system,database system and database administrator.

The process of designing a database that is well-structured and free from anomalies is called

Identify the aspect of a normalized database that is incorrect:

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 describe multiple services.For example,Sheila Yasgur (notation: won lottery)got a custom chopper,multiple tattoos,and piercings in undiscloed locations (no pictures.)You realize that,in these cases,a single written record will have to be translated into multiple sales records.This is an example of what type of problem in the existing records?

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