Question 1

In the Course file, the string "Anatomy" can best be described as a _____.

Accepted Answer

A)  field type 
B)  field occurrence 
C)  record type 
D)  record occurrence 
E)  entity 
A)  field type 
B)  field occurrence 
C)  record type 
D)  record occurrence 
E)  entity

Question 2

There are three basic ways of retrieving data: sequential access, interrupted access, and direct access.

Accepted Answer

A) True 
 B)False

Question 3

Retrieving a subset of the records of a file based on a field value is an example of _____.

Accepted Answer

A)  immediate sequential retrieval 
B)  logical sequential retrieval 
C)  physical sequential retrieval 
D)  direct retrieval 
E)  indirect retrieval 
A)  immediate sequential retrieval 
B)  logical sequential retrieval 
C)  physical sequential retrieval 
D)  direct retrieval 
E)  indirect retrieval

Question 4

An attribute of the records of a file that has unique values can be referred to as the key field.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following does not change the contents of a file?

Accepted Answer

A)  retrieve 
B)  insert 
C)  delete 
D)  update 
E)  all of the above 
A)  retrieve 
B)  insert 
C)  delete 
D)  update 
E)  all of the above

Question 6

The amount of data redundancy has no bearing on the amount of time it takes to update the data.

Accepted Answer

A) True 
 B)False

Question 7

All of the following are major DBMS approaches, except _____.

Accepted Answer

A)  network 
B)  index 
C)  object-oriented 
D)  relational 
E)  hierarchical 
A)  network 
B)  index 
C)  object-oriented 
D)  relational 
E)  hierarchical

Question 8

Problems
The following Animal File from the Central Zoo will be used in several of the following questions. The left-hand column of relative record numbers is there to facilitate answering the questions.
 \(\begin{array}{lr}
&\text { Animal } \quad\quad\quad\quad\quad\quad\quad\quad \text { Animal } \quad\quad\quad\quad\quad \text { Country of } \quad\quad\quad\quad\
&\text { Number } \quad\quad \text { Species }\quad\quad\quad  \text { Name }\quad\quad \text { Gender }  \quad\text { Birth }\quad\quad\text { Weight }\
\begin{array}{lr}
1\2\3\4\5\6\7\8\9\10
\end{array}&
\begin{array}{|r|l|l|l|l|r|}
\hline 13648 & \text { Elephant } & \text { Jumbo } & \text { M }\quad\quad & \text { Uganda } & 6,000 \
\hline 14990 & \text { Kangaroo } & \text { Fred } & \text { M } & \text { Australia } & 200 \
\hline 17543 & \text { Elephant } & \text { Shirley } & \text { F } & \text { Nigeria } & 5,500 \
\hline 20165 & \text { Giraffe } & \text { Necky } & \text { F } & \text { USA } & 500 \
\hline 23743 & \text { Giraffe } & \text { High Top } & \text { F } & \text { USA } & 600 \
\hline 27579 & \text { Panda } & \text { Fluffy } & \text { M } & \text { China } & 250 \
\hline 32565 & \text { Elephant } & \text { Large Louie } & \text { M } & \text { India } & 7,000 \
\hline 34871 & \text { Grizzly Bear } & \text { Doris } & \text { F } & \text { Canada } & 1,500 \
\hline 35993 & \text { Lion } & \text { King } & \text { M } & \text { USA } & 580 \
\hline 38578 & \text { Tiger } & \text { Stripes } & \text { F } & \text { India } & 470\\hline
\end{array}\end{array}\) Animal file
-Records and fields in the Animal file.
a. Describe the file's record type.
b. Show a record occurrence.
c. Describe the set or range of values that the Animal Number field can take.
d. Describe the set or range of values that the Gender field can take.

Accepted Answer

a. It contains the fields Anim

Question 9

Data redundancy refers to the same fact about the business environment being stored more than once within an information system.

Accepted Answer

A) True 
 B)False

Question 10

Data integrity problems result from the incorrect updating of redundant data.

Accepted Answer

A) True 
 B)False

Question 11

Prior to the development of the database concept ____.

Accepted Answer

A)  data was regularly shared among applications 
B)  data redundancy was not a problem 
C)  changes in the way that data was stored did not affect programs that used the data 
D)  data security was not an issue 
E)  data was not regularly shared among applications 
A)  data was regularly shared among applications 
B)  data redundancy was not a problem 
C)  changes in the way that data was stored did not affect programs that used the data 
D)  data security was not an issue 
E)  data was not regularly shared among applications

