Solutions Manual For Modern Database Management 13th Edition By Jeff Hoffer, Ramesh Venkataraman, Heikki Topi (All Chapters, 100% Original Verified, A+ Grade)

MODERN DATABASE MANAGEMENT, 13E (HOFFER)
l# l# l# l#

CHAPTER 1 THE DATABASE ENVIRONMENT AND
l# l# l# l# l# l# l#

DEVELOPMENT PROCESS
l# l#




1) According l#to l#a l#McKinsey l#Global l#Institute l#Report, l#in l#2010 l#alone, l#global
l#enterprises l#stored l # more l#than:

A) 1 l#terabyte l#of l#data.
B) 3 l#gigabytes l#of l#data.
C) at l#least l#100 l#petabytes l#of l#data.
D) more l#than l#7 l#billion l#exabytes
l#of l#data. l # Answer: l# l# D

LO: l# l#1.1: l#Define l#key
l#terms. l # Difficulty: l# l# Easy


l # Classification: l# l# Concept

AACSB: l# l#Information l#Technology

2) Database l#management l# involves l#all l#of l#the l#following l#EXCEPT:
A) collecting l#data.
B) organizing l#data.
C) design l#web l#pages.
D) managing
l#data. l # Answer:

l# l# C


LO: l# l#1.1: l#Define l#key
l#terms. l # Difficulty: l# l# Easy

l # Classification: l# l# Concept


AACSB: l# l#Information l#Technology

3) A l#database l#is l#an l#organized l#collection l#of related l#data.
A) logically
B) physically
C) loosely
D) badly
l # Answer:

l# l# A

LO: l# l#1.1: l#Define l#key
l#terms. l # Difficulty: l# l# Easy


l # Classification: l# l# Concept

AACSB: l# l#Information l#Technology

4) Legacy l#systems l#often l#contain l#data l#of quality l#and l#are l#generally l#hosted l#on .
A) poor; l#personal l#computers
B) excellent; l#mainframes
C) poor; l#mainframes
D) excellent; l#workgroup
1
Copyright l#© l#2019 l#Pearson l#Education,
l#Inc.

,l#computers l # Answer: l# l#C
LO: l# l#3.1: l#Define l#key
l#terms. l # Difficulty: l#


l# Moderate l # Classification:

l# l# Concept

AACSB: l# l#Information l#Technology




2
Copyright l#© l#2019 l#Pearson l#Education,
l#Inc.

,5) Program-data l#dependence l#is l#caused l#by:
A) file l#descriptions l#being l#stored l#in l#each l#database l#application.
B) data l#descriptions l#being l#stored l#on l#a l#server.
C) data l#descriptions l#being l#written l#into l#programming l#code.
D) data l#cohabiting l#with
l#programs. l # Answer: l# l# A

LO: l# l#1.2: l#Name l#several l#limitations l#of l#conventional l#file l#processing
l#systems. l # Difficulty: l# l# Moderate

Classification: l# l#Concept
AACSB: l# l#Information l#Technology

6) Because l#applications l#are l#often l#developed l#independently l#in l#file l#processing
l#systems:

A) the l#data l#is l#always l#non-redundant.
B) unplanned l#duplicate l#data l#files l#are l#the l#rule l#rather l#than l#the l#exception.
C) data l#can l#always l#be l#shared l#with l#others.
D) there l#is l#a l#large l#volume l#of
l#file l#I/O. l # Answer: l# l#B


LO: l# l#1.2: l#Name l#several l#limitations l#of l#conventional l#file l#processing
l#systems. l # Difficulty: l# l# Moderate

Classification: l# l#Concept
AACSB: l# l#Information l#Technology

7) Relational l#databases l#establish l#the l#relationships l#between l#entities l#by l#means l#of
l#common l#fields l # included l# in l#a l# file l#called l#a(n):

A) entity.
B) relationship.
C) relation.
D) associatio
n. l # Answer:
l# l# C

LO: l# l#1.3: l#Explain l#at l#least l#10 l#advantages l#of l#the l#database l#approach, l#compared
l#to l#traditional l#file l # processing.


Difficulty: l# l#Moderate
l # Classification: l# l# Concept

AACSB: l# l#Information l#Technology

8) A(n) is l#often l#developed l#by l#identifying l#a l#form l#or l#report l# that l#a
l#user l# needs l#on l#a l # regular l# basis.

A) enterprise l#view
B) reporting l#document
C) user l#view
D) user
l# snapshot

l # Answer: l# l# C

LO: l# l#1.3: l#Explain l#at l#least l#10 l#advantages l#of l#the l#database l#approach, l#compared
3
Copyright l#© l#2019 l#Pearson l#Education,
l#Inc.

, l# to l#traditional l#file l # processing.
Difficulty: l# l#Moderate
l # Classification: l# l# Concept


AACSB: l# l#Information l#Technology




4
Copyright l#© l#2019 l#Pearson l#Education,
l#Inc.