ÿþ<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=unicode"> <meta name=ProgId content=Word.Document> <meta name=Generator content="Microsoft Word 12"> <meta name=Originator content="Microsoft Word 12"> <link rel=File-List href="CSI3130_Fall11_files/filelist.xml"> <title>CSI3130_Fall11</title> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="address"/> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="Street"/> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"/> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PlaceName"/> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PlaceType"/> <!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Author>Samer Sader</o:Author> <o:Template>Normal</o:Template> <o:LastAuthor> </o:LastAuthor> <o:Revision>41</o:Revision> <o:TotalTime>42</o:TotalTime> <o:Created>2011-08-23T19:10:00Z</o:Created> <o:LastSaved>2011-08-24T22:46:00Z</o:LastSaved> <o:Pages>2</o:Pages> <o:Words>763</o:Words> <o:Characters>4352</o:Characters> <o:Company>Univ. of/d' Ottawa</o:Company> <o:Lines>36</o:Lines> <o:Paragraphs>10</o:Paragraphs> <o:CharactersWithSpaces>5105</o:CharactersWithSpaces> <o:Version>12.00</o:Version> </o:DocumentProperties> </xml><![endif]--> <link rel=themeData href="CSI3130_Fall11_files/themedata.thmx"> <link rel=colorSchemeMapping href="CSI3130_Fall11_files/colorschememapping.xml"> <!--[if gte mso 9]><xml> <w:WordDocument> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:TrackMoves>false</w:TrackMoves> <w:TrackFormatting/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="&#45;-"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false" DefSemiHidden="false" DefQFormat="false" LatentStyleCount="267"> <w:LsdException Locked="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="caption"/> <w:LsdException Locked="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="99" Name="No List"/> <w:LsdException Locked="false" Priority="99" SemiHidden="true" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" Name="Light List"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" Priority="99" SemiHidden="true" Name="Revision"/> <w:LsdException Locked="false" Priority="34" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" SemiHidden="true" UnhideWhenUsed="true" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if !mso]><object classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Batang; panose-1:2 3 6 0 0 1 1 1 1 1; mso-font-alt:¼ÕÐ; mso-font-charset:129; mso-generic-font-family:auto; mso-font-format:other; mso-font-pitch:fixed; mso-font-signature:1 151388160 16 0 524288 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:"\@Batang"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:129; mso-generic-font-family:auto; mso-font-format:other; mso-font-pitch:fixed; mso-font-signature:1 151388160 16 0 524288 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Batang;} h1 {mso-style-unhide:no; mso-style-qformat:yes; mso-style-link:"Heading 1 Char"; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:1; font-size:24.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; font-weight:bold;} a:link, span.MsoHyperlink {mso-style-unhide:no; color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {mso-style-unhide:no; color:blue; text-decoration:underline; text-underline:single;} p {mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Batang;} span.Heading1Char {mso-style-name:"Heading 1 Char"; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Heading 1"; mso-ansi-font-size:14.0pt; mso-bidi-font-size:14.0pt; font-family:"Cambria","serif"; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi; color:#365F91; mso-themecolor:accent1; mso-themeshade:191; font-weight:bold;} span.apple-converted-space {mso-style-name:apple-converted-space; mso-style-unhide:no;} span.apple-style-span {mso-style-name:apple-style-span; mso-style-unhide:no;} span.bylinepipe {mso-style-name:bylinepipe; mso-style-unhide:no;} span.SpellE {mso-style-name:""; mso-spl-e:yes;} span.GramE {mso-style-name:""; mso-gram-e:yes;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:550576901; mso-list-template-ids:1821690532;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:·ð; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l1 {mso-list-id:1159928296; mso-list-template-ids:-17683112;} @list l1:level1 {mso-level-number-format:bullet; mso-level-text:·ð; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l1:level2 {mso-level-tab-stop:1.0in; mso-level-number-position:left; text-indent:-.25in;} @list l1:level3 {mso-level-tab-stop:1.5in; mso-level-number-position:left; text-indent:-.25in;} @list l1:level4 {mso-level-tab-stop:2.0in; mso-level-number-position:left; text-indent:-.25in;} @list l1:level5 {mso-level-tab-stop:2.5in; mso-level-number-position:left; text-indent:-.25in;} @list l1:level6 {mso-level-tab-stop:3.0in; mso-level-number-position:left; text-indent:-.25in;} @list l1:level7 {mso-level-tab-stop:3.5in; mso-level-number-position:left; text-indent:-.25in;} @list l1:level8 {mso-level-tab-stop:4.0in; mso-level-number-position:left; text-indent:-.25in;} @list l1:level9 {mso-level-tab-stop:4.5in; mso-level-number-position:left; text-indent:-.25in;} @list l2 {mso-list-id:1303921640; mso-list-template-ids:-721268476;} @list l2:level1 {mso-level-number-format:bullet; mso-level-text:·ð; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l2:level2 {mso-level-tab-stop:1.0in; mso-level-number-position:left; text-indent:-.25in;} @list l2:level3 {mso-level-tab-stop:1.5in; mso-level-number-position:left; text-indent:-.25in;} @list l2:level4 {mso-level-tab-stop:2.0in; mso-level-number-position:left; text-indent:-.25in;} @list l2:level5 {mso-level-tab-stop:2.5in; mso-level-number-position:left; text-indent:-.25in;} @list l2:level6 {mso-level-tab-stop:3.0in; mso-level-number-position:left; text-indent:-.25in;} @list l2:level7 {mso-level-tab-stop:3.5in; mso-level-number-position:left; text-indent:-.25in;} @list l2:level8 {mso-level-tab-stop:4.0in; mso-level-number-position:left; text-indent:-.25in;} @list l2:level9 {mso-level-tab-stop:4.5in; mso-level-number-position:left; text-indent:-.25in;} @list l3 {mso-list-id:1706246140; mso-list-template-ids:-331682500;} @list l3:level1 {mso-level-number-format:bullet; mso-level-text:·ð; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} --> </style> <!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";} </style> <![endif]--><!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="6146"/> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1"/> </o:shapelayout></xml><![endif]--> </head> <body lang=EN-US link=blue vlink=blue style='tab-interval:.5in'> <div class=WordSection1> <div align=center> <table class=MsoNormalTable border=0 cellpadding=0 width="75%" style='width:75.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184;mso-padding-alt: 0in 5.4pt 0in 5.4pt'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'> <td style='padding:.75pt .75pt .75pt .75pt'> <p><strong>University of <st1:place w:st="on"><st1:PlaceName w:st="on">Ottawa</st1:PlaceName> <span style='font-weight:normal'><br> </span><st1:PlaceType w:st="on">School</st1:PlaceType></st1:place> of Electrical Engineering and Computer Science (SEECS)</strong><br> <strong>CSI3130: Databases II</strong><br> <strong>Fall 2011</strong></p> <p>&nbsp;</p> <p><strong>Course Description</strong><br> Query processing and optimization. Transaction processing, concurrency control and recovery. Distributed and multi-databases. Indexing. Data warehousing and Data mining. Data integration. <br> Design and implementation of a database component in a team project.<br> <strong>Prerequisite:&nbsp; CSI2132- Databases I</strong></p> <p><strong>Time Schedule<span class=GramE>:</span></strong><br> LEC &nbsp;&nbsp;&nbsp; Tuesday&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13:00 - 14:30 &nbsp; <st1:address w:st="on"><st1:Street w:st="on">STE</st1:Street> C0136</st1:address><br> LEC &nbsp;&nbsp;&nbsp; Thursday&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11:30 - 13:00 &nbsp; STE C0136 <br> TUT&nbsp; &nbsp;&nbsp; Tuesday&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11:30 - 13:00 &nbsp; STE C0136&nbsp;&nbsp; <br> LAB&nbsp;&nbsp;&nbsp;&nbsp; Thursday&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14:30 - 16:00 &nbsp; <st1:address w:st="on"><st1:Street w:st="on">STE</st1:Street> 0130</st1:address>&nbsp; <br> The TA will be available during the tutorial hours in order to answer questions regarding the theory component of this course. <br> Students are encouraged to work through the exercises at the end of each chapter and consult the solutions as provided on the book s website.</p> <p><strong>Professor s details</strong><br> Ph.D. Candidate: <span class=SpellE>Oana</span> Frunza<br> SITE Room 5-010<br> Email: <a href="mailto:hlviktor@site.uottawa,ca"><span class=SpellE>ofrunza</span>{at}<span class=SpellE>site.uottawa,ca</span></a><br> Office hours: &nbsp;Thursday 10h00-11h00</p> <p><strong>Ta: </strong>Michael Mireku Kwakye<br> Office: SITE, Room 4-010<br> E-mail: mmire083@uottawa.ca</p> <p><strong>Prescribed Books<span class=GramE>:</span></strong><br> <b style='mso-bidi-font-weight:normal'><span style='background:yellow; mso-highlight:yellow'>Book 1:</span></b><span style='background:yellow; mso-highlight:yellow'> Database Management Systems</span><span style='mso-spacerun:yes'>           </span>(<u>We will follow this book</u>)<br> R. <span class=SpellE>Ramakrishnan</span> and J. <span class=SpellE>Gehrke</span> (3<sup>rd</sup> Edition)<br> McGraw Hill, 2003<br> The book has a great website, see <a href="http://www.cs.wisc.edu/~dbbook">www.cs.wisc.edu/~dbbook</a>.</p> <h1 style='margin:0in;margin-bottom:.0001pt'><span style='font-size:12.0pt; mso-fareast-font-family:"Times New Roman";color:black;background:white; mso-bidi-font-weight:normal'>Book 2:</span><span style='font-size:12.0pt; mso-fareast-font-family:"Times New Roman";color:black;background:white; font-weight:normal'> Fundamentals of Database Systems<span class=apple-converted-space>&nbsp;</span><o:p></o:p></span></h1> <h1 style='margin:0in;margin-bottom:.0001pt'><span class=apple-style-span><span style='font-size:12.0pt;mso-fareast-font-family:"Times New Roman";color:black; background:white;font-weight:normal;mso-bidi-font-weight:bold'>R. <span class=SpellE>Elmasri</span></span></span><span class=apple-converted-space><span style='font-size:12.0pt;mso-fareast-font-family:"Times New Roman";color:black; background:white;font-weight:normal;mso-bidi-font-weight:bold'>&nbsp;and </span></span><span class=apple-style-span><span style='font-size:12.0pt;mso-fareast-font-family: "Times New Roman";color:black;background:white;font-weight:normal;mso-bidi-font-weight: bold'>S. <span class=SpellE>Navathe</span> (6<sup>th</sup> Edition)</span><o:p></o:p></span></h1> <h1 style='margin:0in;margin-bottom:.0001pt'><span class=apple-style-span><span style='font-size:12.0pt;mso-fareast-font-family:"Times New Roman";color:black; background:white;font-weight:normal;mso-bidi-font-weight:bold'>Addison Wesley</span></span><span class=apple-style-span><span style='font-size:12.0pt;mso-fareast-font-family: "Times New Roman";font-weight:normal;mso-bidi-font-weight:bold'>, 2010</span></span><span style='mso-bidi-font-weight:normal'><o:p></o:p></span></h1> <p>You need to be familiar with C programming. The classical text is:<br> The C programming language (2<sup>nd</sup> Edition)<br> Brain Kernighan and Dennis Ritchie<br> Prentice Hall, 2006</p> <p><strong>Software</strong><br> <a href="http://www.postgresql.org/"><span class=SpellE>PostgreSQL</span></a><strong>; </strong>&nbsp;<a href="http://www.pgadmin.org/">PGADMIN</a></p> <p class=MsoNormal>&nbsp;</p> <p class=MsoNormal><strong> <img src="Images/new.jpg" width="68" height="66"> Anouncements</strong> </p> <p class=MsoNormal>&nbsp;</p> <ol> <li>Assignment 1 is posted on Sept 19th, 2011 due data: Oct 16th, 22h00.</li> <li>Interesting readings: <a href="http://www.nytimes.com/2011/08/20/technology/finding-fake-reviews-online.html?_r=2&hp" target="_blank">5-star web reviews</a></li> </ol> <p class=MsoNormal>&nbsp;</p> <p class=MsoNormal>&nbsp;</p> <p class=MsoNormal><br clear=all> <strong>Mark Allocation</strong><br> Your final grade will be determined as follows<strong>:</strong><br> <strong>Assignments (2) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style='mso-spacerun:yes'>      </span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15</strong><br> <strong>Team project&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</strong><br> <strong>Mid Term&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</strong><br> <strong>Final Examination &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45</strong></p> <p><strong>Some other important information:</strong></p> <ul type=disc> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level1 lfo3;tab-stops:list .5in'>The course has both a tutorial and a lab. During the tutorial hours you will solve exercises related to the course material while during the lab you will get familiarized with the tool that we are using, <span class=SpellE>PostgreSQL</span>.</li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level1 lfo3;tab-stops:list .5in'>Note that you are required to obtain a combined mark of at least 50% for the midterm and final examination, in order to pass this course.</li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level1 lfo3;tab-stops:list .5in'>As per academic regulations, class attendance is mandatory. Also, as per academic regulations, students who do not attend 80% of the class will not be allowed to write the final examinations.</li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level1 lfo3;tab-stops:list .5in'>All components of the course (i.e. the team project, assignments, etc.) must be fulfilled otherwise students may receive an INC as a final mark (equivalent to an F).&nbsp; This is also valid for a student who is taking the course for the second time.</li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l2 level1 lfo3;tab-stops:list .5in'>For more information about academic fraud regulations, please visit the following <st1:place w:st="on"><st1:PlaceType w:st="on">University</st1:PlaceType> of <st1:PlaceName w:st="on">Ottawa</st1:PlaceName></st1:place> website: <a href="http://www.uottawa.ca/academic/info/regist/crs/0305/home_5_ENG.htm">www.uottawa.ca/academic/info/regist/crs/0305/home_5_ENG.htm</a>) Please take note that although the academic fraud regulations webpage dates back to 2003-2005, the regulations have remained the same and still apply. </li> </ul> <p>&nbsp;<strong>More about the Assignments and Team Project</strong></p> <ul type=disc> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l1 level1 lfo6;tab-stops:list .5in'>There will be two (2) individual assignments and one (1) team project (completed in a team of three (3) students). </li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l1 level1 lfo6;tab-stops:list .5in'>The team project will involve the extension of the <span class=SpellE>PostgreSQL</span> DBMS functionalities. </li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l1 level1 lfo6;tab-stops:list .5in'>All students are required to attend the project demonstrations.</li> <li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l1 level1 lfo6;tab-stops:list .5in'>The first lab is scheduled for the week of <strong>September 19, 2010</strong>.</li> </ul> <p class=MsoNormal><br clear=all> <strong>CSI3130 Course Outline </strong></p> <p>We will cover the following topics. I will post the material as we go along.</p> <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 style='mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt:0in 0in 0in 0in'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><strong>Week of</strong> </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><strong>Topic</strong> </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><strong>Reference</strong><b style='mso-bidi-font-weight:normal'> from<o:p></o:p></b></p> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><b style='mso-bidi-font-weight: normal'>Book 1<o:p></o:p></b></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><strong><i style='mso-bidi-font-style:normal'>Reference</i></strong><i style='mso-bidi-font-style:normal'> <b style='mso-bidi-font-weight:normal'>from<o:p></o:p></b></i></p> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><b style='mso-bidi-font-weight: normal'><i style='mso-bidi-font-style:normal'>Book 2</i><strong><o:p></o:p></strong></b></p> </td> </tr> <tr style='mso-yfti-irow:1;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>5 Sept </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>Introduction, <a href="Slides/Review.pdf">Review</a>, and Course Outline <br> <em><b>(First class Thursday September 8)</b></em> </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><a href="Slides/Ch1_Introduction.pdf">Chapter 1</a></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'>Chapter 1<o:p></o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:2;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>12 Sept </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>The RDBMS: Transaction management </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><a href="Slides/TransactionManagementIntro_Ch16.pdf">Chapter 16</a></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'>Chapter 21<o:p></o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:3;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>19 Sept </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>The RDBMS: Concurrency Control </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><a href="Slides/ConcurrencyControl_Ch17.pdf">Chapter 17</a></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'>Chapter 22<o:p></o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:4;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>26 Sept </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>The RDBMS: Recovery</p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><a href="Slides/Recovery_Ch18.pdf">Chapter 18</a>; <a href="Slides/Recovery_Ch18.ppt">.ppt</a></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'>Chapter 23<o:p></o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:5;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>&nbsp;3 Oct </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>The RDBMS: Indexing Revisited </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><a href="Slides/IndexingRevisit.pdf">Chapters 8-11</a></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'>Chapters 17,18<o:p></o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:6;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>10 Oct </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>The RDBMS: Query evaluation </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><a href="Slides/QueryProcessing_Ch12_Ch14.pdf">Chapters 12 and 14</a></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'>Chapter 19<o:p></o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:7;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>17 Oct </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><strong><span style='background:yellow;mso-highlight:yellow'>Revision and Midterm on Thursday October 20th during lecture time in normal lecture venue</span></strong> <a href="Slides/Midterm2011Memo.ppt">solution</a></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>Chapters 16-18 </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'><o:p>&nbsp;</o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:8;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>24 Oct </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><em><b>Study Week</b></em> </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>&nbsp; </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'><o:p>&nbsp;</o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:9;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>31 Oct </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>The RDBMS: Query evaluation (cont.) </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>Chapters 12 and 14 </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'>Chapter 19<o:p></o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:10;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>7 Nov </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>The RDBMS: Query optimization </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><a href="Slides/QueryOptimize_Ch15.ppt">Chapter 15 </a></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'>Chapter 19<o:p></o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:11;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>14 Nov </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>Distributed databases </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><a href="Slides/DistributedDatabases_Ch22.ppt">Chapter 22</a></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'>Chapter 25<o:p></o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:12;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>21 Nov </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>Data Warehousing, Decision Support <br> and Data Mining </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><a href="Slides/Dwarehouse_Ch25.ppt">Chapter 25</a></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'>Chapter 29<o:p></o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:13;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>28 Nov </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>Data Warehousing, Decision Support <br> and Data Mining</p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><a href="Slides/DMining_Ch26.ppt">Chapter 26</a></p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><i style='mso-bidi-font-style: normal'>Chapter 29<o:p></o:p></i></p> </td> </tr> <tr style='mso-yfti-irow:14;mso-yfti-lastrow:yes;height:7.5pt'> <td width=81 valign=top style='width:60.75pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>6 Dec </p> </td> <td width=303 valign=top style='width:227.25pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><em><b>Revision</b></em> </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'>Everything up to now </p> </td> <td width=170 valign=top style='width:127.5pt;padding:0in 0in 0in 0in; height:7.5pt'> <p class=MsoNormal style='mso-line-height-alt:7.5pt'><o:p>&nbsp;</o:p></p> </td> </tr> </table> <p><strong><a href="Lab/CSI3130LabsFall2011.htm" target="_blank">CSI3130 Laboratory Outline</a></strong></p> <p><strong><a href="Tutorial/CSI3130TutFall2011.htm" target="_blank">CSI3130 Tutorial Outline</a></strong></p> <p>&nbsp;</p> <p><strong>Additional material to read</strong>: </p> <p>1. TransactionManagement &amp; ConcorencyControl: <a href="AdditionalMaterial/SerializableViewSerializableConflictSerializable.pdf">1</a>, <a href="AdditionalMaterial/TransactionsConcurencyControl.doc">2</a>.</p> <p>2. Recovery: <a href="AdditionalMaterial/Recovery_Article.pdf">1.</a></p> <p>3. Data Warehousing: <a href="AdditionalMaterial/DW_Paper.pdf">1</a>.</p> <p>&nbsp;&nbsp;</p> <p>&nbsp;</p> </td> </tr> </table> </div> <p class=MsoNormal><o:p>&nbsp;</o:p></p> </div> </body> </html>