ModernmDatabasemManagement,m13thmEdition,mJeff mHoffer,mRames
h
Test Bank for Modern Database Management, 13th Edi
m m m m m m m
tion, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, I
m m m m m m m
SBN-10: 0134877004, ISBN-13:
m m
9780134877006. All 14 Chapters
m m m
TestmBank Pagem
1
, ModernmDatabasemManagement,m13thmEdition,mJeff mHoffer,mRames
h
Chapter 1 the Database Environment and Development
m m m m m m
m Process
Chapter Overview
m
Thempurposemof mthismchaptermismto mintroducemstudentsmto mthemworld mof mdatammanagementmasmamwhole,mand m
specifically mto mthemdatabasemapproach mto minformation msystemsmdevelopment, mthemimportantmconceptsmand m
principlesmof mthemdatabasemapproach,mand mthemdatabasemdevelopmentmprocessmwithin mthembroadermcontextm
of minformation msystemsmdevelopment.mThismisman mimportantmchaptermbecause mitmconveysmamsensemof mthemce
ntralmimportancemof mdatabasesmand mdatammanagementmin mtoday’sminformation msystemsmenvironmentmand mi
n mallmmodern menterprises.mThemideamof man morganizationalmdatabase mismintuitively mappealingmto mmostmstude
nts.mHowever,mmany mstudentsmwillmhavemlittlemormno mbackground mormexperience mwith mthemtechnicalmimple
mentation mof mdatabases.mOthersmwillmhavemhad msomemexperiencemwith mdatabase mmanagementmsystemsminte
nded mformpersonalmormworkgroup musem(such masmMicrosoftmAccess).mConsequently,mthey mwillmhavemamlimite
d mperspective mconcerningman morganizationalmapproach mto mdatabases.
In mthismchapter,mwemintroducemthembasicmconceptsmand mdefinitionsmof mdatabasesmand mdatammanagement,msta
rtingmwith man morganizingmframework mthatmismnewmto mthismchapter.mWemcontrastmdatamwith minformation,man
d mintroducemthemnotion mof mmetadatamand mitsmimportance.mWemalso mcontrastmthemdatabasemapproach mwith mol
dermfilemprocessingmsystems,mand mintroducemthemPinemValley mFurniture mCompany mcasemto millustratemthesem
concepts.mWemdescribe mthemrangemof mdatabasemapplications,mfrommdatabasesmwith mampersonalmormworkgrou
p mscopemto menterprise mdatabases,mand midentify mkey mdecisionsmthatmmustmbemmademformeach mtypemof mdatabas
e.mWemdescribe mboth mthempotentialmbenefitsmand mtypicalmcostsmof musingmthemdatabase mapproach.mWemalso mtr
acemthemhistoricalmevolution mof mdatabase msystems,min mordermto mprovide mamcontextmformunderstandingmthemda
tabasemapproach mformdatamstoragemand mretrieval.mThemchaptermoutlinesmthemdifferencesmbetween mtransaction
almand minformationalmapproachesmand mhighlightsmthemway mnew,manalytics-
focused mtechnologiesmaremtransformingmdatammanagement.
Themchaptermalso mpresentsman mexpanded mdescription mof mthemsystemsmdevelopmentmlifemcyclem(includingman
mintroduction mto mrapid mapplication mdevelopmentmmethodsmof mprototypingmand magilemsoftwaremdevelopment
)mand m themrolem ofm databasem developmentm withinm it.mThem chapterm providesman m updated mdescriptionm ofm them
well-
TestmBank Pagem
2
, ModernmDatabasemManagement,m13thmEdition,mJeff mHoffer,mRames
h
known mthree-
schemamarchitecture mand musesmitmto msummarize mthemvariousmdeliverablesmof mdatabase mdevelopment.mItmcon
cludesmwith man mexamplemof mdatabasemdevelopmentmsituated min mthemcontextmthemPinemValley mFurniture mCo
mpany mcase.
Chapter Objectives
m
Specificmstudentmlearningmobjectivesmaremincluded matmthembeginningmof meach mchapter.mFromman minstructor’
smpointmofmview,mthemobjectivesmofmthismchaptermaremto:
1. Createmamsensemof mexcitement mconcerningmthemdatamand mdatabasemmanagement mfield mand mt
hemtypesmof mjobmopportunitiesmthat maremavailable.
2. Acquaint mstudentsmwithmthembroad mspectrummof mdatabasemapplicationsmand mhow morganizati
onsmaremusingmdatabasemapplicationsmformcompetitivemadvantage.
3. Introducemthemdatammanagement mframeworkmthat morganizesmthembookmand mthemconceptualm
spacemof mdatammanagement,mhighlighting mhowmrelationalmtechnologiesmand mnon-
relationalmtechnologiesmcanmbemseenmasmpart mof mthemsamemspace.
4. Introducemthemkeymtermsmand mdefinitionsmthat mdescribemthemdatabasemenvironment.
5. Describemdatammodelsmand mhowmtheymaremused mtomcapturemthemnaturemand mrelationships mam
ongmdata.
6. Describemthemmajormcomponentsmof mthemdatabasemenvironment mand mhow mthesemcomponent
sminteract mwithmeachmother.
7. Providemamreview mof msystemsmdevelopment mmethodologies,mparticularlymthemsystemsmdevel
opment mlifemcycle, mprototyping,mand magilemsoftwaremdevelopment;mbuild manmunderstanding
mof mhow mdatabasemdevelopment mismaligned mwithmthesemmethodologies.
8. Develop man munderstandingmof mthemdifferentmrolesmwithin min mamdatabase mdevelopmentmteam.
9. Makemstudentsmawaremof mthemthree-
schema marchitecture mand mitsmbenefitsmformdatabase mdevelopmentmand mdesign.
10. IntroducemthemPinemValleymFurnituremCompanymcase,mwhichmismused mthroughout mthemtext mt
omillustratemimportant mconcepts.
11. IntroducemthemMountainmView mCommunitymHospitalmcase,mwhichmismincluded mat mthemend mo
f meachmchaptermasmamsourcemformstudent mprojects.
TestmBank Pagem
3
, ModernmDatabasemManagement,m13thmEdition,mJeff mHoffer,mRames
h
Key Terms
m
Agilemsoftwaremdevelopment Database Metadata
Conceptualmschema Databasemapplication Physicalmschema
Constraint Databasemmanagement msystem m(DB Project
MS)
Data Enterprisemdata mmodeling Prototyping
Data mindependence Enterprisemresourcemplanningm(ERP) Relationalmdatabase
Data mmodel Entity Repository
Data mmodelingmand mdesign mtools Information Systemsm development m lifem cyclem (S
DLC)
Data mwarehouse Logicalmschema Usermview
Classroom Ideasm
1. Start mwithmamdiscussionmof mhowmstudentsminteract mwithmsystemsmbuilt monmdatabasesmonmamda
ilymbasism (credit mcard mtransactions,mshopping mcards,mtelephonemcalls,m cellmphonemcontact mlis
ts,mdownloadablemmusic,metc.).mIf myoumteachminmamclassroommwithmcomputers,mask mstudents
mtomfind mexamplesmof mWebmsitesmthat mappearmtombemaccessingmdatabases.
2. Contrast mthemtermsm―data‖ mand m―information.‖ mUsingmFigurem1-
1masmamstartingmpoint,mhavemthemstudentsmprovidemsomemgood mexamplesmof mdatamand minform
ationmfrommtheirmownmexperiences. mThism maymwell mlead mtomsomemdifferencesmof mopinion,ma
nd mthemconclusionmthat monemperson’smdatammaymbemanothermperson’sminformation.
3. Introducemthemconcept mof mmetadatamusingmTablem1-
1.mAskmthemstudentsmtomsuggest mothermmetadatamthat mmight mbemappropriatemformthismexampl
e.
4. Discussmfile mprocessingmsystemsmand mtheirmlimitations,musingmFigurem1-2mand mTablem1-
2.mEmphasizemthat mmanymof mthesemsystemsmaremstillminmusemtoday.
5. IntroducemdatammodelsmusingmFigure m1-
3.mDiscussmthemdifferencesmbetweenmanmenterprisemdatammodelmand mamproject mdatammodel,m
usingmFiguresm1-3m(a)mand m(b).
TestmBank Pagem
4
h
Test Bank for Modern Database Management, 13th Edi
m m m m m m m
tion, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, I
m m m m m m m
SBN-10: 0134877004, ISBN-13:
m m
9780134877006. All 14 Chapters
m m m
TestmBank Pagem
1
, ModernmDatabasemManagement,m13thmEdition,mJeff mHoffer,mRames
h
Chapter 1 the Database Environment and Development
m m m m m m
m Process
Chapter Overview
m
Thempurposemof mthismchaptermismto mintroducemstudentsmto mthemworld mof mdatammanagementmasmamwhole,mand m
specifically mto mthemdatabasemapproach mto minformation msystemsmdevelopment, mthemimportantmconceptsmand m
principlesmof mthemdatabasemapproach,mand mthemdatabasemdevelopmentmprocessmwithin mthembroadermcontextm
of minformation msystemsmdevelopment.mThismisman mimportantmchaptermbecause mitmconveysmamsensemof mthemce
ntralmimportancemof mdatabasesmand mdatammanagementmin mtoday’sminformation msystemsmenvironmentmand mi
n mallmmodern menterprises.mThemideamof man morganizationalmdatabase mismintuitively mappealingmto mmostmstude
nts.mHowever,mmany mstudentsmwillmhavemlittlemormno mbackground mormexperience mwith mthemtechnicalmimple
mentation mof mdatabases.mOthersmwillmhavemhad msomemexperiencemwith mdatabase mmanagementmsystemsminte
nded mformpersonalmormworkgroup musem(such masmMicrosoftmAccess).mConsequently,mthey mwillmhavemamlimite
d mperspective mconcerningman morganizationalmapproach mto mdatabases.
In mthismchapter,mwemintroducemthembasicmconceptsmand mdefinitionsmof mdatabasesmand mdatammanagement,msta
rtingmwith man morganizingmframework mthatmismnewmto mthismchapter.mWemcontrastmdatamwith minformation,man
d mintroducemthemnotion mof mmetadatamand mitsmimportance.mWemalso mcontrastmthemdatabasemapproach mwith mol
dermfilemprocessingmsystems,mand mintroducemthemPinemValley mFurniture mCompany mcasemto millustratemthesem
concepts.mWemdescribe mthemrangemof mdatabasemapplications,mfrommdatabasesmwith mampersonalmormworkgrou
p mscopemto menterprise mdatabases,mand midentify mkey mdecisionsmthatmmustmbemmademformeach mtypemof mdatabas
e.mWemdescribe mboth mthempotentialmbenefitsmand mtypicalmcostsmof musingmthemdatabase mapproach.mWemalso mtr
acemthemhistoricalmevolution mof mdatabase msystems,min mordermto mprovide mamcontextmformunderstandingmthemda
tabasemapproach mformdatamstoragemand mretrieval.mThemchaptermoutlinesmthemdifferencesmbetween mtransaction
almand minformationalmapproachesmand mhighlightsmthemway mnew,manalytics-
focused mtechnologiesmaremtransformingmdatammanagement.
Themchaptermalso mpresentsman mexpanded mdescription mof mthemsystemsmdevelopmentmlifemcyclem(includingman
mintroduction mto mrapid mapplication mdevelopmentmmethodsmof mprototypingmand magilemsoftwaremdevelopment
)mand m themrolem ofm databasem developmentm withinm it.mThem chapterm providesman m updated mdescriptionm ofm them
well-
TestmBank Pagem
2
, ModernmDatabasemManagement,m13thmEdition,mJeff mHoffer,mRames
h
known mthree-
schemamarchitecture mand musesmitmto msummarize mthemvariousmdeliverablesmof mdatabase mdevelopment.mItmcon
cludesmwith man mexamplemof mdatabasemdevelopmentmsituated min mthemcontextmthemPinemValley mFurniture mCo
mpany mcase.
Chapter Objectives
m
Specificmstudentmlearningmobjectivesmaremincluded matmthembeginningmof meach mchapter.mFromman minstructor’
smpointmofmview,mthemobjectivesmofmthismchaptermaremto:
1. Createmamsensemof mexcitement mconcerningmthemdatamand mdatabasemmanagement mfield mand mt
hemtypesmof mjobmopportunitiesmthat maremavailable.
2. Acquaint mstudentsmwithmthembroad mspectrummof mdatabasemapplicationsmand mhow morganizati
onsmaremusingmdatabasemapplicationsmformcompetitivemadvantage.
3. Introducemthemdatammanagement mframeworkmthat morganizesmthembookmand mthemconceptualm
spacemof mdatammanagement,mhighlighting mhowmrelationalmtechnologiesmand mnon-
relationalmtechnologiesmcanmbemseenmasmpart mof mthemsamemspace.
4. Introducemthemkeymtermsmand mdefinitionsmthat mdescribemthemdatabasemenvironment.
5. Describemdatammodelsmand mhowmtheymaremused mtomcapturemthemnaturemand mrelationships mam
ongmdata.
6. Describemthemmajormcomponentsmof mthemdatabasemenvironment mand mhow mthesemcomponent
sminteract mwithmeachmother.
7. Providemamreview mof msystemsmdevelopment mmethodologies,mparticularlymthemsystemsmdevel
opment mlifemcycle, mprototyping,mand magilemsoftwaremdevelopment;mbuild manmunderstanding
mof mhow mdatabasemdevelopment mismaligned mwithmthesemmethodologies.
8. Develop man munderstandingmof mthemdifferentmrolesmwithin min mamdatabase mdevelopmentmteam.
9. Makemstudentsmawaremof mthemthree-
schema marchitecture mand mitsmbenefitsmformdatabase mdevelopmentmand mdesign.
10. IntroducemthemPinemValleymFurnituremCompanymcase,mwhichmismused mthroughout mthemtext mt
omillustratemimportant mconcepts.
11. IntroducemthemMountainmView mCommunitymHospitalmcase,mwhichmismincluded mat mthemend mo
f meachmchaptermasmamsourcemformstudent mprojects.
TestmBank Pagem
3
, ModernmDatabasemManagement,m13thmEdition,mJeff mHoffer,mRames
h
Key Terms
m
Agilemsoftwaremdevelopment Database Metadata
Conceptualmschema Databasemapplication Physicalmschema
Constraint Databasemmanagement msystem m(DB Project
MS)
Data Enterprisemdata mmodeling Prototyping
Data mindependence Enterprisemresourcemplanningm(ERP) Relationalmdatabase
Data mmodel Entity Repository
Data mmodelingmand mdesign mtools Information Systemsm development m lifem cyclem (S
DLC)
Data mwarehouse Logicalmschema Usermview
Classroom Ideasm
1. Start mwithmamdiscussionmof mhowmstudentsminteract mwithmsystemsmbuilt monmdatabasesmonmamda
ilymbasism (credit mcard mtransactions,mshopping mcards,mtelephonemcalls,m cellmphonemcontact mlis
ts,mdownloadablemmusic,metc.).mIf myoumteachminmamclassroommwithmcomputers,mask mstudents
mtomfind mexamplesmof mWebmsitesmthat mappearmtombemaccessingmdatabases.
2. Contrast mthemtermsm―data‖ mand m―information.‖ mUsingmFigurem1-
1masmamstartingmpoint,mhavemthemstudentsmprovidemsomemgood mexamplesmof mdatamand minform
ationmfrommtheirmownmexperiences. mThism maymwell mlead mtomsomemdifferencesmof mopinion,ma
nd mthemconclusionmthat monemperson’smdatammaymbemanothermperson’sminformation.
3. Introducemthemconcept mof mmetadatamusingmTablem1-
1.mAskmthemstudentsmtomsuggest mothermmetadatamthat mmight mbemappropriatemformthismexampl
e.
4. Discussmfile mprocessingmsystemsmand mtheirmlimitations,musingmFigurem1-2mand mTablem1-
2.mEmphasizemthat mmanymof mthesemsystemsmaremstillminmusemtoday.
5. IntroducemdatammodelsmusingmFigure m1-
3.mDiscussmthemdifferencesmbetweenmanmenterprisemdatammodelmand mamproject mdatammodel,m
usingmFiguresm1-3m(a)mand m(b).
TestmBank Pagem
4
