{"id":16,"date":"2020-08-06T21:03:45","date_gmt":"2020-08-06T21:03:45","guid":{"rendered":"https:\/\/enter77.ius.edu\/cjkimmer\/?page_id=16"},"modified":"2020-11-29T00:01:39","modified_gmt":"2020-11-29T00:01:39","slug":"info-i308-contents","status":"publish","type":"page","link":"https:\/\/enter77.ius.edu\/cjkimmer\/info-i308-contents\/","title":{"rendered":"INFO-I308 Contents"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Overview<\/h3>\n\n\n\n<p>The name of INFO-I308 is Information Representation, which is not very informative. In computing, important information is stored in a <strong>database<\/strong>, and I308 is an introduction to how that process unfolds.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Table of Contents<\/h3>\n\n\n\n<ol><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/persistence-and-databases\/\">Persistence and Databases<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/records-and-data-models\/\">Records, Data Models, and Relationships<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/tables-and-sql\/\">Tables and an Intro. to SQL<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/inner-joins\/\">More than one table in a query<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/customizing-the-result-set\/\">Sorting Results and Calculating from Data<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/the-relational-model\/\">The Relational Model<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/entity-relationship-diagrams\/\">Conceptual Data Models and ERDs in Chen notation<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/erds-to-schemas\/\">Converting ERDs to Relational Database Schemas<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/schema-refinement\/\">Normal Forms &#8212; being precise about redundancy<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/queries-with-null-values\/\">Queries with NULL values<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/nested-queries\/\">Nested queries<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/nested-queries-using-in\/\">The IN operator and Intersection queries<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/non-participation-queries\/\">Non-participation queries<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/self-joins\/\">Self-join queries<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/aggregation-queries\/\">Aggregation queries<\/a><\/li><li><a href=\"https:\/\/enter77.ius.edu\/cjkimmer\/data-warehousing\/\">Data Warehousing: OLAP Data Cubes and Star Schemas<\/a><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Overview The name of INFO-I308 is Information Representation, which is not very informative. In computing, important information is stored in a database, and I308 is an introduction to how that &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"featured_image_src":null,"featured_image_src_square":null,"_links":{"self":[{"href":"https:\/\/enter77.ius.edu\/cjkimmer\/wp-json\/wp\/v2\/pages\/16"}],"collection":[{"href":"https:\/\/enter77.ius.edu\/cjkimmer\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/enter77.ius.edu\/cjkimmer\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/enter77.ius.edu\/cjkimmer\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/enter77.ius.edu\/cjkimmer\/wp-json\/wp\/v2\/comments?post=16"}],"version-history":[{"count":17,"href":"https:\/\/enter77.ius.edu\/cjkimmer\/wp-json\/wp\/v2\/pages\/16\/revisions"}],"predecessor-version":[{"id":490,"href":"https:\/\/enter77.ius.edu\/cjkimmer\/wp-json\/wp\/v2\/pages\/16\/revisions\/490"}],"wp:attachment":[{"href":"https:\/\/enter77.ius.edu\/cjkimmer\/wp-json\/wp\/v2\/media?parent=16"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}