{\rtf1\ansi\ansicpg1252\uc1 \deff1\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\panose 02020603050405020304}Times New Roman;}{\f1\fswiss\fcharset0\fprq2{\*\panose 020b0604020202020204}Arial;}
{\f16\fnil\fcharset0\fprq2{\*\panose 00000000000000000000}Uniform Condensed Light;}{\f17\fnil\fcharset0\fprq2{\*\panose 00000000000000000000}Uniform Condensed;}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;
\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;
\red128\green128\blue128;\red192\green192\blue192;}{\stylesheet{\li720\widctlpar\adjustright \f1\fs20\cgrid \snext0 Normal;}{\s1\li720\widctlpar\adjustright \b\f1\fs28\cgrid \sbasedon0 \snext0 heading 1;}{\s2\li720\sb240\sa160\widctlpar\adjustright 
\i\f1\cgrid \sbasedon0 \snext0 heading 2;}{\s3\li720\widctlpar\tx1800\adjustright \b\f1\fs18\cgrid \sbasedon0 \snext3 heading 3;}{\*\cs10 \additive Default Paragraph Font;}{\s15\widctlpar\tqr\tx10080\adjustright \i\f1\fs18\cgrid \sbasedon0 \snext15 
footer;}{\s16\fi-360\li360\sb120\sa60\sl260\slmult0\widctlpar\adjustright \f16\fs22\cgrid \sbasedon0 \snext16 CL;}{\s17\widctlpar\tqc\tx4320\tqr\tx8640\adjustright \i\f1\fs16\cgrid \sbasedon0 \snext17 header;}{\s18\sb120\sa60\sl260\slmult0
\widctlpar\adjustright \f16\fs22\cgrid \sbasedon0 \snext18 CR;}{\s19\sb120\sa60\sl260\slmult0\widctlpar\adjustright \b\f17\fs22\cgrid \sbasedon0 \snext19 SB;}{\s20\qc\sb60\sa60\widctlpar\adjustright \f1\fs20\cgrid \sbasedon0 \snext20 NFColEntry;}{
\s21\qc\li18\sb60\widctlpar\adjustright \b\f1\fs20\cgrid \sbasedon0 \snext21 NFColHead;}}{\info{\title Model 2000 Master Course Outline}{\author Carrlee}{\operator Robert Voelcker}{\creatim\yr1999\mo7\dy12\hr8\min33}{\revtim\yr1999\mo9\dy16\hr13\min28}
{\printim\yr1998\mo10\dy22\hr10\min43}{\version3}{\edmins1}{\nofpages3}{\nofwords435}{\nofchars2484}{\*\company Ziff-Davis Education}{\nofcharsws0}{\vern89}}\margl1080\margr1080\margt1555\margb1080 
\facingp\widowctrl\ftnbj\aenddoc\sprsspbf\lytprtmet\hyphcaps0\formshade\viewkind4\viewscale100\pgbrdrhead\pgbrdrfoot \fet0\sectd \psz1\linex0\headery504\footery504\endnhere\titlepg\sectdefaultcl {\headerl \pard\plain \s17\li720\widctlpar
\tqc\tx4320\tqr\tx8640\adjustright \i\f1\fs16\cgrid {\field{\*\fldinst { REF cname  \\* CHARFORMAT }}{\fldrslt {<Course Title>}}}{
\par }}{\headerr \pard\plain \s17\li720\widctlpar\tqr\tx10080\adjustright \i\f1\fs16\cgrid {\tab Course Outline
\par }}{\footerl \pard\plain \s15\li720\widctlpar\tqr\tx10080\adjustright \i\f1\fs18\cgrid {Page }{\field{\*\fldinst { PAGE  \\* CHARFORMAT }}{\fldrslt {\lang1024 2}}}{
\par }}{\footerr \pard\plain \s15\li720\widctlpar\tqr\tx10080\adjustright \i\f1\fs18\cgrid {\tab Page }{\field{\*\fldinst { PAGE  \\* CHARFORMAT }}{\fldrslt {\lang1024 3}}}{
\par }}{\headerf \pard\plain \s17\li720\widctlpar\tqc\tx4320\tqr\tx8640\adjustright \i\f1\fs16\cgrid {
\par }}{\footerf \pard\plain \s15\li720\widctlpar\tqr\tx10080\adjustright \i\f1\fs18\cgrid {\tab Page }{\field{\*\fldinst {PAGE \\* CHARFORMAT}}{\fldrslt {\lang1024 1}}}{
\par }}{\*\pnseclvl1\pnucrm\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl2\pnucltr\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl3\pndec\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl4\pnlcltr\pnstart1\pnindent720\pnhang{\pntxta )}}
{\*\pnseclvl5\pndec\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl6\pnlcltr\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl7\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl8
\pnlcltr\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl9\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}\pard\plain \li720\widctlpar\adjustright \f1\fs20\cgrid {\field{\*\fldinst {\v 
set cname "Relational Database Design: A Practical Approach"}}{\fldrslt {\v\lang1024 {\*\bkmkstart cname}Relational Database Design: A Practical Approach{\*\bkmkend cname}}}}{\v 
\par }{\field{\*\fldinst {\v set cnum "076 410"}}{\fldrslt {\v\lang1024 {\*\bkmkstart cnum}076 410{\*\bkmkend cnum}}}}{\v 
\par }{\field{\*\fldinst {\v set svernum ""}}{\fldrslt {\v\lang1024 {\*\bkmkstart svernum}{\*\bkmkend svernum} }}}{\v 
\par }{\field{\*\fldinst {\v set clength "1"}}{\fldrslt {\v\lang1024 {\*\bkmkstart clength}1{\*\bkmkend clength}}}}{\v 
\par }{\field{\*\fldinst {\v set pgmname ""}}{\fldrslt {\v\lang1024 {\*\bkmkstart pgmname}{\*\bkmkend pgmname} }}}{\v 
\par }{\field{\*\fldinst {\v set addinfo ""}}{\fldrslt {\v\lang1024 {\*\bkmkstart addinfo}{\*\bkmkend addinfo} }}}{\v 
\par }{\field{\*\fldinst {\b\fs28  REF cname \\* CHARFORMAT }}{\fldrslt {\b\fs28 Relational Database Design: A Practical Approach}}}{\b\fs28  }{\b\fs28\cf1\cgrid0 (Millennium Design)}{\b\fs28 
\par }{
\par }{\b\fs24 Course specifications
\par }{Course number: }{\field{\*\fldinst { REF cnum \\* CHARFORMAT }}{\fldrslt {076 410}}}{
\par Software version number: }{\field\fldedit{\*\fldinst { REF svernum \\* CHARFORMAT }}{\fldrslt }}{
\par Course length: }{\field{\*\fldinst { REF clength \\* CHARFORMAT }}{\fldrslt {1}}}{ day
\par 
\par }\pard \li720\sl240\slmult0\widctlpar\adjustright {\b\fs24\cf1 Hardware/software required to run this course
\par }{\cf1 The conceptual content of this course in not specific to any software application. Microsoft Access 97 or Access 2000 is needed to perform the tasks in the lessons pertaining to queries.
\par 
\par }{\b\fs24\cf1 Course description
\par 
\par }{\b\cf1 Overview:}{\cf1  Students will learn the general principles involved in designing a database that complies with the relational database model.
\par 
\par }{\b\cf1 Prerequisites:}{\cf1  Some familiarity with data tables and basic knowledge of how to create queries in Access 97 or Access 2000.
\par 
\par }{\b\cf1 Delivery method:}{\cf1  Instructor-led, group-paced, classroom-delivery learning model with structured hands-on and minds-on activities.
\par 
\par }{\b\cf1 Benefits:}{\cf1  Students will learn how to correctly design tables for use in a relational database application.
\par 
\par }{\b\cf1 Target student:}{\cf1  Students enrolling in this course should have a need to design or modify the design of tables to be used in a relational database management system. 
\par 
\par }\pard \li720\widctlpar\adjustright {\page }{\field\flddirty{\*\fldinst {\b\fs28  REF cname \\* CHARFORMAT }}{\fldrslt {\b\fs28 Relational Database Design: A Practical Approach}}}{\b\fs28 
\par 
\par }\pard \li720\sl240\slmult0\widctlpar\adjustright {\b\fs24\cf1 Performance-based objectives
\par }{\cf1 Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
\par 
\par }\pard \fi-360\li1440\sl240\slmult0\widctlpar\adjustright {\cf1 *\tab Be conversant with the terminology used in reference to relational databases and be familiar with the design process.
\par *\tab Identify data as fields, group fields into tables, select key fields, and identify table relationships.
\par *\tab Identify data problems and apply data normalization techniques to solve them.
\par *\tab Use referential integrity and other data integrity techniques to support the accuracy of data in the database.
\par *\tab Use criteria and operators and perform appropriate table joins in queries.
\par *\tab Understand basic SQL queries and techniques for improving the performance of queries.
\par }\pard \li720\sl240\slmult0\widctlpar\adjustright {\cf1 
\par \page }{\field\flddirty{\*\fldinst {\b\fs28  REF cname \\* CHARFORMAT }}{\fldrslt {\b\fs28 Relational Database Design: A Practical Approach}}}{\b\fs28 
\par }{\b\fs24\cf1 Course content
\par 
\par }{\b\cf1 Lesson 1: Introduction to Relational Databases
\par }\pard \li1080\widctlpar\adjustright {The Basics of Relational Databases
\par Planning the Database
\par }\pard \li1440\sl240\slmult0\widctlpar\adjustright {\cf1 
\par }\pard \li720\sl240\slmult0\widctlpar\adjustright {\b\cf1 Lesson 2: Designing Tables
\par }\pard \li1080\widctlpar\adjustright {Deciding on Tables and Fields
\par Selecting Primary Key Fields
\par Identifying Table Relationships
\par More on Keys and Relationships
\par }\pard \li1440\sl240\slmult0\widctlpar\adjustright {\cf1 
\par }\pard \li720\sl240\slmult0\widctlpar\adjustright {\b\cf1 Lesson 3: Data Normalization
\par }\pard \li1080\widctlpar\adjustright {Solving Data Problems
\par Higher Normal Forms
\par 
\par }\pard \li720\sl240\slmult0\widctlpar\adjustright {\b\cf1 Lesson 4: Data Integrity
\par }\pard \li1080\widctlpar\adjustright {Referential Integrity
\par Field-level Integrity
\par Table-level Integrity
\par Reviewing and Finalizing the Database Design
\par 
\par }\pard \li720\sl240\slmult0\widctlpar\adjustright {\b\cf1 Lesson 5: Query Basics
\par }\pard \li1080\widctlpar\adjustright {Performing Queries
\par Multiple Table Queries
\par 
\par }\pard \li720\sl240\slmult0\widctlpar\adjustright {\b\cf1 Lesson 6: More on Queries
\par }\pard \li1080\widctlpar\adjustright {Other Types of Queries
\par SQL
\par Optimizing Query Performance
\par 
\par }\pard \li720\sl240\slmult0\widctlpar\adjustright {\b\cf1 Appendix: Additional resources
\par }\pard \li1080\widctlpar\adjustright {\b\cf1 
\par }}