Week  Beginning		Lecture - Mondays	Lab - Wednesdays
1/7/2002	Introductions, Course Syllabus, Course Website  Navigating the Online IST 210 course content Features of a DBMS Reading Assignment: Online IST 210 Topic 1			Investigate:       Online IST 210 Course Web Site         Angel Course Communication Site        Classic Sales Sample Data Base Online Discussion activity #1 Introductions
1/14/2002	Data Base  Fundamentals,    Historical Perspective on DBMS, data models    Design Concepts, Organizational Analysis,     Entities / Relationships    Classic Sales Data Base, Data types, Data Validation Rules  Reading Assignment:  Online IST 210 Topic 2			Design record layout for a STUDENT entity & a COURSE entity.  Include data type & appropriate validation rules for each attribute. (2 person teams) Exchange design with another team, make comments &  notes then submit at the end of lab.
1/21/2002	Lecture:  Database Design,  ER diagram basics Reading Assignment: Online IST 210 Topic 3			Design entities, attributes, & ER diagram for a Library data base in Lab.  Consolidate and demo ERD. (2 person teams) Team assignment: Online Skills Lab # 1 - Sports Team design.
1/28/2002	More ERD practice: Sports Team Design feedback Reading Assignment: Online IST 210 Topic 3			Lab Canceled, Work session on idenitifying attributes of entities & normalization.
2/4/2002	Lecture: Normalization - Refining the Data Base Design Reading Assignment: Online IST 210 Topic 4			Draw dependency diagrams for the Library sample data Create copies of the table designs and Convert them to 2NF.
2/11/2002	More on normalization & refining the Data Base Design   Assignment: Read handout Topic on QBE & SQL			QUIZ:  Topics 1-4 Convert the Library sample data to 3NF and polish the data design as much as possible to reduce redundancy.
2/18/2002	Data Base Queries Using Update queries to normalize an existing database.			Update Queries in Access Library ReDesign Implementation Table creation
2/25/2002	Make Table & Append Queries Enforcing Ref. Integrity, Delete with Cascades			Enforce referential integrity in the Library Data Base
3/4/2002	SPRING BREAK   :>)			:>)
3/11/2002	QUIZ: (50 pts): SQL  Query Handout Answers *  IST 210H presentation: Installing Oracle			Lab QUIZ: - Queries (50 pts)
3/18/2002	Rob Cpt. 4 Data Base Implementation:  Data Validation Rules.			Library Database redesign: Enter Data Validation Rules & Delete with cascade rules.
3/25/2002	Rob Cpt 6 User Interface Design, Forms/subforms   * IST 210H presentation: Table creation			Design Library User Interface Forms
4/1/2002	Topic 9 Handout: Reports design  QUIZ::  DB implementation Cpt. 4 & 6			Late Drop Deadline Create Library Reports
4/8/2002	Designing Complete Applicaitons  Menu Screens & Macros * IST 210H presentation: SQL & QBE
4/15/2002	Database Administration, Mgmt, Security, Operations, Performance tuning  * IST 210H presentation: Reports
4/22/2002	E- Commerce Web access to Databases			Final Lab Work Due
4/29/2002	EXAM Wed. 6pm