Part 3 Review Questions and Exercises.doc

SOLUTIONSTOREVIEWQUESTIONSANDEXERCISESFORPART3-DATABASEANALYSISANDDESIGN(CHAPTERS10–15)SolutionstoReviewQuestionsandExercisesChapter10DatabaseSystemDevelopmemtLifecycle 3Chapter11DatabaseAnalysisandtheDreamHomeCaseStudy 6Chapter12Entity-RelationshipModeling 10Chapter13EnhancedEntity-RelationshipModeling 16Chapter14Normalization 19Chapter15AdvancedNormalization ,databasesoftware,puterhardwareincludingstoragemedia, Discusstherelationshipbetweentheinformationsystemslifecycleandthedatabasesystemdevelopmentlifecycle. Describethemainpurpose(s)andactivitiesassociatedwitheachstageofthedatabasesystemdevelopmentlifecycle. :defineswhatisrequiredofadatabasesystemfromtheperspectiveofaparticularjobrole(suchasManagerorSupervisor)orenterpriseapplicationarea(suchasmarketing,personnel,orstockcontrol)(). :centralized,viewintegration,binationofbothapproaches().,logicaldatabasedesign,,,(). Whatarethemainpurposesofdatamodelingandidentifythecriteriaforanoptimaldatamodel. Thetwomainpurposesofdatamodelingaretoassistintheunderstandingofthemeaning(semantics)municationabouttheinformationrequirements(). Identifythestage(s)whereitisappropriatetose