ModernkDatabasekManagement,k13thkEdition,kJeffkHoffer,kRamesh
Test Bank for Modern Database Management, 13th Editi
k k k k k k k
on, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, ISB
k k k k k k k
N-10: 0134877004, ISBN-13:
k k
9780134877006. All 14 Chapters
k k k
TestkBank Pagek1
, ModernkDatabasekManagement,k13thkEdition,kJeffkHoffer,kRamesh
Chapter 1 the Database Environment and Development
k k k k k k k
Process
Chapter Overview
k
Thekpurposekofkthiskchapterkisktokintroducekstudentsktokthekworldkofkdatakmanagementkaskakwhole,kandkspecif
icallyktokthekdatabasekapproachktokinformationksystemskdevelopment,kthekimportantkconceptskandkprinciples
k ofkthekdatabasekapproach,kandkthekdatabasekdevelopmentkprocesskwithinkthekbroaderkcontextkofkinformation
k systemskdevelopment.kThiskiskankimportantkchapterkbecausekitkconveyskaksensekofkthekcentralkimportancekof
k databaseskandkdatakmanagementkinktoday’skinformationksystemskenvironmentkandkinkallkmodernkenterprises
.kThekideakofkankorganizationalkdatabasekiskintuitivelykappealingktokmostkstudents.kHowever,kmanykstudentsk
willkhaveklittlekorknokbackgroundkorkexperiencekwithkthektechnicalkimplementationkofkdatabases.kOtherskwill
k havekhadksomekexperiencekwithkdatabasekmanagementksystemskintendedkforkpersonalkorkworkgroupkusek(su
chkaskMicrosoftkAccess).kConsequently,ktheykwillkhavekaklimitedkperspectivekconcerningkankorganizationalk
approachktokdatabases.
Inkthiskchapter,kwekintroducekthekbasickconceptskandkdefinitionskofkdatabaseskandkdatakmanagement,kstarting
k withkankorganizingkframeworkkthatkisknewktokthiskchapter.kWekcontrastkdatakwithkinformation,kandkintroduc
ektheknotionkofkmetadatakandkitskimportance.kWekalsokcontrastkthekdatabasekapproachkwithkolderkfilekprocess
ingksystems,kandkintroducekthekPinekValleykFurniturekCompanykcasektokillustratekthesekconcepts.kWekdescri
bekthekrangekofkdatabasekapplications,kfromkdatabaseskwithkakpersonalkorkworkgroupkscopektokenterprisekdat
abases,kandkidentifykkeykdecisionskthatkmustkbekmadekforkeachktypekofkdatabase.kWekdescribekbothkthekpoten
tialkbenefitskandktypicalkcostskofkusingkthekdatabasekapproach.kWekalsoktracekthekhistoricalkevolutionkofkdata
baseksystems,kinkorderktokprovidekakcontextkforkunderstandingkthekdatabasekapproachkforkdatakstoragekandkret
rieval.kThekchapterkoutlineskthekdifferenceskbetweenktransactionalkandkinformationalkapproacheskandkhighli
ghtskthekwayknew,kanalytics-focusedktechnologieskarektransformingkdatakmanagement.
Thekchapterkalsokpresentskankexpandedkdescriptionkofktheksystemskdevelopmentklifekcyclek(includingkankintr
oductionktokrapidkapplicationkdevelopmentkmethodskofkprototypingkandkagileksoftwarekdevelopment)kandk th
ek rolek ofk databasek developmentk withinkit.kThek chapterk providesk ank updatedkdescriptionk ofk thek well-
TestkBank Pagek2
, ModernkDatabasekManagement,k13thkEdition,kJeffkHoffer,kRamesh
knownkthree-
schemakarchitecturekandkuseskitktoksummarizekthekvariouskdeliverableskofkdatabasekdevelopment.kItkconclud
eskwithkankexamplekofkdatabasekdevelopmentksituatedkinkthekcontextkthekPinekValleykFurniturekCompanykca
se.
Chapter Objectives
k
Specifickstudentklearningkobjectiveskarekincludedkatkthekbeginningkofkeachkchapter.kFromkankinstructor’skpoi
ntkofkview,kthekobjectiveskofkthiskchapterkarekto:
1. Createkaksensekofkexcitementkconcerningkthekdatakandkdatabasekmanagementkfieldkandkthekty
peskofkjobkopportunitieskthatkarekavailable.
2. Acquaintkstudentskwithkthekbroadkspectrumkofkdatabasekapplicationskandkhowkorganizations
k arekusingkdatabasekapplicationskforkcompetitivekadvantage.
3. Introducekthekdatakmanagementkframeworkkthatkorganizeskthekbookkandkthekconceptualkspa
cekofkdatakmanagement,khighlightingkhowkrelationalktechnologieskandknon-
relationalktechnologieskcankbekseenkaskpartkofktheksamekspace.
4. Introducekthekkeyktermskandkdefinitionskthatkdescribekthekdatabasekenvironment.
5. Describekdatakmodelskandkhowktheykarekusedktokcapturektheknaturekandkrelationshipskamongk
data.
6. Describekthekmajorkcomponentskofkthekdatabasekenvironmentkandkhowkthesekcomponentskin
teractkwithkeachkother.
7. Providekakreviewkofksystemskdevelopmentkmethodologies,kparticularlyktheksystemskdevelop
mentklifekcycle,kprototyping,kandkagileksoftwarekdevelopment;kbuildkankunderstandingkofkho
wkdatabasekdevelopmentkiskalignedkwithkthesekmethodologies.
8. Developkankunderstandingkofkthekdifferentkroleskwithinkinkakdatabasekdevelopmentkteam.
9. Makekstudentskawarekofkthekthree-
schemakarchitecturekandkitskbenefitskforkdatabasekdevelopmentkandkdesign.
10. IntroducekthekPinekValleykFurniturekCompanykcase,kwhichkiskusedkthroughoutkthektextktokill
ustratekimportantkconcepts.
11. IntroducekthekMountainkViewkCommunitykHospitalkcase,kwhichkiskincludedkatkthekendkofkea
chkchapterkaskaksourcekforkstudentkprojects.
TestkBank Pagek3
, ModernkDatabasekManagement,k13thkEdition,kJeffkHoffer,kRamesh
Key Terms
k
Agileksoftwarekdevelopment Database Metadata
Conceptualkschema Databasekapplication Physicalkschema
Constraint Databasekmanagementksystemk(DB Project
MS)
Data Enterprisekdatakmodeling Prototyping
Datakindependence Enterprisekresourcekplanningk(ERP) Relationalkdatabase
Datakmodel Entity Repository
Datakmodelingkandkdesignktools Information Systemsk developmentk lifek cyclek (S
DLC)
Datakwarehouse Logicalkschema Userkview
Classroom Ideas k
1. Startkwithkakdiscussionkofkhowkstudentskinteractkwithksystemskbuiltkonkdatabaseskonkakdailykb
asisk(creditkcardktransactions,kshoppingkcards,ktelephonekcalls,kcellkphonekcontactklists,kdow
nloadablekmusic,ketc.).kIfkyoukteachkinkakclassroomkwithkcomputers,kaskkstudentsktokfindkexa
mpleskofkWebksiteskthatkappearktokbekaccessingkdatabases.
2. Contrastkthektermsk―data‖kandk―information.‖kUsingkFigurek1-
1kaskakstartingkpoint,khavekthekstudentskprovideksomekgoodkexampleskofkdatakandkinformatio
nkfromktheirkownkexperiences.kThiskmaykwellkleadktoksomekdifferenceskofkopinion,kandkthekc
onclusionkthatkonekperson’skdatakmaykbekanotherkperson’skinformation.
3. IntroducekthekconceptkofkmetadatakusingkTablek1-
1.kAskkthekstudentsktoksuggestkotherkmetadatakthatkmightkbekappropriatekforkthiskexample.
4. Discusskfilekprocessingksystemskandktheirklimitations,kusingkFigurek1-2kandkTablek1-
2.kEmphasizekthatkmanykofktheseksystemskarekstillkinkusektoday.
5. IntroducekdatakmodelskusingkFigurek1-
3.kDiscusskthekdifferenceskbetweenkankenterprisekdatakmodelkandkakprojectkdatakmodel,kusin
gkFiguresk1-3k(a)kandk(b).
6. Discusskeachkofkthekadvantageskofkthekdatabasekapproachk(Tablek1-
TestkBank Pagek4
Test Bank for Modern Database Management, 13th Editi
k k k k k k k
on, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, ISB
k k k k k k k
N-10: 0134877004, ISBN-13:
k k
9780134877006. All 14 Chapters
k k k
TestkBank Pagek1
, ModernkDatabasekManagement,k13thkEdition,kJeffkHoffer,kRamesh
Chapter 1 the Database Environment and Development
k k k k k k k
Process
Chapter Overview
k
Thekpurposekofkthiskchapterkisktokintroducekstudentsktokthekworldkofkdatakmanagementkaskakwhole,kandkspecif
icallyktokthekdatabasekapproachktokinformationksystemskdevelopment,kthekimportantkconceptskandkprinciples
k ofkthekdatabasekapproach,kandkthekdatabasekdevelopmentkprocesskwithinkthekbroaderkcontextkofkinformation
k systemskdevelopment.kThiskiskankimportantkchapterkbecausekitkconveyskaksensekofkthekcentralkimportancekof
k databaseskandkdatakmanagementkinktoday’skinformationksystemskenvironmentkandkinkallkmodernkenterprises
.kThekideakofkankorganizationalkdatabasekiskintuitivelykappealingktokmostkstudents.kHowever,kmanykstudentsk
willkhaveklittlekorknokbackgroundkorkexperiencekwithkthektechnicalkimplementationkofkdatabases.kOtherskwill
k havekhadksomekexperiencekwithkdatabasekmanagementksystemskintendedkforkpersonalkorkworkgroupkusek(su
chkaskMicrosoftkAccess).kConsequently,ktheykwillkhavekaklimitedkperspectivekconcerningkankorganizationalk
approachktokdatabases.
Inkthiskchapter,kwekintroducekthekbasickconceptskandkdefinitionskofkdatabaseskandkdatakmanagement,kstarting
k withkankorganizingkframeworkkthatkisknewktokthiskchapter.kWekcontrastkdatakwithkinformation,kandkintroduc
ektheknotionkofkmetadatakandkitskimportance.kWekalsokcontrastkthekdatabasekapproachkwithkolderkfilekprocess
ingksystems,kandkintroducekthekPinekValleykFurniturekCompanykcasektokillustratekthesekconcepts.kWekdescri
bekthekrangekofkdatabasekapplications,kfromkdatabaseskwithkakpersonalkorkworkgroupkscopektokenterprisekdat
abases,kandkidentifykkeykdecisionskthatkmustkbekmadekforkeachktypekofkdatabase.kWekdescribekbothkthekpoten
tialkbenefitskandktypicalkcostskofkusingkthekdatabasekapproach.kWekalsoktracekthekhistoricalkevolutionkofkdata
baseksystems,kinkorderktokprovidekakcontextkforkunderstandingkthekdatabasekapproachkforkdatakstoragekandkret
rieval.kThekchapterkoutlineskthekdifferenceskbetweenktransactionalkandkinformationalkapproacheskandkhighli
ghtskthekwayknew,kanalytics-focusedktechnologieskarektransformingkdatakmanagement.
Thekchapterkalsokpresentskankexpandedkdescriptionkofktheksystemskdevelopmentklifekcyclek(includingkankintr
oductionktokrapidkapplicationkdevelopmentkmethodskofkprototypingkandkagileksoftwarekdevelopment)kandk th
ek rolek ofk databasek developmentk withinkit.kThek chapterk providesk ank updatedkdescriptionk ofk thek well-
TestkBank Pagek2
, ModernkDatabasekManagement,k13thkEdition,kJeffkHoffer,kRamesh
knownkthree-
schemakarchitecturekandkuseskitktoksummarizekthekvariouskdeliverableskofkdatabasekdevelopment.kItkconclud
eskwithkankexamplekofkdatabasekdevelopmentksituatedkinkthekcontextkthekPinekValleykFurniturekCompanykca
se.
Chapter Objectives
k
Specifickstudentklearningkobjectiveskarekincludedkatkthekbeginningkofkeachkchapter.kFromkankinstructor’skpoi
ntkofkview,kthekobjectiveskofkthiskchapterkarekto:
1. Createkaksensekofkexcitementkconcerningkthekdatakandkdatabasekmanagementkfieldkandkthekty
peskofkjobkopportunitieskthatkarekavailable.
2. Acquaintkstudentskwithkthekbroadkspectrumkofkdatabasekapplicationskandkhowkorganizations
k arekusingkdatabasekapplicationskforkcompetitivekadvantage.
3. Introducekthekdatakmanagementkframeworkkthatkorganizeskthekbookkandkthekconceptualkspa
cekofkdatakmanagement,khighlightingkhowkrelationalktechnologieskandknon-
relationalktechnologieskcankbekseenkaskpartkofktheksamekspace.
4. Introducekthekkeyktermskandkdefinitionskthatkdescribekthekdatabasekenvironment.
5. Describekdatakmodelskandkhowktheykarekusedktokcapturektheknaturekandkrelationshipskamongk
data.
6. Describekthekmajorkcomponentskofkthekdatabasekenvironmentkandkhowkthesekcomponentskin
teractkwithkeachkother.
7. Providekakreviewkofksystemskdevelopmentkmethodologies,kparticularlyktheksystemskdevelop
mentklifekcycle,kprototyping,kandkagileksoftwarekdevelopment;kbuildkankunderstandingkofkho
wkdatabasekdevelopmentkiskalignedkwithkthesekmethodologies.
8. Developkankunderstandingkofkthekdifferentkroleskwithinkinkakdatabasekdevelopmentkteam.
9. Makekstudentskawarekofkthekthree-
schemakarchitecturekandkitskbenefitskforkdatabasekdevelopmentkandkdesign.
10. IntroducekthekPinekValleykFurniturekCompanykcase,kwhichkiskusedkthroughoutkthektextktokill
ustratekimportantkconcepts.
11. IntroducekthekMountainkViewkCommunitykHospitalkcase,kwhichkiskincludedkatkthekendkofkea
chkchapterkaskaksourcekforkstudentkprojects.
TestkBank Pagek3
, ModernkDatabasekManagement,k13thkEdition,kJeffkHoffer,kRamesh
Key Terms
k
Agileksoftwarekdevelopment Database Metadata
Conceptualkschema Databasekapplication Physicalkschema
Constraint Databasekmanagementksystemk(DB Project
MS)
Data Enterprisekdatakmodeling Prototyping
Datakindependence Enterprisekresourcekplanningk(ERP) Relationalkdatabase
Datakmodel Entity Repository
Datakmodelingkandkdesignktools Information Systemsk developmentk lifek cyclek (S
DLC)
Datakwarehouse Logicalkschema Userkview
Classroom Ideas k
1. Startkwithkakdiscussionkofkhowkstudentskinteractkwithksystemskbuiltkonkdatabaseskonkakdailykb
asisk(creditkcardktransactions,kshoppingkcards,ktelephonekcalls,kcellkphonekcontactklists,kdow
nloadablekmusic,ketc.).kIfkyoukteachkinkakclassroomkwithkcomputers,kaskkstudentsktokfindkexa
mpleskofkWebksiteskthatkappearktokbekaccessingkdatabases.
2. Contrastkthektermsk―data‖kandk―information.‖kUsingkFigurek1-
1kaskakstartingkpoint,khavekthekstudentskprovideksomekgoodkexampleskofkdatakandkinformatio
nkfromktheirkownkexperiences.kThiskmaykwellkleadktoksomekdifferenceskofkopinion,kandkthekc
onclusionkthatkonekperson’skdatakmaykbekanotherkperson’skinformation.
3. IntroducekthekconceptkofkmetadatakusingkTablek1-
1.kAskkthekstudentsktoksuggestkotherkmetadatakthatkmightkbekappropriatekforkthiskexample.
4. Discusskfilekprocessingksystemskandktheirklimitations,kusingkFigurek1-2kandkTablek1-
2.kEmphasizekthatkmanykofktheseksystemskarekstillkinkusektoday.
5. IntroducekdatakmodelskusingkFigurek1-
3.kDiscusskthekdifferenceskbetweenkankenterprisekdatakmodelkandkakprojectkdatakmodel,kusin
gkFiguresk1-3k(a)kandk(b).
6. Discusskeachkofkthekadvantageskofkthekdatabasekapproachk(Tablek1-
TestkBank Pagek4