Question 12

An entity is _____ in the business environment.

Accepted Answer

A)  a fact about an object 
B)  a record in a file 
C)  an object or event 
D)  an attribute 
E)  a file 
A)  a fact about an object 
B)  a record in a file 
C)  an object or event 
D)  an attribute 
E)  a file

Question 13

A single piece of data is a fact about something of interest to us in our business environment.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is true about data redundancy within one file?

Accepted Answer

A)  The appearance of a particular data value multiple times in one field always indicates data redundancy. 
B)  Data redundancy cannot occur within a single file. 
C)  The problems caused by data redundancy within one file are substantially different from the problems caused by data redundancy across multiple files. 
D)  Data redundancy within one file occurs when different kinds of data (data about different entities) are merged in one file. 
E)  Data redundancy within one file only occurs when a single kind of data (data about a single entity) is present in the file. 
A)  The appearance of a particular data value multiple times in one field always indicates data redundancy. 
B)  Data redundancy cannot occur within a single file. 
C)  The problems caused by data redundancy within one file are substantially different from the problems caused by data redundancy across multiple files. 
D)  Data redundancy within one file occurs when different kinds of data (data about different entities) are merged in one file. 
E)  Data redundancy within one file only occurs when a single kind of data (data about a single entity) is present in the file.

Question 15

Consider the following Airplane and Flight files from Grand Travel Airlines. The unique identifier for flights is the combination of flight number and date. Arrival and departure times are actual, not scheduled, times. The left-hand column of relative record numbers is there to facilitate answering some of the questions.
 $\begin{array}{lr}
&\text { Airplane } \quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad \text { Passenger \quad Year }\
&\text { Number \quad Manufacturer \quad Model\quad Capacity \quad Built }\
\begin{array}{lr}
1\2\3\4\5\
\end{array}&\begin{array}{|l|l|l|r|r|}
\hline 04653 \quad & \text { Boeing }\quad  \quad & 767\quad  & 280\quad  & 1988\quad  \
\hline 10582 & \text { Airbus } & \text { A320 } & 256 & 1997 \
\hline 16420 & \text { Canadair } & \text { CRT } & 54 & 2001 \
\hline 22663 & \text { Boeing } & 767 & 265 & 1999 \
\hline 28352 & \text { Boeing } & 767 & 280 & 1989 \
\hline\end{array}\
\end{array}$ Airplane file
 \(\begin{array}{ll}
&\text { Flight } \quad\quad\quad\quad\quad\quad \text { Departure\quad Arrival\quad\quad\quad Airplane }\
&\text { Number } \quad \text { Date } \quad\quad \text { Time } \quad\quad\quad \text { Time\quad\quad\quad Number }\
\begin{array}{ll}
1\2\3\4\5\6\7\8\9\10\11\12
\end{array}&\begin{array}{|r|r|r|r|r|}
\hline 005 & 11 / 15 / 2003 & 2: 14 \mathrm{PM} & 4: 20 \mathrm{PM} & 22663 \
\hline 018 & 01 / 24 / 2004 & 11: 00 \mathrm{AM} & 1: 32 \mathrm{PM} & 10582 \
\hline 032 & 11 / 15 / 2003 & 9: 03 \mathrm{AM} & 10: 30 \mathrm{AM} & 16420 \
\hline 032 & 11 / 16 / 2003 & 8: 57: \mathrm{AM} & 10: 23 \mathrm{AM} & 16420 \
\hline 032 & 11 / 17 / 2003 & 9: 00 \mathrm{AM} & 10: 33 \mathrm{AM} & 16420 \
\hline 120 & 01 / 24 / 2004 & 7: 52 \mathrm{PM} & 9: 34 \mathrm{PM} & 16420 \
\hline 120 & 01 / 28 / 2004 & 7: 51 \mathrm{PM} & 9: 57 \mathrm{PM} & 16420 \
\hline 154 & 11 / 15 / 2003 & 12: 58 \mathrm{PM} & 3: 30 \mathrm{PM} & 10582 \
\hline 197 & 02 / / 12 / 2004 & 5: 03 \mathrm{PM} & 7: 22 \mathrm{PM} & 22663 \
\hline 197 & 02 / / 13 / 2004 & 5: 00 \mathrm{PM} & 7: 31 \mathrm{PM} & 28352 \
\hline 197 & 02 / / 14 / 2004 & 5: 03 \mathrm{PM} & 8: 45 \mathrm{PM} & 04653 \
\hline 197 & 02 / / 15 / 2004 & 5: 00 \mathrm{PM} & 7: 28 \mathrm{PM} & 22663 \
\hline
\end{array}
\end{array}\)
 Flight file 
