<head> <meta http-equiv=Content-Type content="text/html; charset=unicode"> <title>BCIS 4620--Introduction to Database Applications</title> <style> <!-- h2 { font-size:18.0pt; font-family:"Times New Roman", "serif"; font-weight:bold; } p.MsoFooter, li.MsoFooter, div.MsoFooter { tab-stops:center 3.0in right 6.0in; font-size:12.0pt; font-family:"Times New Roman", "serif"; } a:link, span.MsoHyperlink { color:blue; text-decoration:underline; text-underline:single; } a:visited, span.MsoHyperlinkFollowed { color:blue; text-decoration:underline; text-underline:single; } p { font-size:12.0pt; font-family:"Times New Roman", "serif"; } p.MsoAcetate, li.MsoAcetate, div.MsoAcetate { font-size:8.0pt; font-family:"Tahoma", "sans-serif"; } span.Heading2Char { font-family:"Times New Roman", "serif"; font-weight:bold } span.BalloonTextChar { font-family:"Tahoma", "sans-serif"; } p.quickformat2, li.quickformat2, div.quickformat2 { text-align:center; font-size:12.0pt; font-family:"Times New Roman", "serif"; } .MsoChpDefault { font-size:10.0pt; } --> </style> <style>body { background-color: #FFFF99; } </style> </head> <body lang=EN-US link=blue vlink=blue> <p align=center style='text-align:center'><b><span style='font-size:18.0pt'>BCIS 4620--Introduction to Database Applications</span></b></p> <p align=center style='text-align:center'><b><span style='font-size:18.0pt'>Fall 2008</span></b></p> <p><b>INSTRUCTOR:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dr. Jack Becker</b></p> <p><b>OFFICE:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;338E <st1:place w:st="on"> <st1:PlaceName w:st="on"> Business <st1:PlaceType w:st="on"> Building&nbsp;</b></p> <p><b>PHONE:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;565-3113 or 565-3110 (ITDS Office)</b></p> <p><b>OFFICE HOURS:&nbsp;&nbsp;&nbsp;&nbsp;By Appointment and Tue/Thur: 2:00-3:00 p.m. &amp; 5:00-6:00 pm</b></p> <p><b>E-MAIL:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b><span style='font-family:Courier'><a href="mailto:becker@unt.edu;"><b><span style='font-family:"Times New Roman","serif"'>becker@unt.edu;</span></b></a></span><b><span style='color:black'> WEBCT <st1:place w:st="on"> Vista preferred email for group messages</span></b></p> <p><b><span style='color:black'>URL:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></b><span style='font-family:Courier'><a href="http://www.coba.unt.edu/bcis/faculty/becker/"><b><span style='font-family: &quot;Times New Roman&quot;,&quot;serif&quot;'>http://www.coba.unt.edu/ITDS/faculty/becker/bcis4620/</span></b></a></span><b><span style='color:black'> </span></b></p> <p><b><span style='color:black'>Additional course materials will be distributed in class or electronically.</span></b></p> <p><b><span style='font-size:18.0pt'>LAB TUTOR TIMES:</span></b> <a href="http://www.coba.unt.edu/lab/tutor.php"><b>Click here</b></a> </p> <p><strong><span style='font-size:20.0pt;color:red'>FINAL EXAM IS AT 6:30 PM ON Thurs Dec 11th</span></strong></p> <h2><span style='"Times New Roman"'>Practice Tests</span></h2> <p><span style='font-size:16.0pt'><a href="Exams/MidTermlPractice2007C.pdf">PRACTICE MidTerm EXAM</a> </span><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='font-size:16.0pt;color:windowtext;text-decoration:none; text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1038" src=new2.gif></span></a></p> <p><strong><span style='font-size:16.0pt;font-weight:normal'><a href="Exams/Class16_FinalPracticeRev2007C.pdf">PRACTICE FINAL EXAM </a></span></strong><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1037" src=new2.gif></span></a></p> <p><span class=style5>Additional course materials will be distributed electronically. If you see the sign </span><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1036" src="BCIS4620/new2.gif"></span></a><span class=style5>, then you can be assured that the material has been updated for the current semester</span> </p> <h2><span style='font-size:10.0pt; font-family:Symbol;font-weight:normal;'>·<span style='font:7.0pt "Times New Roman"'> </span></span><span style='"Times New Roman"'><a href="GRADES/Grades4620_Fall_2008Z.pdf">Latest Grades</a> </span><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style="text-decoration:none;text-underline:none"><img src=new2.gif alt="NEW" width=23 height=12 border=0 id="_x0000_i"></span></a></h2> <h2><span style='font-size:10.0pt; font-family:Symbol;font-weight:normal;'>·<span style='font:7.0pt "Times New Roman"'> </span></span><span style='"Times New Roman"'><a href="GRADES/Grades4620_Fall_2008Z_PF.pdf">PRE-Final Grades </a></span></h2> <h2><span style='font-size:10.0pt; font-family:Symbol;font-weight:normal;'>·<span style='font:7.0pt "Times New Roman"'> </span></span><span style='"Times New Roman"'><a href="GRADES/Grades4620_Fall_2008_SEC1_FINAL.pdf">Final Grades </a></span></h2> <h2><span style='"Times New Roman"'>Assignments</span></h2> <ul type=disc> <li style='color:red;'><span style='color:windowtext'><a href="Assignments/Assignment_01_NX_SQL_Programs.htm">Assignment 1&nbsp;</a><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1035" src=new2.gif></span></a></span> </li> </ul> <ul type=disc> <li><a href="Assignments/Assignment_02_NX_SQL_Programs.htm">Assignment 2</a> <a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1034" src=new2.gif></span></a></li> <ul type=disc> <li><span class=section1><a href="Assignments/EmpDept.zip">Assignment#2. EmpDept.Zip&nbsp;Datafile</a></span><span class=style7> </span><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><b><span style=' text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1033" src=new2.gif></span></b></a><span class=section1><b><span style='color:red'>Use this file for Homework 2</span></b></span></li> </ul> <li><span class=section1><a href="Assignments/Assignment_03_NX_SQL_Programs.htm" title="BCIS 4620 Assignment #3" target="_blank">Assignment 3</a><a href="Assignments/Assignment_03_NX_SQL_Programs.htm"></a><a href="Assignments/Assignment_03_Spring2008_NX_SQL_Programs.htm"></a> </span><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1032" src=new2.gif></span></a></li> <ul type=disc> <li><span class=section1><a href="Assignments/SQL_COBOL.exe">Assignment#3 SQL_COBOL .exe datafile</a> </span><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1031" src=new2.gif></span></a></li> </ul> <li><a href="Assignments/Assignment_04_NX_SQL_Programs.htm" title="BCIS 4620 Assignment #4" target="_blank">Assignment 4 (COBOL Bonus)</a><a href="Assignments/Assignment_04_Spring2008_NX_SQL_Programs.htm"></a> <a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1030" src=new2.gif></span></a></li> <ul type=disc> <li><a href="Assignments/SQLCOBOL4.CBL">SQLCOBOL4.CBL Template</a> <a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1029" src=new2.gif></span></a></li> </ul> </ul> <ul type=disc> <li style='color:black;'><span class=section1><span style='color:blue'><a href="Assignments/Assign5.1_Davis_NX_2008.htm">Assignment 5.1</a> </span></span> <a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style="text-decoration:none;text-underline:none"><img border=0 width=23 height=12 id="_x0000_i2" src=new2.gif></span></a></li> <li><a href="Assignments/Assignment5.2D_NX_SQL_2008.htm">Assignment 5.2</a> <a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style="text-decoration:none;text-underline:none"><img src=new2.gif alt="new" width=23 height=12 border=0 id="_x0000_i3"></span></a></li> <ul type=disc> <li style='color:blue;'><a href="tdacademic.exe"> <u6:p></u6:p> TableDesigner Software (.exe) [8 Mb]</a> <span style='color:windowtext'><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1028" src=new2.gif></span></a></span></li> </ul> <li style='color:blue;'><a href="Assignments/Assignment6A_NX_2008.htm">Assignment 6</a> </li> <ul type=disc> <li><a href="Assignments/PROJECT.htm">Project Names/Codes</a> </li> <li style='color:blue;'><a href="Assignments/SALARY.htm">Salary Data </a></li> </ul> <li style='color:blue;'><a href="Assignments/Assignment_07A_Spring2008_NX_SQL_Programs.htm">Assignment 7</a>  </li> <li><a href="Assignments/Assignment_08A_Spring2008_NX_SQL_Programs.htm">Assignment 8 </a> </li> <li style='color:blue;'><a href="Assignments/HOMEWK_09_NX_SQL_Alameda_Spring2008.htm">Assignment 9 Final Project</a> </li> <ul type=disc> <li><span class=section1><span style='color:blue'><a href="Assignments/EXECSUM.htm">EXECSUM.DOC</a> </span></span></li> </ul> </ul> <h2><span style='color:blue'>Hot List</span></h2> <ul type=disc> <li style='color:blue;'><a href="http://www.theamericanprogrammer.com/programming/sqlcodes.shtml"><span style='font-size:18.0pt'>SQLCODES from the AMERICAN PROGRAMMER&nbsp;</span></a><span style='color:windowtext'><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1027" src=new2.gif></span></a></span></li> <li style='color:blue;'><span class=MsoHyperlink><span style='font-size:18.0pt'><a href="http://myphlip.pearsoncmg.com/coolstrategy.cfm">TABLEDesigner Software [Prenhall Site]</a> </span></span><span style='color:windowtext'><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='text-decoration:none;text-underline:none'><img border=0 width=23 height=12 id="_x0000_i1026" src=new2.gif></span></a></span></li> <li><span class=MsoHyperlink><span style='font-size:18.0pt'><a href="http://www-306.ibm.com/software/data/db2/udb/support/manualsv7.html">IBM DB2 Manual Online</a> </span></span><a href="http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/Assignments/Assignment4_NX_Alameda_2004.htm"><span style='font-size:18.0pt;text-decoration:none;text-underline: none'><img border=0 width=23 height=12 id="_x0000_i1025" src=new2.gif></span></a></li> </ul> <p><b><span style='color:black'>COURSE OBJECTIVES</span></b><span style='color:black'>&nbsp;</span></p> <p><span style='color:black'>WELCOME! BCIS 4620 is an introduction to database and database management technology within the framework of a business environment. It includes the study of the analysis, design, development, and implementation of database-oriented business applications. Upon completion of the course the student will be able to define, load, and navigate a database system [IBM's DB2 as provided on the MicroFocus Net Express 4.0 with SQL for DB2 CD] using both COBOL with embedded SQL and SQL query language applications. Students will also learn to use Entity-Relationship and Semantic Object data modeling tools.</span></p> <p><b><span style='color:black'>COURSE FORMAT</span></b></p> <p><span style='color:black'>BCIS 4620 will be an intensive programming language learning experience. The amount of knowledge gained is limited only by each individual's motivation and interest. Students will study all required readings, complete several individual programming assignments, and participate in class discussions. There will be required midterm and final examinations.</span></p> <p><b><span style='color:black'>COURSE PREREQUISITES</span></b></p> <p><span style='color:black'>A grade of &quot;C&quot; or better in each previously taken ITDS course or consent of the Department. UNT ITDS GPA of 2.70.  BCIS 3610 and BCIS 3690 and all pre-business required courses.</span></p> <p><b><span style='color:black'>TEXTBOOKS &amp; SOFTWARE REQUIRED</span></b></p> <p><span style='color:black'>(K) Kroenke, David M., <b><i>Database</i> <i>Processing</i>: <i>Fundamentals</i>, <i>Design</i>, <i>and</i> <i>Implementation</i></b>, 10th Edition, Prentice Hall, 2007.</span></p> <p><span style='color:black'>(CD) <b><i>MicroFocus Net Express Version 5.0/5.1 UE with SQL for DB2.</i></b> This CD was purchased in </span>your BCIS 3620 class.  You may get a  free copy of Version 5.0 or 5.1 (for MS Vista OS). Copies of this software may be downloaded:<u></u></p> <p><u><span style='font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;; color:blue'>http://microfocus.com/Resources/Communities/Academic/shop/index.asp</span></u></p> <p><b><span style='color:black'>OTHER REFERENCES</span></b></p> <p><b><span style='color:black'>IBM Manuals &amp; Reference Guides</span></b><span style='color:black'> (<b>UNT CD ROM Library on the COBA network</b>). </span></p> <p><b><span style='color:black'>ASSIGNMENTS and OTHER COMPUTING AIDS</span></b></p> <br clear=all style='page-break-before:always'> <p><b><span style='color:black'>COURSE WEBSITE</span></b></p> <p><span style='color:black'>WEBCT will be the primary sources for communication and distribution of materials. Additional materials for this class may also be found at my course home page on the ITDS Department website:</span></p> <p><span style='font-family:Courier'><a href="http://www.coba.unt.edu/bcis/faculty/becker/bcis4620"><b><span style='font-family:"Times New Roman","serif"'>http://www.coba.unt.edu/ITDS/faculty/becker/bcis4620</span></b></a></span></p> <p><span style='color:black'>You have authorization to use COBA microcomputer and terminal labs to do your class assignments. </span></p> <p><span style='color:black'>A number of course-related datasets will be made available through the course website.</span></p> <p><span style='color:black'>Specialized tutorial assistance will be provided for students registered in this class. The location, dates, and times for this service will be announced in class and also on the <b>Class website. </b>The tutor s primary responsibility is debugging assistance. Each student is responsible fr the successful completion of all assignments. The tutor is NOT responsible for incorrect interpretations of assignment instructions.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></p> <p align=center style='text-align:center'><b><span style='font-size:14.0pt; color:black'>Schedule of Assignments</span></b></p> <table border=0 cellspacing=0 cellpadding=0> <tr> <td width="46%" valign=top><p><b><u><span style='color:black'>ASSIGNMENTS/EXAMS</span></u></b></p></td> <td width="14%" valign=top><p><b><span style='color:black'>POINTS</span></b></p></td> <td width="13%" valign=top><p><b><span style='color:black'>BONUS</span></b></p></td> <td width="27%" valign=top><p><b><span style='color:black'>Comments</span></b></p></td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>H1: SQL Examples</span></p></td> <td width="14%" valign=top><p align=right style='text-align:right'><span style='font-size:11.0pt; color:black'>10</span></p></td> <td width="13%" valign=top><div align="left"></div></td> <td width="27%" valign=top>&nbsp;</td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>H2: SQL Case</span></p></td> <td width="14%" valign=top><p align=right style='text-align:right'><span style='font-size:11.0pt; color:black'>10</span></p></td> <td width="13%" valign=top><div align="left"></div></td> <td width="27%" valign=top>&nbsp;</td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>H3: SQL/COBOL Examples</span></p></td> <td width="14%" valign=top><p align=right style='text-align:right'><span style='font-size:11.0pt; color:black'>10</span></p></td> <td width="13%" valign=top><p style='text-align:right'><span style='font-size:11.0pt; color:black'>10</span></p></td> <td width="27%" valign=top>&nbsp;</td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>BONUS5: (FILE OUTFILE1 or 2?)</span></p></td> <td width="14%" valign=top>&nbsp;</td> <td width="13%" valign=top><p align=left style='text-align:right'><span style='font-size:11.0pt; color:black'>5 (opt)</span></p></td> <td width="27%" valign=top>&nbsp;</td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>H4: SQL/COBOL Queries</span></p></td> <td width="14%" valign=top>&nbsp;</td> <td width="13%" valign=top><p align=left style='text-align:right'><span style='font-size:11.0pt; color:black'>10</span></p></td> <td width="27%" valign=top>&nbsp;</td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>H5: SQL and TableDesigner</span></p></td> <td width="14%" valign=top><p align=right style='text-align:right'><span style='font-size:11.0pt; color:black'>30</span></p></td> <td width="13%" valign=top><div align="left"></div></td> <td width="27%" valign=top>&nbsp;</td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>H6: Database Design/Table Creation</span></p></td> <td width="14%" valign=top><p align=right style='text-align:right'><span style='font-size:11.0pt; color:black'>40</span></p></td> <td width="13%" valign=top><div align="left"></div></td> <td width="27%" valign=top>&nbsp;</td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>H7: SQL Table loads/queries</span></p></td> <td width="14%" valign=top><p align=right style='text-align:right'><span style='font-size:11.0pt; color:black'>40</span></p></td> <td width="13%" valign=top><div align="left"></div></td> <td width="27%" valign=top>&nbsp;</td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>H8: SQL Updates</span></p></td> <td width="14%" valign=top><p align=right style='text-align:right'><span style='font-size:11.0pt; color:black'>20</span></p></td> <td width="13%" valign=top><div align="left"></div></td> <td width="27%" valign=top>&nbsp;</td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>FP: Final Case Project Folder </span></p></td> <td width="14%" valign=top><p align=right style='text-align:right'><span style='font-size:11.0pt; color:black'>100</span></p></td> <td width="13%" valign=top><p align=left style='text-align:right'><span style='font-size:11.0pt; color:black'>&nbsp;25</span></p></td> <td width="27%" valign=top><p><span style='font-size:11.0pt;color:black'>Extra requirements</span></p></td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>Early presentation Bonus (optional)</span></p></td> <td width="14%" valign=top>&nbsp;</td> <td width="13%" valign=top><p align=left style='text-align:right'><span style='font-size:11.0pt; color:black'>10 (opt)</span></p></td> <td width="27%" valign=top><p><span style='font-size:11.0pt;color:black'>First 25 volunteers basis</span></p></td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>Midterm Exam</span></p></td> <td width="14%" valign=top><p align=right style='text-align:right'><span style='font-size:11.0pt; color:black'>120</span></p></td> <td width="13%" valign=top><p align=left style='text-align:right'><span style='font-size:11.0pt; color:black'>&nbsp;10</span></p></td> <td width="27%" valign=top><p><span style='font-size:11.0pt;color:black'>Bonus questions</span></p></td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>Final Exam</span></p></td> <td width="14%" valign=top><p align=right style='text-align:right'><span style='font-size:11.0pt; color:black'>120</span></p></td> <td width="13%" valign=top><p align=left style='text-align:right'><span style='font-size:11.0pt; color:black'>&nbsp;10 (opt)</span></p></td> <td width="27%" valign=top><p><span style='font-size:11.0pt;color:black'>Bonus questions</span></p></td> </tr> <tr> <td width="46%" valign=top><p><span style='font-size:11.0pt;color:black'>Special Course Innovation Awards;</span></p> <p><span style='font-size:11.0pt;color:black'>For special help to other students or faculty </span></p></td> <td width="14%" valign=top>&nbsp;</td> <td width="13%" valign=top><p align=left style='text-align:right'><span style='font-size:11.0pt; color:black'>20 cumulative maximum</span></p></td> <td width="27%" valign=top><p><span style='font-size:11.0pt;color:black'>Points based on overall contribution to course</span></p></td> </tr> <tr> <td width="46%" valign=top><p><b><span style='color:black'>Total/ Bonus:</span></b></p></td> <td width="14%" valign=top><p align=right style='text-align:right'><b><span style='color:black'>&nbsp;&nbsp;&nbsp;500 </span></b></p></td> <td width="13%" valign=top><p align=left style='text-align:right'><b><span style='color:black'>90</span></b></p></td> <td width="27%" valign=top><p><b><span style='color:black'>Bonus points at instructors discretion</span></b></p></td> </tr> </table> <p><b><span style='color:black'>BONUS Assignments (<i>at instructors option</i>). </span></b><span style='color:black'>Bonus assignments will always be authorized at the complete discretion of the instructor. When offered they will always be made available to every student in the class. While most bonuses will be first offered during class, please, check you course email for these offers, also.</span></p> <p><b><span style='color:black'>&nbsp;Assignment Delivery Instructions: </span></b></p> <p><span style='color:black'>&nbsp;&nbsp;All assignments are to be placed in the Instructor s Project Cabinet in the ITDS Suite on the 3<sup>rd</sup> floor. <b>Projects must be in the cabinet 5 minutes prior to your class meeting time on the date the assignment is due</b>. The cabinet will be locked at that time. Any projects turned in after that time will be graded as late. See late project penalties in Course Polices below. Projects will be returned and placed back in the cabinet when they are graded. You will be notified by email when they may be picked up. Please be careful to not remove or disturb other students project folders.</span></p> <p><b><span style='color:black'>COURSE POLICIES </span></b></p> <p><span style='color:black'>1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;You should complete all reading assignments prior to class. Written assignments are due, and will be turned into the instructor, BEFORE the beginning of class (IN THE STORAGE CABINENT OUTSIDE 338E IN THE ITDS FACULTY SUITE AREA; THIS CABINENT WILL BE LOCKED AT 2:00 pm) on the due date.<b> Late assignments will be penalized (10% for first day; 20% each additional day late), even if only a few minutes late. Repeated late assignments will NOT be accepted. Incomplete work will receive partial credit. Missing work will receive a grade of zero.</b></span></p> <p><span style='color:black'>2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The grade of &quot;I&quot; (Incomplete) is not given except for rare and very unusual emergencies, as per the General Catalog.</span></p> <p><span style='color:black'>3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Class roll will be taken at the beginning of the first two classes. Class attendance is your responsibility. Students should be in their seats before class is scheduled to begin. Do not come into the classroom after class has started. If you know you must leave a class session early, please alert the instructor and sit near an exit.</span></p> <p><span style='color:black'>4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Missed exams for validated reasons of illness or death will be made up with a comprehensive exam at the end of the semester. This exam, if needed, will be scheduled at the instructor's convenience during final exam week. These rescheduled exams do not participate in any curve that may have been applied to the regularly scheduled exam.</span></p> <p><span style='color:black'>5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Students will adhere to the highest professional and ethical standards. Plagiarism of any form<b> will not be tolerated</b>. Software plagiarism, piracy and theft should be understand by senior level ITDS majors. All submitted assignments and exams will consist of only the student's own work. Obtaining the assistance of or copying the work of others is expressly prohibited. Violators of this policy will be prosecuted to the maximum extent allowed by University policy. An assignment of a final course grade of &quot;F&quot; and referral to the Dean of Students for disciplinary action can be expected. <b>See Ethics Statement Attached.</b></span></p> <p><span style='color:black'>6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Students will use structured programming procedures. Students may use the report writer feature for all COBOL programs. Students will use MF COBOL. All supporting documentation will be typed.</span></p> <p><span style='color:black'>7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;All submitted work will meet or exceed the standards expected of highly prepared and motivated information systems professionals. Students will be graded on programming style, format, and program accuracy. Students will first be given assignment and field specification, they will use their own test data to do unit and system testing. Production data will be made available near the time the assignment is due. In some cases, the instructor may not make production data available but will execute the student's programs against the production data.</span></p> <p><span style='color:black'>8.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;It is the student's responsibility to satisfy all the requirements of this course as specified by this course outline, the instructor, the academic calendar, and University regulations. Hence, ignorance of class or University requirements will not be accepted as an excuse.</span></p> <p><span style='color:black'>9.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The instructor, tutors and teaching assistants will not debug student programming errors. We will, however, answer specific questions about course topics.</span></p> <p><span style='color:black'>10.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;In class presentations will be evaluated for quality of communication skills as well as technical quality. When making a presentation, assume that you are &quot;selling&quot; your system to the customer. See PRESENT.DOC on website.</span></p> <p><b><span style='color:black'>AMERICANS WITH DISABILITIES ACT INFORMATION</span></b></p> <p><b><span style='color:black'>The <st1:place w:st="on"> <st1:PlaceType w:st="on"> College of <st1:PlaceName w:st="on"> Business Administration complies with the Americans with Disabilities Act in making reasonable accommodation for qualified students with disability.</span></b></p> <p><b><span style='color:black'>If you have an established disability as defined in the Americans with Disabilities Act and would like to request accommodation please see me as soon as possible.</span></b></p> <br clear=all style='page-break-before:always'> <p align=center style=' text-align:center'><b><span style='font-size:15.0pt; color:navy'>BCIS 4620 -- Fall 2008 SEMESTER SCHEDULE [Rev: 8/30/2008]</span></b></p> <table width="100%" border=0 cellpadding=0 cellspacing=0 bordercolor="#000000" bgcolor="#66FFFF"> <tr> <td width="10%" valign=top><p><b><u><span style='font-size:11.0pt;color:blue'>WEEK</span></u></b></p></td> <td width="11%" valign=top><p><b><u><span style='font-size:11.0pt;color:blue'>DATE</span></u></b></p></td> <td width="79%" colspan=2 valign=top><p><b><u><span style='font-size:11.0pt;color:blue'>TOPIC/ ASSIGNMENT/ PROJECT DUE</span></u></b><span style='font-size:11.0pt;color:blue'>/<b>K:Kroenke;CD:NX/DB2; CN:Notes</b></span></p></td> </tr> <tr> <td width="10%" valign=top><p align=center style='text-align:center'><b><span style='font-size:11.0pt'>1</span></b></p></td> <td width="11%" valign=top><p><span style='font-size:11.0pt;color:black'>Aug 28</span></p></td> <td width="79%" colspan=2 valign=top><p><span style='font-size:11.0pt;color:black'>Introduction to Course, SQL, Data Structures: <b>K:</b> Chapter 1 &amp; App C; <b>CD: NX</b> Tour</span></p></td> </tr> <tr> <td width="10%" valign=top><p align=center style='text-align:center'><b><span style='font-size:11.0pt; color:black'>2</span></b></p></td> <td width="11%" valign=top><p><span style='font-size:11.0pt;color:black'>Sep 4</span></p></td> <td width="79%" colspan=2 valign=top><p><span style='font-size:11.0pt;color:black'>Introduction to NX with SQL,, and SQL Language. <b>K:</b> Ch 2 &amp; 7 (SQL)<b>; CD</b>: (NX) IDE </span></p></td> </tr> <tr> <td width="10%" valign=top><p align=center style='text-align:center'><b><span style='font-size:11.0pt; color:black'>3</span></b></p></td> <td width="11%" valign=top><p><span style='font-size:11.0pt;color:black'>Sep 11</span></p></td> <td width="79%" colspan=2 valign=top><p><span style='font-size:11.0pt;color:black'>Data Modeling: Relational Models &amp; Normalization; (NX) IDE;. <b>K:Ch 3 &amp; 4; CD: Ch2</b></span></p></td> </tr> <tr> <td width="10%" valign=top>&nbsp;</td> <td width="11%" valign=top>&nbsp;</td> <td width="14%" valign=top><p><b><span style='font-size:11.0pt;color:black'>Due: H1</span></b></p></td> <td width="65%" valign=top><p><b><span style='font-size:11.0pt;color:black'>&nbsp;SQL Tutorial Examples</span></b></p></td> </tr> <tr> <td width="10%" valign=top><p align=center style='text-align:center'><b><span style='font-size:11.0pt; color:black'>4</span></b></p></td> <td width="11%" valign=top><p><b><span style='font-size:11.0pt;color:black'>Sep 18</span></b></p></td> <td width="79%" colspan=2 valign=top><p><span style='font-size:11.0pt;color:black'>Data Modeling: ERDs; Relational Model and Normalization; <b>K: Chapter 5</b></span></p></td> </tr> <tr> <td width="10%" valign=top>&nbsp;</td> <td width="11%" valign=top>&nbsp;</td> <td width="14%" valign=top><p><b><span style='font-size:11.0pt;color:black'>Due: H2</span></b></p></td> <td width="65%" valign=top><p><b><span style='font-size:11.0pt;color:black'>SQL Examples</span></b></p></td> </tr> <tr> <td width="10%" valign=top><p align=center style='text-align:center'><b><span style='font-size:11.0pt; color:black'>5</span></b></p></td> <td width="11%" valign=top><p><b><span style='font-size:11.0pt;color:black'>Sep 25</span></b></p></td> <td width="79%" colspan=2 valign=top><p><span style='font-size:11.0pt;color:black'>Semantic Object Model &amp; Normalization. <b>K: Appx. E; CD: &amp; CN: TBA</b></span></p></td> </tr> <tr> <td width="10%" valign=top>&nbsp;</td> <td width="11%" valign=top>&nbsp;</td> <td width="14%" valign=top><p><b><span style='font-size:11.0pt;color:black'>Due: H3</span></b></p></td> <td width="65%" valign=top><p><b><span style='font-size:11.0pt;color:black'>SQL Case</span></b></p></td> </tr> <tr> <td width="10%" valign=top><p align=center style='text-align:center'><b><span style='font-size:11.0pt; color:black'>6</span></b></p></td> <td width="11%" valign=top><p><b><span style='font-size:11.0pt;color:black'>Oct 2</span></b></p></td> <td width="79%" colspan=2 valign=top><p><span style='font-size:11.0pt;color:black'>Database Design, ERDs &amp; SOMs, SQL Applications. <b>K: Chapter 6; CD&amp; CN: TBA</b></span></p></td> </tr> <tr> <td width="10%" valign=top>&nbsp;</td> <td width="11%" valign=top>&nbsp;</td> <td width="14%" valign=top><p><b><span style='color:black'>Due: H4</span></b></p></td> <td width="65%" valign=top><p><b><span style='color:black'>H4: COBOL w/SQL Queries</span></b></p></td> </tr> <tr> <td width="10%" valign=top><p align=center style='text-align:center'><b><span style='font-size:11.0pt; font-family:Courier;color:navy'>7</span></b></p></td> <td width="11%" valign=top><p><b><span style='font-size:11.0pt;color:black'>Oct 9</span></b></p></td> <td width="79%" colspan=2 valign=top><p><span style='color:black'>SQL Foundations &amp; DB Application Redesign. <b>K: Chaps. 7 &amp; 8; Exam Preview</b>.</span></p></td> </tr> <tr> <td width="10%" valign=top>&nbsp;</td> <td width="11%" valign=top>&nbsp;</td> <td width="14%" valign=top><p><b><span style='font-size:11.0pt;color:black'>Due: H5</span></b></p></td> <td width="65%" valign=top><p><b><span style='font-size:11.0pt;color:black'>H5: SQL Applications &amp; SOM</span></b></p></td> </tr> <tr> <td width="10%" valign=top><p align=center style='text-align:center'><b><span style='color:red'>8 </span></b></p></td> <td width="11%" valign=top><p><b><span style='color:red'>Oct 16</span></b></p></td> <td width="79%" colspan=2 valign=top><p><b><span style='color:red'>MID-TERM EXAM (K: Chaps. 1-7; CD: TBA; CN: TableDesigner )</span></b></p></td> </tr> <tr> <td width="10%" valign=top><p align=center style='text-align:center'><b>9</b></p></td> <td width="11%" valign=top><p><b><span style='color:black'>Oct 23</span></b></p></td> <td width="79%" colspan=2 valign=top><p><span style='font-size:11.0pt;color:black'>Review Exam; Menu Systems; and