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

Essay

Review LaterAdd Note

Review Later

What is the difference in logical view and physical view?

Correct Answer

verified

The logical view is how the user or prog...

View Answer

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

In a well-structured relational database,

A) every table must be related to at least one other table.
B) every table must be related to all other tables.
C) one table must be related to at least one other table.
D) one table must be related to all other tables.

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

Dana Halsey is chair of the Purebred Marmoset Society,which maintains a database of registered purebred marmosets and their breeding history.One table 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 table will contain data that link each marmoset to its male and female parents by means of their registration numbers.The entities described by the second table are:

A set of individual user views of the database is called the

In a well-designed and normalized database,which of the following attributes would be a foreign key in a cash receipts table?

Explain the difference between file-oriented transaction processing systems and relational database systems.Discuss the advantages and disadvantages of each system.

Scuz Bootes 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 handwritten 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 the

Which statement below concerning the database management system (DBMS) is false?

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?

Scuz Bootes 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 handwritten 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?

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

The data on this sales invoice would be generated from how many well-structured tables in a well-designed relational database?

Describe a data dictionary.

Dana Halsey is chair of the Purebred Marmoset Society,which maintains a database of registered purebred marmosets and their breeding history.One table 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 table will contain data that link each marmoset to its male and female parents by means of their registration numbers.The primary key in the first table is:

Scuz Bootes 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

The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

Dana Halsey is chair of the Purebred Marmoset Society,which maintains a database of registered purebred marmosets and their breeding history.One table 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 table will contain data that link each marmoset to its male and female parents by means of their registration numbers.The primary key in the second table is:

Discuss redundancy as it applies to database design.

List the four DBMS "languages" and describe who uses each and for what purpose.

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 access to view customer and product information.They have access that allows them to enter and cancel customer orders.The permissions for the sales reps define a(an) ________ in the company's database management system.