ÿþ <?xml version="1.0" encoding="utf-16"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"><head> <link rel="stylesheet" href="http:\\www.lcc.ctc.edu/faculty/drosi/basic2.css" type="text/css" /> <title>CIS 230 Class Page</title> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <script type="text/javascript" language="JavaScript"> function disableRightClick(e) { var message = "Right click disabled"; if(!document.rightClickDisabled) // initialize { if(document.layers) { document.captureEvents(Event.MOUSEDOWN); document.onmousedown = disableRightClick; } else document.oncontextmenu = disableRightClick; return document.rightClickDisabled = true; } if(document.layers || (document.getElementById && !document.all)) { if (e.which==2||e.which==3) { alert(message); return false; } } else { alert(message); return false; } } disableRightClick(); </script> </head> <body> <!--#include virtual="/virtual/head001" --> <table width="100%" id="header"> <tr><td>David Rosi</td></tr> <tr><td>CIS/BTEC Instructor</td></tr> <tr><td>360-442-2717</td></tr> <tr><td><a href="mailto:drosi@lcc.ctc.edu">Email: drosi@lcc.ctc.edu</a></td></tr> <tr><td><a href="../">Back</a></td></tr> </table> <h1> CIS 230 Database </h1> <h1> Lectures </h1> <h3> Fall 2006 </h3> <table width="100%"> <tr><td width="60%" id="notes"> <p> Offers further study and use of computerized database management systems. This course provides intermediate theory and practice in a disciplined approach to problem solving using a database management system in a business environment. </p> <p> The following is a list of outcomes that each student must demonstrate in order to successfully complete this course. As an intermediate level course in database development students are expected to show reproducable understanding of concepts and skills in varid database environments. </p> <ul> <li> Identify, describe, and give examples of Integrity paradigms</li> <li> Describe a database system and its components</li> <li> Describe Database security levels and issues</li> <li> Identify and describe performance issues with Databases </li> <li> Define and identify DB models</li> <li> Design and implement a Database using ER Modeling</li> <li> Design and implement SQL procedures including:</li> <li> <ul> <li>Define and Create tables</li> <li> Remove tables</li> <li> Fill tables with data</li> <li> Joins including left, right, outer, inner</li> <li> Design and implement queries to answer theme DB questions</li> </ul></li> </ul> <p> We will begin with a review of database implementations using MS Access using out of class readings and assignments. In class we will begin studying more formal methods of engineering database implementations using a formal modelling method. The core of this course is NOT database implementation in Access, we will use Access occassionally as a tool. By the end of the quarter we will be implementing databases over a live Internet connection to several database systems including Oracle, Mysql, MSsql. Our primary focus will be using MySql for the online experience. </p> <p> Our study of SQL will be based on the ANSI SQL standard and its implementation in the above mentiioned database systems. </p> </td> </tr> <tr><td> <div id="footer"> <p>Copyright &copy; 2004 <a href="/" title="David Rosi - Lower Columbia College home page.">Lower Columbia College</a> <a href="http://validator.w3.org/"><img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" /></a> </p> </div> </td></tr> </table> </body> </html>