ModernbDatabasebManagement,b13thbEdition,bJeffbHoffer,bRamesh
Test Bank for Modern Database Management, 13th Editi
b b b b b b b
on, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, ISB
b b b b b b b
N-10: 0134877004, ISBN-13:
b b
9780134877006. All 14 Chapters
b b b
TestbBank Pageb1
, ModernbDatabasebManagement,b13thbEdition,bJeffbHoffer,bRamesh
Chapter 1 the Database Environment and Development
b b b b b b b
Process
Chapter Overview
b
Thebpurposebofbthisbchapterbisbtobintroducebstudentsbtobthebworldbofbdatabmanagementbasbabwhole,bandbspecif
icallybtobthebdatabasebapproachbtobinformationbsystemsbdevelopment,bthebimportantbconceptsbandbprinciples
ofbthebdatabasebapproach,bandbthebdatabasebdevelopmentbprocessbwithinbthebbroaderbcontextbofbinformation
b
systemsbdevelopment.bThisbisbanbimportantbchapterbbecausebitbconveysbabsensebofbthebcentralbimportancebof
b
databasesbandbdatabmanagementbinbtoday’sbinformationbsystemsbenvironmentbandbinballbmodernbenterprises
b
.bThebideabofbanborganizationalbdatabasebisbintuitivelybappealingbtobmostbstudents.bHowever,bmanybstudentsb
willbhaveblittleborbnobbackgroundborbexperiencebwithbthebtechnicalbimplementationbofbdatabases.bOthersbwill
havebhadbsomebexperiencebwithbdatabasebmanagementbsystemsbintendedbforbpersonalborbworkgroupbuseb(su
b
chbasbMicrosoftbAccess).bConsequently,btheybwillbhavebablimitedbperspectivebconcerningbanborganizationalb
approachbtobdatabases.
Inbthisbchapter,bwebintroducebthebbasicbconceptsbandbdefinitionsbofbdatabasesbandbdatabmanagement,bstarting
withbanborganizingbframeworkbthatbisbnewbtobthisbchapter.bWebcontrastbdatabwithbinformation,bandbintroduc
b
ebthebnotionbofbmetadatabandbitsbimportance.bWebalsobcontrastbthebdatabasebapproachbwithbolderbfilebprocess
ingbsystems,bandbintroducebthebPinebValleybFurniturebCompanybcasebtobillustratebthesebconcepts.bWebdescri
bebthebrangebofbdatabasebapplications,bfrombdatabasesbwithbabpersonalborbworkgroupbscopebtobenterprisebdat
abases,bandbidentifybkeybdecisionsbthatbmustbbebmadebforbeachbtypebofbdatabase.bWebdescribebbothbthebpoten
tialbbenefitsbandbtypicalbcostsbofbusingbthebdatabasebapproach.bWebalsobtracebthebhistoricalbevolutionbofbdata
basebsystems,binborderbtobprovidebabcontextbforbunderstandingbthebdatabasebapproachbforbdatabstoragebandbret
rieval.bThebchapterboutlinesbthebdifferencesbbetweenbtransactionalbandbinformationalbapproachesbandbhighli
ghtsbthebwaybnew,banalytics-focusedbtechnologiesbarebtransformingbdatabmanagement.
Thebchapterbalsobpresentsbanbexpandedbdescriptionbofbthebsystemsbdevelopmentblifebcycleb(includingbanbintr
oductionbtobrapidbapplicationbdevelopmentbmethodsbofbprototypingbandbagilebsoftwarebdevelopment)bandb th
ebroleb ofb databaseb developmentb withinbit.bTheb chapterb providesb anb updatedbdescriptionbofb theb well-
TestbBank Pageb2
, ModernbDatabasebManagement,b13thbEdition,bJeffbHoffer,bRamesh
knownbthree-
schemabarchitecturebandbusesbitbtobsummarizebthebvariousbdeliverablesbofbdatabasebdevelopment.bItbconclud
esbwithbanbexamplebofbdatabasebdevelopmentbsituatedbinbthebcontextbthebPinebValleybFurniturebCompanybca
se.
Chapter Objectives
b
Specificbstudentblearningbobjectivesbarebincludedbatbthebbeginningbofbeachbchapter.bFrombanbinstructor’sbpoi
ntbofbview,bthebobjectivesbofbthisbchapterbarebto:
1. Createbabsensebofbexcitementbconcerningbthebdatabandbdatabasebmanagementbfieldbandbthebty
pesbofbjobbopportunitiesbthatbarebavailable.
2. Acquaintbstudentsbwithbthebbroadbspectrumbofbdatabasebapplicationsbandbhowborganizations
arebusingbdatabasebapplicationsbforbcompetitivebadvantage.
b
3. Introducebthebdatabmanagementbframeworkbthatborganizesbthebbookbandbthebconceptualbspa
cebofbdatabmanagement,bhighlightingbhowbrelationalbtechnologiesbandbnon-
relationalbtechnologiesbcanbbebseenbasbpartbofbthebsamebspace.
4. Introducebthebkeybtermsbandbdefinitionsbthatbdescribebthebdatabasebenvironment.
5. Describebdatabmodelsbandbhowbtheybarebusedbtobcapturebthebnaturebandbrelationshipsbamongb
data.
6. Describebthebmajorbcomponentsbofbthebdatabasebenvironmentbandbhowbthesebcomponentsbin
teractbwithbeachbother.
7. Providebabreviewbofbsystemsbdevelopmentbmethodologies,bparticularlybthebsystemsbdevelop
mentblifebcycle,bprototyping,bandbagilebsoftwarebdevelopment;bbuildbanbunderstandingbofbho
wbdatabasebdevelopmentbisbalignedbwithbthesebmethodologies.
8. Developbanbunderstandingbofbthebdifferentbrolesbwithinbinbabdatabasebdevelopmentbteam.
9. Makebstudentsbawarebofbthebthree-
schemabarchitecturebandbitsbbenefitsbforbdatabasebdevelopmentbandbdesign.
10. IntroducebthebPinebValleybFurniturebCompanybcase,bwhichbisbusedbthroughoutbthebtextbtobill
ustratebimportantbconcepts.
11. IntroducebthebMountainbViewbCommunitybHospitalbcase,bwhichbisbincludedbatbthebendbofbea
chbchapterbasbabsourcebforbstudentbprojects.
TestbBank Pageb3
, ModernbDatabasebManagement,b13thbEdition,bJeffbHoffer,bRamesh
Key Terms
b
Agilebsoftwarebdevelopment Database Metadata
Conceptualbschema Databasebapplication Physicalbschema
Constraint Databasebmanagementbsystemb(DB Project
MS)
Data Enterprisebdatabmodeling Prototyping
Databindependence Enterprisebresourcebplanningb(ERP) Relationalbdatabase
Databmodel Entity Repository
Databmodelingbandbdesignbtools Information Systemsb developmentb lifeb cycleb (S
DLC)
Databwarehouse Logicalbschema Userbview
Classroom Ideas b
1. Startbwithbabdiscussionbofbhowbstudentsbinteractbwithbsystemsbbuiltbonbdatabasesbonbabdailybb
asisb(creditbcardbtransactions,bshoppingbcards,btelephonebcalls,bcellbphonebcontactblists,bdow
nloadablebmusic,betc.).bIfbyoubteachbinbabclassroombwithbcomputers,baskbstudentsbtobfindbexa
mplesbofbWebbsitesbthatbappearbtobbebaccessingbdatabases.
2. Contrastbthebtermsb―data‖bandb―information.‖bUsingbFigureb1-
1basbabstartingbpoint,bhavebthebstudentsbprovidebsomebgoodbexamplesbofbdatabandbinformatio
nbfrombtheirbownbexperiences.bThisbmaybwellbleadbtobsomebdifferencesbofbopinion,bandbthebc
onclusionbthatbonebperson’sbdatabmaybbebanotherbperson’sbinformation.
3. IntroducebthebconceptbofbmetadatabusingbTableb1-
1.bAskbthebstudentsbtobsuggestbotherbmetadatabthatbmightbbebappropriatebforbthisbexample.
4. Discussbfilebprocessingbsystemsbandbtheirblimitations,busingbFigureb1-2bandbTableb1-
2.bEmphasizebthatbmanybofbthesebsystemsbarebstillbinbusebtoday.
5. IntroducebdatabmodelsbusingbFigureb1-
3.bDiscussbthebdifferencesbbetweenbanbenterprisebdatabmodelbandbabprojectbdatabmodel,busin
gbFiguresb1-3b(a)bandb(b).
6. Discussbeachbofbthebadvantagesbofbthebdatabasebapproachb(Tableb1-
TestbBank Pageb4
Test Bank for Modern Database Management, 13th Editi
b b b b b b b
on, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, ISB
b b b b b b b
N-10: 0134877004, ISBN-13:
b b
9780134877006. All 14 Chapters
b b b
TestbBank Pageb1
, ModernbDatabasebManagement,b13thbEdition,bJeffbHoffer,bRamesh
Chapter 1 the Database Environment and Development
b b b b b b b
Process
Chapter Overview
b
Thebpurposebofbthisbchapterbisbtobintroducebstudentsbtobthebworldbofbdatabmanagementbasbabwhole,bandbspecif
icallybtobthebdatabasebapproachbtobinformationbsystemsbdevelopment,bthebimportantbconceptsbandbprinciples
ofbthebdatabasebapproach,bandbthebdatabasebdevelopmentbprocessbwithinbthebbroaderbcontextbofbinformation
b
systemsbdevelopment.bThisbisbanbimportantbchapterbbecausebitbconveysbabsensebofbthebcentralbimportancebof
b
databasesbandbdatabmanagementbinbtoday’sbinformationbsystemsbenvironmentbandbinballbmodernbenterprises
b
.bThebideabofbanborganizationalbdatabasebisbintuitivelybappealingbtobmostbstudents.bHowever,bmanybstudentsb
willbhaveblittleborbnobbackgroundborbexperiencebwithbthebtechnicalbimplementationbofbdatabases.bOthersbwill
havebhadbsomebexperiencebwithbdatabasebmanagementbsystemsbintendedbforbpersonalborbworkgroupbuseb(su
b
chbasbMicrosoftbAccess).bConsequently,btheybwillbhavebablimitedbperspectivebconcerningbanborganizationalb
approachbtobdatabases.
Inbthisbchapter,bwebintroducebthebbasicbconceptsbandbdefinitionsbofbdatabasesbandbdatabmanagement,bstarting
withbanborganizingbframeworkbthatbisbnewbtobthisbchapter.bWebcontrastbdatabwithbinformation,bandbintroduc
b
ebthebnotionbofbmetadatabandbitsbimportance.bWebalsobcontrastbthebdatabasebapproachbwithbolderbfilebprocess
ingbsystems,bandbintroducebthebPinebValleybFurniturebCompanybcasebtobillustratebthesebconcepts.bWebdescri
bebthebrangebofbdatabasebapplications,bfrombdatabasesbwithbabpersonalborbworkgroupbscopebtobenterprisebdat
abases,bandbidentifybkeybdecisionsbthatbmustbbebmadebforbeachbtypebofbdatabase.bWebdescribebbothbthebpoten
tialbbenefitsbandbtypicalbcostsbofbusingbthebdatabasebapproach.bWebalsobtracebthebhistoricalbevolutionbofbdata
basebsystems,binborderbtobprovidebabcontextbforbunderstandingbthebdatabasebapproachbforbdatabstoragebandbret
rieval.bThebchapterboutlinesbthebdifferencesbbetweenbtransactionalbandbinformationalbapproachesbandbhighli
ghtsbthebwaybnew,banalytics-focusedbtechnologiesbarebtransformingbdatabmanagement.
Thebchapterbalsobpresentsbanbexpandedbdescriptionbofbthebsystemsbdevelopmentblifebcycleb(includingbanbintr
oductionbtobrapidbapplicationbdevelopmentbmethodsbofbprototypingbandbagilebsoftwarebdevelopment)bandb th
ebroleb ofb databaseb developmentb withinbit.bTheb chapterb providesb anb updatedbdescriptionbofb theb well-
TestbBank Pageb2
, ModernbDatabasebManagement,b13thbEdition,bJeffbHoffer,bRamesh
knownbthree-
schemabarchitecturebandbusesbitbtobsummarizebthebvariousbdeliverablesbofbdatabasebdevelopment.bItbconclud
esbwithbanbexamplebofbdatabasebdevelopmentbsituatedbinbthebcontextbthebPinebValleybFurniturebCompanybca
se.
Chapter Objectives
b
Specificbstudentblearningbobjectivesbarebincludedbatbthebbeginningbofbeachbchapter.bFrombanbinstructor’sbpoi
ntbofbview,bthebobjectivesbofbthisbchapterbarebto:
1. Createbabsensebofbexcitementbconcerningbthebdatabandbdatabasebmanagementbfieldbandbthebty
pesbofbjobbopportunitiesbthatbarebavailable.
2. Acquaintbstudentsbwithbthebbroadbspectrumbofbdatabasebapplicationsbandbhowborganizations
arebusingbdatabasebapplicationsbforbcompetitivebadvantage.
b
3. Introducebthebdatabmanagementbframeworkbthatborganizesbthebbookbandbthebconceptualbspa
cebofbdatabmanagement,bhighlightingbhowbrelationalbtechnologiesbandbnon-
relationalbtechnologiesbcanbbebseenbasbpartbofbthebsamebspace.
4. Introducebthebkeybtermsbandbdefinitionsbthatbdescribebthebdatabasebenvironment.
5. Describebdatabmodelsbandbhowbtheybarebusedbtobcapturebthebnaturebandbrelationshipsbamongb
data.
6. Describebthebmajorbcomponentsbofbthebdatabasebenvironmentbandbhowbthesebcomponentsbin
teractbwithbeachbother.
7. Providebabreviewbofbsystemsbdevelopmentbmethodologies,bparticularlybthebsystemsbdevelop
mentblifebcycle,bprototyping,bandbagilebsoftwarebdevelopment;bbuildbanbunderstandingbofbho
wbdatabasebdevelopmentbisbalignedbwithbthesebmethodologies.
8. Developbanbunderstandingbofbthebdifferentbrolesbwithinbinbabdatabasebdevelopmentbteam.
9. Makebstudentsbawarebofbthebthree-
schemabarchitecturebandbitsbbenefitsbforbdatabasebdevelopmentbandbdesign.
10. IntroducebthebPinebValleybFurniturebCompanybcase,bwhichbisbusedbthroughoutbthebtextbtobill
ustratebimportantbconcepts.
11. IntroducebthebMountainbViewbCommunitybHospitalbcase,bwhichbisbincludedbatbthebendbofbea
chbchapterbasbabsourcebforbstudentbprojects.
TestbBank Pageb3
, ModernbDatabasebManagement,b13thbEdition,bJeffbHoffer,bRamesh
Key Terms
b
Agilebsoftwarebdevelopment Database Metadata
Conceptualbschema Databasebapplication Physicalbschema
Constraint Databasebmanagementbsystemb(DB Project
MS)
Data Enterprisebdatabmodeling Prototyping
Databindependence Enterprisebresourcebplanningb(ERP) Relationalbdatabase
Databmodel Entity Repository
Databmodelingbandbdesignbtools Information Systemsb developmentb lifeb cycleb (S
DLC)
Databwarehouse Logicalbschema Userbview
Classroom Ideas b
1. Startbwithbabdiscussionbofbhowbstudentsbinteractbwithbsystemsbbuiltbonbdatabasesbonbabdailybb
asisb(creditbcardbtransactions,bshoppingbcards,btelephonebcalls,bcellbphonebcontactblists,bdow
nloadablebmusic,betc.).bIfbyoubteachbinbabclassroombwithbcomputers,baskbstudentsbtobfindbexa
mplesbofbWebbsitesbthatbappearbtobbebaccessingbdatabases.
2. Contrastbthebtermsb―data‖bandb―information.‖bUsingbFigureb1-
1basbabstartingbpoint,bhavebthebstudentsbprovidebsomebgoodbexamplesbofbdatabandbinformatio
nbfrombtheirbownbexperiences.bThisbmaybwellbleadbtobsomebdifferencesbofbopinion,bandbthebc
onclusionbthatbonebperson’sbdatabmaybbebanotherbperson’sbinformation.
3. IntroducebthebconceptbofbmetadatabusingbTableb1-
1.bAskbthebstudentsbtobsuggestbotherbmetadatabthatbmightbbebappropriatebforbthisbexample.
4. Discussbfilebprocessingbsystemsbandbtheirblimitations,busingbFigureb1-2bandbTableb1-
2.bEmphasizebthatbmanybofbthesebsystemsbarebstillbinbusebtoday.
5. IntroducebdatabmodelsbusingbFigureb1-
3.bDiscussbthebdifferencesbbetweenbanbenterprisebdatabmodelbandbabprojectbdatabmodel,busin
gbFiguresb1-3b(a)bandb(b).
6. Discussbeachbofbthebadvantagesbofbthebdatabasebapproachb(Tableb1-
TestbBank Pageb4
