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 41

Multiple Choice

Review LaterAdd Note

Review Later

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

A) a list of all programs where a data item is used.
B) a list of all synonyms for the data items in a particular file.
C) a list of all outputs where a data element is used.
D) a list of all the schemas included in a database.

E) A) and B)
F) B) and C)

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A)
B)
C)
D)

E) B) and C)
F) A) and C)

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

The software program that creates,manipulates,and accesses the database goes by the acronym

What is the difference between file-oriented transaction processing systems and relational database systems? Discuss the advantages and disadvantages of these systems.

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 entities described by the second 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,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.You explain to Scuz that every customer must be identified by a unique customer number in the AIS.You are referring to:

Which statement is true regarding file systems?

The potential inconsistency problem could arise when there are multiple occurrences of a data item in a database.This is called the

Heidi Holloway is a headhunter with Career Funnel in Boca Raton,Florida.Heidi is proud of the company's ability to "funnel workers into jobs." The foundation of CF's success is its accounting information system and,in particular,its list of employers and clients.Each employer is identified by a tax identification number and each client by a social security number.When a client is placed with an employer,a record is created in which these two numbers are

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.

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.You begin development of the relational database that will form the core of the AIS by envisioning the record stored in a single table with a column that represents each attribute.You then begin to break this table down into smaller tables.This process is called:

What are the main constraints when a relational database model is being logically designed?

Discuss the relational database data model.

What is the most popular type of database?

A well-structured or "normalized" database imposes several requirements on the structure of tables.The constraint that ensures the consistency of the database is known as

The ___________ acts as an interface between the database and the various application programs

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the __________ anomaly.

The combination of the database,the DBMS,and the application programs that access the database through the DBMS is referred to as the

The DBMS language that is used to build,initialize,and describe logical views for users is called the

What is the difference in logical view and physical view?