2. Explainthecharacteristicsthatdistinguishthedatabaseapproachfromthetraditionalapproachof programming withdatafiles,citethebasicgoals,functions,models,components, applications, andsocialimpactofdatamanagementsystems,describethecomponentsofadatabasesystem andgiveexamplesoftheiruseanduseaquerylanguagetoelicitinformationfromadatabase. 3. Categorizedatamodelsbasedonthetypesofconceptsthattheyprovidetodescribethedatabase structureandcompareandcontrastthebasicprinciples oftherelational datamodelandthoseof theobject-orientedmodelastheyapplytocomputerengineeringapplications. 4. Preparearelationalschemafromaconceptualmodeldevelopedusingtheentity-relationship model, explain and demonstrate the concepts of entity integrity constraint and referential integrity constraintand demonstratethe successfulformulationof queries in the relational algebraandqueriesinthetuplerelationalcalculus. 5. CreatearelationaldatabaseschemainSQLthatincorporateskey,entityintegrity,andreferential integrityconstraints;demonstrate datadefinitioninSQLandretrievinginformation froma databaseusingtheSQLSELECTstatement,evaluateasetofqueryprocessingstrategiesand selecttheoptimalstrategy,anddemonstratetheabilitytoembedobject-oriented queriesintoan appropriatestand-aloneprogramminglanguage 6. Determinethefunctionaldependencybetweentwoormoreattributesthatareasubsetofa relation,demonstratethe abilityto transformarelationintoaprescribednormalform,explainthe impactofnormalizationontheefficiencyofdatabaseoperationsandqueryoptimizationand describeamulti-valueddependencyandthetypeofconstraintsitspecifies. 7. Explainthepurposeofrollbackandthewayloggingassuresthatproperrollbacktakesplace; outlinethespecialproblemsarisingfromtheuseofconcurrency andtheeffectofeffectof differentisolationlevelsontheconcurrencycontrolmechanisms, anddemonstratetheabilityto applysuitableideasonfailureandrecoverytoanapplicationtakenfromcomputerengineering. 8. Evaluatesimplestrategiesforexecutingadistributedquerytoselectthestrategythatminimizes theamountofdatatransfer,Explainhowtousethetwo-phasecommitprotocoltodealwith committing atransactionthataccessesdatabasesstoredonmultiplenodes,andcompareand contrastthedifferentapproachestodistributedconcurrencycontrol. 9. Citeexamplesoftheapplicationofprimary,secondary,andclusteringindexes,explainthe theoryandapplicationofinternalandexternalhashingtechniques anditsuseinfacilitating dynamicfileexpansion,describetherelationshipsamonghashing,compression,andefficient databasesearches andexplainhowphysical database designaffectsdatabase transaction efficiency.

ReferenceMaterials 1. Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom, 2008. Database Systems: The 2ndEdition Complete Book Book (DS:CB), , Prentice Hall, ISBN-10: 0130319953, ISBN-13: 9780130319951 2. JeffreyD.Ullman,JenniferWidom,2007.AFirstCourseinDatabaseSystems.PrenticeHall, ISBN013600637X 3. Rebecca Riordan, 2005. Designing EffectiveDatabase Systems. Addison-Wesley ISBN

- 0321290933.

4. ThomasM.Connolly,andCarolynE.Begg,2004.DatabaseSystems:APracticalApproachto Design,Implementation.Addison-Wesley,ISBN0321294017

Requirements

PeriodperWeek	Contact Hourper Semester	Weighted Total Mark	Weighted ExamMark	Weighted Continuous Assessment Mark	Credit Units
LH	PH	TH	CH	WTM	WEM