a. 16420 appears as an airplane number in record 3 of the Airplane file and in records 3, 4, 5, 6, and 7 of the Flight file. Does this constitute redundant data? Explain.
b. Why does the Airplane Number field appear in both files?
c. What would you have to do to find the name of the manufacturer of the airplane used for flight 197 on 02/13/2004?
d. Merge the two files into one based on which records of one file are related to which records of the other file.
e. How does merging the two files into one affect data integration?
f. How does merging the two files into one affect data redundancy?

Accepted Answer

a. No, because each appearance of airpla

Question 16

The term record occurrence refers to one particular record in a file.

Accepted Answer

A) True 
 B)False

Question 17

A database management system is designed to handle _____ relationships without introducing data redundancy or causing other problems.

Accepted Answer

A)  unary, binary, and ternary 
B)  binary but not unary or ternary 
C)  unary but not binary or ternary 
D)  unary and binary but not ternary 
E)  binary and ternary but not unary 
A)  unary, binary, and ternary 
B)  binary but not unary or ternary 
C)  unary but not binary or ternary 
D)  unary and binary but not ternary 
E)  binary and ternary but not unary

Question 18

Problems caused by two or more users trying to update the same data simultaneously fall primarily under the heading of _____.

Accepted Answer

A)  computer security 
B)  backup and recovery 
C)  concurrency control 
D)  integration control 
E)  access control 
A)  computer security 
B)  backup and recovery 
C)  concurrency control 
D)  integration control 
E)  access control

Question 19

An example of an entity set would be all of the cars for sale at an automobile dealership.

Accepted Answer

A) True 
 B)False

Question 20

Database management systems leave data control issues such as security, backup and recovery, and concurrency control to the application programmer to deal with.

Accepted Answer

A) True 
 B)False

In the Course file, the string "Anatomy" can best be described as a _____.

There are three basic ways of retrieving data: sequential access, interrupted access, and direct access.

Retrieving a subset of the records of a file based on a field value is an example of _____.

An attribute of the records of a file that has unique values can be referred to as the key field.

Which of the following does not change the contents of a file?

The amount of data redundancy has no bearing on the amount of time it takes to update the data.

All of the following are major DBMS approaches, except _____.

Data redundancy refers to the same fact about the business environment being stored more than once within an information system.

Data integrity problems result from the incorrect updating of redundant data.

Prior to the development of the database concept ____.

An entity is _____ in the business environment.

A single piece of data is a fact about something of interest to us in our business environment.

Which of the following is true about data redundancy within one file?

The term record occurrence refers to one particular record in a file.

A database management system is designed to handle _____ relationships without introducing data redundancy or causing other problems.

Problems caused by two or more users trying to update the same data simultaneously fall primarily under the heading of _____.

An example of an entity set would be all of the cars for sale at an automobile dealership.

Database management systems leave data control issues such as security, backup and recovery, and concurrency control to the application programmer to deal with.

Data: the New Corporate Resource

Data Modeling

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters

Exam 3: The Database Management System Concept

In the Course file, the string "Anatomy" can best be described as a _____.

There are three basic ways of retrieving data: sequential access, interrupted access, and direct access.

Retrieving a subset of the records of a file based on a field value is an example of _____.

An attribute of the records of a file that has unique values can be referred to as the key field.

Which of the following does not change the contents of a file?

The amount of data redundancy has no bearing on the amount of time it takes to update the data.

All of the following are major DBMS approaches, except _____.

Data redundancy refers to the same fact about the business environment being stored more than once within an information system.

Data integrity problems result from the incorrect updating of redundant data.

Prior to the development of the database concept ____.

An entity is _____ in the business environment.

A single piece of data is a fact about something of interest to us in our business environment.

Which of the following is true about data redundancy within one file?

The term record occurrence refers to one particular record in a file.

A database management system is designed to handle _____ relationships without introducing data redundancy or causing other problems.

Problems caused by two or more users trying to update the same data simultaneously fall primarily under the heading of _____.

An example of an entity set would be all of the cars for sale at an automobile dealership.

Database management systems leave data control issues such as security, backup and recovery, and concurrency control to the application programmer to deal with.

Data: the New Corporate Resource

Data Modeling

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters