ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRamesh
Test Bank for Modern Database Management, 13th Editi
g g g g g g g
on, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, ISB
g g g g g g g
N-10: 0134877004, ISBN-13:
g g
9780134877006. All 14 Chapters
g g g
TestgBank Pageg1
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRamesh
Chapter 1 the Database Environment and Development
g g g g g g g
Process
Chapter Overview
g
Thegpurposegofgthisgchaptergisgtogintroducegstudentsgtogthegworldgofgdatagmanagementgasgagwhole,gandgspecif
icallygtogthegdatabasegapproachgtoginformationgsystemsgdevelopment,gthegimportantgconceptsgandgprinciples
g ofgthegdatabasegapproach,gandgthegdatabasegdevelopmentgprocessgwithingthegbroadergcontextgofginformation
g systemsgdevelopment.gThisgisgangimportantgchaptergbecausegitgconveysgagsensegofgthegcentralgimportancegof
g databasesgandgdatagmanagementgingtoday’sginformationgsystemsgenvironmentgandgingallgmoderngenterprises
.gThegideagofgangorganizationalgdatabasegisgintuitivelygappealinggtogmostgstudents.gHowever,gmanygstudentsg
willghaveglittlegorgnogbackgroundgorgexperiencegwithgthegtechnicalgimplementationgofgdatabases.gOthersgwill
g haveghadgsomegexperiencegwithgdatabasegmanagementgsystemsgintendedgforgpersonalgorgworkgroupguseg(su
chgasgMicrosoftgAccess).gConsequently,gtheygwillghavegaglimitedgperspectivegconcerninggangorganizationalg
approachgtogdatabases.
Ingthisgchapter,gwegintroducegthegbasicgconceptsgandgdefinitionsgofgdatabasesgandgdatagmanagement,gstarting
g withgangorganizinggframeworkgthatgisgnewgtogthisgchapter.gWegcontrastgdatagwithginformation,gandgintroduc
egthegnotiongofgmetadatagandgitsgimportance.gWegalsogcontrastgthegdatabasegapproachgwithgoldergfilegprocess
inggsystems,gandgintroducegthegPinegValleygFurnituregCompanygcasegtogillustrategthesegconcepts.gWegdescri
begthegrangegofgdatabasegapplications,gfromgdatabasesgwithgagpersonalgorgworkgroupgscopegtogenterprisegdat
abases,gandgidentifygkeygdecisionsgthatgmustgbegmadegforgeachgtypegofgdatabase.gWegdescribegbothgthegpoten
tialgbenefitsgandgtypicalgcostsgofgusinggthegdatabasegapproach.gWegalsogtracegtheghistoricalgevolutiongofgdata
basegsystems,gingordergtogprovidegagcontextgforgunderstandinggthegdatabasegapproachgforgdatagstoragegandgret
rieval.gThegchaptergoutlinesgthegdifferencesgbetweengtransactionalgandginformationalgapproachesgandghighli
ghtsgthegwaygnew,ganalytics-focusedgtechnologiesgaregtransforminggdatagmanagement.
Thegchaptergalsogpresentsgangexpandedgdescriptiongofgthegsystemsgdevelopmentglifegcycleg(includinggangintr
oductiongtograpidgapplicationgdevelopmentgmethodsgofgprototypinggandgagilegsoftwaregdevelopment)gandg th
eg roleg ofg databaseg developmentg withingit.gTheg chapterg providesg ang updatedgdescriptiong ofg theg well-
TestgBank Pageg2
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRamesh
knowngthree-
schemagarchitecturegandgusesgitgtogsummarizegthegvariousgdeliverablesgofgdatabasegdevelopment.gItgconclud
esgwithgangexamplegofgdatabasegdevelopmentgsituatedgingthegcontextgthegPinegValleygFurnituregCompanygca
se.
Chapter Objectives
g
Specificgstudentglearninggobjectivesgaregincludedgatgthegbeginninggofgeachgchapter.gFromganginstructor’sgpoi
ntgofgview,gthegobjectivesgofgthisgchaptergaregto:
1. Creategagsensegofgexcitementgconcerninggthegdatagandgdatabasegmanagementgfieldgandgthegty
pesgofgjobgopportunitiesgthatgaregavailable.
2. Acquaintgstudentsgwithgthegbroadgspectrumgofgdatabasegapplicationsgandghowgorganizations
g aregusinggdatabasegapplicationsgforgcompetitivegadvantage.
3. Introducegthegdatagmanagementgframeworkgthatgorganizesgthegbookgandgthegconceptualgspa
cegofgdatagmanagement,ghighlightingghowgrelationalgtechnologiesgandgnon-
relationalgtechnologiesgcangbegseengasgpartgofgthegsamegspace.
4. Introducegthegkeygtermsgandgdefinitionsgthatgdescribegthegdatabasegenvironment.
5. Describegdatagmodelsgandghowgtheygaregusedgtogcapturegthegnaturegandgrelationshipsgamongg
data.
6. Describegthegmajorgcomponentsgofgthegdatabasegenvironmentgandghowgthesegcomponentsgin
teractgwithgeachgother.
7. Providegagreviewgofgsystemsgdevelopmentgmethodologies,gparticularlygthegsystemsgdevelop
mentglifegcycle,gprototyping,gandgagilegsoftwaregdevelopment;gbuildgangunderstandinggofgho
wgdatabasegdevelopmentgisgalignedgwithgthesegmethodologies.
8. Developgangunderstandinggofgthegdifferentgrolesgwithingingagdatabasegdevelopmentgteam.
9. Makegstudentsgawaregofgthegthree-
schemagarchitecturegandgitsgbenefitsgforgdatabasegdevelopmentgandgdesign.
10. IntroducegthegPinegValleygFurnituregCompanygcase,gwhichgisgusedgthroughoutgthegtextgtogill
ustrategimportantgconcepts.
11. IntroducegthegMountaingViewgCommunitygHospitalgcase,gwhichgisgincludedgatgthegendgofgea
chgchaptergasgagsourcegforgstudentgprojects.
TestgBank Pageg3
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRamesh
Key Terms
g
Agilegsoftwaregdevelopment Database Metadata
Conceptualgschema Databasegapplication Physicalgschema
Constraint Databasegmanagementgsystemg(DB Project
MS)
Data Enterprisegdatagmodeling Prototyping
Datagindependence Enterprisegresourcegplanningg(ERP) Relationalgdatabase
Datagmodel Entity Repository
Datagmodelinggandgdesigngtools Information Systemsg developmentg lifeg cycleg (S
DLC)
Datagwarehouse Logicalgschema Usergview
Classroom Ideas g
1. Startgwithgagdiscussiongofghowgstudentsginteractgwithgsystemsgbuiltgongdatabasesgongagdailygb
asisg(creditgcardgtransactions,gshoppinggcards,gtelephonegcalls,gcellgphonegcontactglists,gdow
nloadablegmusic,getc.).gIfgyougteachgingagclassroomgwithgcomputers,gaskgstudentsgtogfindgexa
mplesgofgWebgsitesgthatgappeargtogbegaccessinggdatabases.
2. Contrastgthegtermsg―data‖gandg―information.‖gUsinggFigureg1-
1gasgagstartinggpoint,ghavegthegstudentsgprovidegsomeggoodgexamplesgofgdatagandginformatio
ngfromgtheirgowngexperiences.gThisgmaygwellgleadgtogsomegdifferencesgofgopinion,gandgthegc
onclusiongthatgonegperson’sgdatagmaygbeganothergperson’sginformation.
3. IntroducegthegconceptgofgmetadatagusinggTableg1-
1.gAskgthegstudentsgtogsuggestgothergmetadatagthatgmightgbegappropriategforgthisgexample.
4. Discussgfilegprocessinggsystemsgandgtheirglimitations,gusinggFigureg1-2gandgTableg1-
2.gEmphasizegthatgmanygofgthesegsystemsgaregstillgingusegtoday.
5. IntroducegdatagmodelsgusinggFigureg1-
3.gDiscussgthegdifferencesgbetweengangenterprisegdatagmodelgandgagprojectgdatagmodel,gusin
ggFiguresg1-3g(a)gandg(b).
6. Discussgeachgofgthegadvantagesgofgthegdatabasegapproachg(Tableg1-
TestgBank Pageg4
Test Bank for Modern Database Management, 13th Editi
g g g g g g g
on, Jeff Hoffer, Ramesh Venkataraman, Heikki Topi, ISB
g g g g g g g
N-10: 0134877004, ISBN-13:
g g
9780134877006. All 14 Chapters
g g g
TestgBank Pageg1
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRamesh
Chapter 1 the Database Environment and Development
g g g g g g g
Process
Chapter Overview
g
Thegpurposegofgthisgchaptergisgtogintroducegstudentsgtogthegworldgofgdatagmanagementgasgagwhole,gandgspecif
icallygtogthegdatabasegapproachgtoginformationgsystemsgdevelopment,gthegimportantgconceptsgandgprinciples
g ofgthegdatabasegapproach,gandgthegdatabasegdevelopmentgprocessgwithingthegbroadergcontextgofginformation
g systemsgdevelopment.gThisgisgangimportantgchaptergbecausegitgconveysgagsensegofgthegcentralgimportancegof
g databasesgandgdatagmanagementgingtoday’sginformationgsystemsgenvironmentgandgingallgmoderngenterprises
.gThegideagofgangorganizationalgdatabasegisgintuitivelygappealinggtogmostgstudents.gHowever,gmanygstudentsg
willghaveglittlegorgnogbackgroundgorgexperiencegwithgthegtechnicalgimplementationgofgdatabases.gOthersgwill
g haveghadgsomegexperiencegwithgdatabasegmanagementgsystemsgintendedgforgpersonalgorgworkgroupguseg(su
chgasgMicrosoftgAccess).gConsequently,gtheygwillghavegaglimitedgperspectivegconcerninggangorganizationalg
approachgtogdatabases.
Ingthisgchapter,gwegintroducegthegbasicgconceptsgandgdefinitionsgofgdatabasesgandgdatagmanagement,gstarting
g withgangorganizinggframeworkgthatgisgnewgtogthisgchapter.gWegcontrastgdatagwithginformation,gandgintroduc
egthegnotiongofgmetadatagandgitsgimportance.gWegalsogcontrastgthegdatabasegapproachgwithgoldergfilegprocess
inggsystems,gandgintroducegthegPinegValleygFurnituregCompanygcasegtogillustrategthesegconcepts.gWegdescri
begthegrangegofgdatabasegapplications,gfromgdatabasesgwithgagpersonalgorgworkgroupgscopegtogenterprisegdat
abases,gandgidentifygkeygdecisionsgthatgmustgbegmadegforgeachgtypegofgdatabase.gWegdescribegbothgthegpoten
tialgbenefitsgandgtypicalgcostsgofgusinggthegdatabasegapproach.gWegalsogtracegtheghistoricalgevolutiongofgdata
basegsystems,gingordergtogprovidegagcontextgforgunderstandinggthegdatabasegapproachgforgdatagstoragegandgret
rieval.gThegchaptergoutlinesgthegdifferencesgbetweengtransactionalgandginformationalgapproachesgandghighli
ghtsgthegwaygnew,ganalytics-focusedgtechnologiesgaregtransforminggdatagmanagement.
Thegchaptergalsogpresentsgangexpandedgdescriptiongofgthegsystemsgdevelopmentglifegcycleg(includinggangintr
oductiongtograpidgapplicationgdevelopmentgmethodsgofgprototypinggandgagilegsoftwaregdevelopment)gandg th
eg roleg ofg databaseg developmentg withingit.gTheg chapterg providesg ang updatedgdescriptiong ofg theg well-
TestgBank Pageg2
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRamesh
knowngthree-
schemagarchitecturegandgusesgitgtogsummarizegthegvariousgdeliverablesgofgdatabasegdevelopment.gItgconclud
esgwithgangexamplegofgdatabasegdevelopmentgsituatedgingthegcontextgthegPinegValleygFurnituregCompanygca
se.
Chapter Objectives
g
Specificgstudentglearninggobjectivesgaregincludedgatgthegbeginninggofgeachgchapter.gFromganginstructor’sgpoi
ntgofgview,gthegobjectivesgofgthisgchaptergaregto:
1. Creategagsensegofgexcitementgconcerninggthegdatagandgdatabasegmanagementgfieldgandgthegty
pesgofgjobgopportunitiesgthatgaregavailable.
2. Acquaintgstudentsgwithgthegbroadgspectrumgofgdatabasegapplicationsgandghowgorganizations
g aregusinggdatabasegapplicationsgforgcompetitivegadvantage.
3. Introducegthegdatagmanagementgframeworkgthatgorganizesgthegbookgandgthegconceptualgspa
cegofgdatagmanagement,ghighlightingghowgrelationalgtechnologiesgandgnon-
relationalgtechnologiesgcangbegseengasgpartgofgthegsamegspace.
4. Introducegthegkeygtermsgandgdefinitionsgthatgdescribegthegdatabasegenvironment.
5. Describegdatagmodelsgandghowgtheygaregusedgtogcapturegthegnaturegandgrelationshipsgamongg
data.
6. Describegthegmajorgcomponentsgofgthegdatabasegenvironmentgandghowgthesegcomponentsgin
teractgwithgeachgother.
7. Providegagreviewgofgsystemsgdevelopmentgmethodologies,gparticularlygthegsystemsgdevelop
mentglifegcycle,gprototyping,gandgagilegsoftwaregdevelopment;gbuildgangunderstandinggofgho
wgdatabasegdevelopmentgisgalignedgwithgthesegmethodologies.
8. Developgangunderstandinggofgthegdifferentgrolesgwithingingagdatabasegdevelopmentgteam.
9. Makegstudentsgawaregofgthegthree-
schemagarchitecturegandgitsgbenefitsgforgdatabasegdevelopmentgandgdesign.
10. IntroducegthegPinegValleygFurnituregCompanygcase,gwhichgisgusedgthroughoutgthegtextgtogill
ustrategimportantgconcepts.
11. IntroducegthegMountaingViewgCommunitygHospitalgcase,gwhichgisgincludedgatgthegendgofgea
chgchaptergasgagsourcegforgstudentgprojects.
TestgBank Pageg3
, ModerngDatabasegManagement,g13thgEdition,gJeffgHoffer,gRamesh
Key Terms
g
Agilegsoftwaregdevelopment Database Metadata
Conceptualgschema Databasegapplication Physicalgschema
Constraint Databasegmanagementgsystemg(DB Project
MS)
Data Enterprisegdatagmodeling Prototyping
Datagindependence Enterprisegresourcegplanningg(ERP) Relationalgdatabase
Datagmodel Entity Repository
Datagmodelinggandgdesigngtools Information Systemsg developmentg lifeg cycleg (S
DLC)
Datagwarehouse Logicalgschema Usergview
Classroom Ideas g
1. Startgwithgagdiscussiongofghowgstudentsginteractgwithgsystemsgbuiltgongdatabasesgongagdailygb
asisg(creditgcardgtransactions,gshoppinggcards,gtelephonegcalls,gcellgphonegcontactglists,gdow
nloadablegmusic,getc.).gIfgyougteachgingagclassroomgwithgcomputers,gaskgstudentsgtogfindgexa
mplesgofgWebgsitesgthatgappeargtogbegaccessinggdatabases.
2. Contrastgthegtermsg―data‖gandg―information.‖gUsinggFigureg1-
1gasgagstartinggpoint,ghavegthegstudentsgprovidegsomeggoodgexamplesgofgdatagandginformatio
ngfromgtheirgowngexperiences.gThisgmaygwellgleadgtogsomegdifferencesgofgopinion,gandgthegc
onclusiongthatgonegperson’sgdatagmaygbeganothergperson’sginformation.
3. IntroducegthegconceptgofgmetadatagusinggTableg1-
1.gAskgthegstudentsgtogsuggestgothergmetadatagthatgmightgbegappropriategforgthisgexample.
4. Discussgfilegprocessinggsystemsgandgtheirglimitations,gusinggFigureg1-2gandgTableg1-
2.gEmphasizegthatgmanygofgthesegsystemsgaregstillgingusegtoday.
5. IntroducegdatagmodelsgusinggFigureg1-
3.gDiscussgthegdifferencesgbetweengangenterprisegdatagmodelgandgagprojectgdatagmodel,gusin
ggFiguresg1-3g(a)gandg(b).
6. Discussgeachgofgthegadvantagesgofgthegdatabasegapproachg(Tableg1-
TestgBank Pageg4
