{"id":58,"date":"2025-07-31T10:11:39","date_gmt":"2025-07-31T16:11:39","guid":{"rendered":"https:\/\/courses.cs.colostate.edu\/cs430\/?page_id=58"},"modified":"2026-01-17T14:37:22","modified_gmt":"2026-01-17T21:37:22","slug":"activities","status":"publish","type":"page","link":"https:\/\/courses.cs.colostate.edu\/cs430\/activities\/","title":{"rendered":"Activities"},"content":{"rendered":"\n<p class=\"justify-text\">We encourage students to engage in these reading activities, which introduce the core concepts of database systems. These activities progress from foundational models and design principles to SQL, storage, query optimization, transactions, recovery, and practical application development.<\/p>\n\n\n<style>.kb-table-container58_cd24e2-1b{font-size:16px;overflow-x:auto;}.kb-table58_cd24e2-1b td:nth-of-type(1), .kb-table58_cd24e2-1b th:nth-of-type(1){width:20%;}.kb-table58_cd24e2-1b td:nth-of-type(2), .kb-table58_cd24e2-1b th:nth-of-type(2){width:50%;}.kb-table58_cd24e2-1b td:nth-of-type(3), .kb-table58_cd24e2-1b th:nth-of-type(3){width:30%;}.kb-table58_cd24e2-1b{table-layout:fixed;width:100%;}.kb-table-container .kb-table58_cd24e2-1b th{padding-top:var(--global-kb-spacing-xxs, 0.5rem);padding-right:var(--global-kb-spacing-xxs, 0.5rem);padding-bottom:var(--global-kb-spacing-xxs, 0.5rem);padding-left:var(--global-kb-spacing-xxs, 0.5rem);text-align:center;}.kb-table-container .kb-table58_cd24e2-1b caption{text-align:center;}.kb-table-container .kb-table58_cd24e2-1b td{padding-top:var(--global-kb-spacing-xxs, 0.5rem);padding-right:var(--global-kb-spacing-xxs, 0.5rem);padding-bottom:var(--global-kb-spacing-xxs, 0.5rem);padding-left:var(--global-kb-spacing-xxs, 0.5rem);text-align:left;}<\/style><div class=\"kb-table-container kb-table-container58_cd24e2-1b wp-block-kadence-table\"><table class=\"kb-table kb-table58_cd24e2-1b\">\n<style>.kb-table-container .kb-table tr.kb-table-row58_7ebe3d-1c{background-color:rgba(0,0,0,0.05);}<\/style><tr class=\"kb-table-row kb-table-row58_7ebe3d-1c\">\n<th class=\"kb-table-data kb-table-data58_263d55-7e\">\n\n<p class=\"has-text-align-left\">Week<\/p>\n\n<\/th>\n\n<th class=\"kb-table-data kb-table-data58_080df9-d5\">\n\n<p class=\"has-text-align-left\">Topic<\/p>\n\n<\/th>\n\n<th class=\"kb-table-data kb-table-data58_520adc-35\">\n\n<p class=\"has-text-align-left\">Reading<\/p>\n\n<\/th>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_6d1c58-1c\">\n<td class=\"kb-table-data kb-table-data58_70eb7f-30\">\n\n<p>1<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_ccfdfe-2b\">\n\n<p>Introduction to Database Systems<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_b79a86-3d\">\n\n<p>Chapter 1<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_0f36f6-b8\">\n<td class=\"kb-table-data kb-table-data58_6d4840-be\">\n\n<p>2<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_d2f9b8-95\">\n\n<p>Relational Model<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_ebd185-51\">\n\n<p>Chapter 2<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_11fefe-fa\">\n<td class=\"kb-table-data kb-table-data58_a9916c-7b\">\n\n<p>3<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_98b7ea-cf\">\n\n<p>Introduction to Database Design<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_54d845-a3\">\n\n<p>Chapter 6<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_7eaa7f-cc\">\n<td class=\"kb-table-data kb-table-data58_c821f1-05\">\n\n<p>5<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_e9a7a4-87\">\n\n<p>Relational Database Design (Normalization)<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_c1b0bd-c1\">\n\n<p>Chapter 7<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_4f2cd0-25\">\n<td class=\"kb-table-data kb-table-data58_1467a8-2c\">\n\n<p>5<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_fe57cd-5f\">\n\n<p>SQL: Constraints and Triggers<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_5863b9-7e\">\n\n<p>Chapters 3, 4, 5<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_4a3f02-1e\">\n<td class=\"kb-table-data kb-table-data58_305b1b-c0\">\n\n<p>6<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_8f57f5-61\">\n\n<p>SQL Queries<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_ddd0b6-86\">\n\n<p>Chapters 3, 4, 5<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_5f201f-de\">\n<td class=\"kb-table-data kb-table-data58_9b9f8d-41\">\n\n<p>7<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_af43cc-44\">\n\n<p>Tree-Based Indexing<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_8cae5b-92\">\n\n<p>Chapters 12, 13, 14<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_6e5523-18\">\n<td class=\"kb-table-data kb-table-data58_61021e-ec\">\n\n<p>8<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_455448-d5\">\n\n<p>Hash-indexing<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_4f2723-78\">\n\n<p>Chapters 12, 13, 14<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_529a27-bc\">\n<td class=\"kb-table-data kb-table-data58_db8681-9a\">\n\n<p>9<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_143b52-7a\">\n\n<p>Query Processing<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_ff8635-4c\">\n\n<p>Chapters 15, 16<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_ed79ec-ba\">\n<td class=\"kb-table-data kb-table-data58_29f5ed-e7\">\n\n<p>10<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_045d85-7c\">\n\n<p>Query Optimization<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_2668a2-67\">\n\n<p>Chapters 15, 16<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_ab53b1-6b\">\n<td class=\"kb-table-data kb-table-data58_807f31-9c\">\n\n<p>11<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_65d86f-8e\">\n\n<p>Transaction Processing<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_939c81-de\">\n\n<p>Chapters 17, 18<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_8063d4-ab\">\n<td class=\"kb-table-data kb-table-data58_a29fc6-ad\">\n\n<p>12<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_cc0533-f8\">\n\n<p>Transaction Processing Protocols<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_816a57-56\">\n\n<p>Chapters 17, 18<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_16459a-f6\">\n<td class=\"kb-table-data kb-table-data58_1be769-00\">\n\n<p>13<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_5e8b57-6c\">\n\n<p>Crash Recovery<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_883b28-26\">\n\n<p>Chapter 19<\/p>\n\n<\/td>\n<\/tr>\n\n<tr class=\"kb-table-row kb-table-row58_0abcde-89\">\n<td class=\"kb-table-data kb-table-data58_7383c4-2e\">\n\n<p>14<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_9060e4-fd\">\n\n<p>Application Design and Development<\/p>\n\n<\/td>\n\n<td class=\"kb-table-data kb-table-data58_86a698-ce\">\n\n<p>Chapters 8, 9<\/p>\n\n<\/td>\n<\/tr>\n<\/table><\/div>","protected":false},"excerpt":{"rendered":"<p>We encourage students to engage in these reading activities, which introduce the core concepts of database systems. These activities progress from foundational models and design principles to SQL, storage, query optimization, transactions, recovery, and practical application development.<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"template-fullwidth.php","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","footnotes":""},"class_list":["post-58","page","type-page","status-publish","hentry","post-preview"],"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"jpurdy","author_link":"https:\/\/courses.cs.colostate.edu\/cs430\/author\/jpurdy\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/courses.cs.colostate.edu\/cs430\/wp-json\/wp\/v2\/pages\/58","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.cs.colostate.edu\/cs430\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/courses.cs.colostate.edu\/cs430\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/courses.cs.colostate.edu\/cs430\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/courses.cs.colostate.edu\/cs430\/wp-json\/wp\/v2\/comments?post=58"}],"version-history":[{"count":11,"href":"https:\/\/courses.cs.colostate.edu\/cs430\/wp-json\/wp\/v2\/pages\/58\/revisions"}],"predecessor-version":[{"id":245,"href":"https:\/\/courses.cs.colostate.edu\/cs430\/wp-json\/wp\/v2\/pages\/58\/revisions\/245"}],"wp:attachment":[{"href":"https:\/\/courses.cs.colostate.edu\/cs430\/wp-json\/wp\/v2\/media?parent=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}