toshiki-notebook/assets/academic_cis105_cis105-l18-lecture-note.md.ea23a56a.js

import{_ as i}from"./chunks/PageInfo.vue_vue_type_script_setup_true_lang.65c6b98c.js";import{_ as s,o as l,c as r,k as e,a as o,E as n,O as u}from"./chunks/framework.c989bd33.js";import"./chunks/commonjsHelpers.725317a4.js";const q=JSON.parse('{"title":"CIS105: Computer Applications & Information Systems Lect. 18","description":"","frontmatter":{},"headers":[],"relativePath":"academic/cis105/cis105-l18-lecture-note.md","filePath":"academic/cis105/cis105-l18-lecture-note.md","lastUpdated":1726418622000}'),c={name:"academic/cis105/cis105-l18-lecture-note.md"};function d(m,a,p,h,b,f){const t=i;return l(),r("div",null,[a[0]||(a[0]=e("h1",{id:"cis105-computer-applications-information-systems-lect-18",tabindex:"-1"},[o("CIS105: Computer Applications & Information Systems Lect. 18 "),e("a",{class:"header-anchor",href:"#cis105-computer-applications-information-systems-lect-18","aria-label":'Permalink to "CIS105: Computer Applications & Information Systems Lect. 18"'},"​")],-1)),n(t,{readTime:"1",words:"106"}),a[1]||(a[1]=u('<h2 id="chapter-18-databases" tabindex="-1">Chapter 18: Databases <a class="header-anchor" href="#chapter-18-databases" aria-label="Permalink to &quot;Chapter 18: Databases&quot;">​</a></h2><blockquote><p>Housekeeping:</p><ul><li>Zoom Office Hours: Tuesday April 23rd and 25th, <strong>no class starting today.</strong></li></ul></blockquote><h3 id="_18-1-datase-overview" tabindex="-1">18.1: Datase Overview <a class="header-anchor" href="#_18-1-datase-overview" aria-label="Permalink to &quot;18.1: Datase Overview&quot;">​</a></h3><ul><li>Column = Field <ul><li>AKA attributes</li></ul></li><li>Tables hold database data</li><li>DBMS</li><li>Oracle</li></ul><h3 id="_18-2-database-structure" tabindex="-1">18.2: Database Structure <a class="header-anchor" href="#_18-2-database-structure" aria-label="Permalink to &quot;18.2: Database Structure&quot;">​</a></h3><ul><li>Entity Relationship Modeling (ERM): a database-modeling method used to construct a theoretical and conceptual representation of data to produce a schema. <ul><li>Tables</li><li>Reports</li><li>Queries</li><li>Forms</li></ul></li><li>DBAs still need to know the business.</li></ul><h3 id="_18-3-business-database-advantages" tabindex="-1">18.3: Business Database Advantages <a class="header-anchor" href="#_18-3-business-database-advantages" aria-label="Permalink to &quot;18.3: Business Database Advantages&quot;">​</a></h3><ul><li>Data Validation</li><li>No Errors + No Repeats = Data Integrity</li><li>GIGO: Garbage-in-Garbage-Out</li></ul><h3 id="_18-4-structured-query-language" tabindex="-1">18.4: Structured Query language <a class="header-anchor" href="#_18-4-structured-query-language" aria-label="Permalink to &quot;18.4: Structured Query language&quot;">​</a></h3><ul><li>Most widely used query language</li><li>SQL Clauses for updating fields: <ul><li><code>APPEND</code></li><li><code>DELETE</code></li><li><code>UPDTE</code></li></ul></li></ul>',10))])}const y=s(c,[["render",d]]);export{q as __pageData,y as default};