{"id":14,"date":"2024-08-19T19:54:02","date_gmt":"2024-08-19T19:54:02","guid":{"rendered":"http:\/\/stephendavies.org\/cpsc350\/?page_id=14"},"modified":"2026-02-04T22:51:36","modified_gmt":"2026-02-05T02:51:36","slug":"readings","status":"publish","type":"page","link":"http:\/\/stephendavies.org\/cpsc350\/?page_id=14","title":{"rendered":"Readings"},"content":{"rendered":"<p>All readings are from <a href=\"http:\/\/stephendavies.org\/cpsc350\/wattEng.pdf\">Database  Design (2nd Edition)<\/a> by Watt and Eng.<\/p>\n<p><center><\/p>\n<table border=\"1\" cellpadding=\"10\" cellspacing=\"3\">\n<tbody>\n<tr>\n<th>Date<\/th>\n<th>Reading<\/th>\n<\/tr>\n<tr>\n<td align=\"center\">Jan 14<\/td>\n<td>1 &mdash; Before the advent of database systems<\/td>\n<\/tr>\n<tr>\n<td align=\"center\">Jan 21<\/td>\n<td>2 &mdash; Fundamental concepts<br \/>\n3 &mdash; Characteristics and benefits of a database<\/td>\n<\/tr>\n<tr>\n<td align=\"center\">Jan 26<\/td>\n<td>4 &mdash; Types of data models<br \/>5 &mdash; Data modeling<\/td>\n<\/tr>\n<tr>\n<td align=\"center\">Jan 28<\/td>\n<td>6 &mdash; Classification of DBMS&#8217;s<\/tr>\n<tr>\n<td align=\"center\">Feb 3<\/td>\n<td>7 &mdash; The Relational Model<\/td>\n<\/tr>\n<tr>\n<td align=\"center\">Feb 5<\/td>\n<td><span style=\"color:gray;\"><u><i>Skim<\/i><\/u> 8 &mdash; The ER model <i>(skim only; we&#8217;re using UML instead)<\/i><br \/><\/span>9 &mdash; Integrity rules and constraints<\/td>\n<\/tr>\n<p><!--\n\n\n<tr>\n\n<td align=\"center\">Feb 4<\/td>\n\n\n\n<td>11 &mdash; Functional dependencies<\/td>\n\n<\/tr>\n\n\n\n\n<tr>\n\n<td align=\"center\">Feb 5<\/td>\n\n\n\n<td>12 &mdash; Normalization<\/td>\n\n<\/tr>\n\n\n\n\n<tr>\n\n<td align=\"center\">Feb 6<\/td>\n\n\n\n<td>15 &mdash; SQL part 1<\/td>\n\n<\/tr>\n\n\n\n\n<tr>\n\n<td align=\"center\">Feb 11<\/td>\n\n\n\n<td>16 &mdash; SQL part 2<\/td>\n\n<\/tr>\n\n\n--><br \/>\n<\/table>\n<p><\/center><\/p>\n<p><!--\nvim:textwidth=99999\n--><\/p>\n","protected":false},"excerpt":{"rendered":"<p>All readings are from Database Design (2nd Edition) by Watt and Eng. Date Reading Jan 14 1 &mdash; Before the advent of database systems Jan 21 2 &mdash; Fundamental concepts 3 &mdash; Characteristics and benefits of a database Jan 26 4 &mdash; Types of data models5 &mdash; Data modeling Jan 28 6 &mdash; Classification of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-14","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/pages\/14","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14"}],"version-history":[{"count":27,"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/pages\/14\/revisions"}],"predecessor-version":[{"id":856,"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/pages\/14\/revisions\/856"}],"wp:attachment":[{"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}