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	WCM	CU
45	30	00	60	100	60	40	4