Get documents about "SCHEDULE Database Concepts - CINS234 WCH
Document Sample
Page 1 of 4
School of Applied an Information Technology
Catonsville Campus
SCHEDULE: Database Concepts – CINS234 WCH
August 21, 21009
FINAL VERSION
This is an Overview of Course Activities see the Learning Modules for specifics!!!
Date / Due Date
Activities
Module
Course Orientation Assignment: Due by midnight Wednesday September 2, 2009
It is important that you complete this assignment by the deadline. This assignment prepares you to
successfully complete this course and determines the compatibility of your pc's hardware and software to
course materials.
Read and Do the Course Orientation Assignment
9/2/09 Midnight
1. Chapter: 1- Introduction to Database Management 11:59pm
1 9/8/09
IMPORTANT:
Make sure you have made 6 copies of the CINS234Data folder and
renamed each folder copy to correspond with the following chapters:
Chapter2CINS234Data
Chapter3CINS234Data
Chapter4CINS234Data
CreateDBMSCINS234Data
MySQLCINS234Data
Chapter7-9CINS234Data
Refer to Step 9b of the Course Orientation Assignment for further details
Attend the Catonsville Campus room H215 from 5:45pm – 8:40pm
Bring your textbook
Scheduled Activities:
Download Data Files and Create 6 Folders (if students have not completed)
9/9/09 Learn to Backup and Restore an Access Database
Learn to interpret an Entity Relationship (ER) Diagram
Analyze the Relational Database Model by determining Tables to use in Queries
Write Queries using QBE (Query by Example) View of Access
Write Queries using the SQL (Structured Query Language) View of Access
1. Lab Handout: Backing Up and Restoring a Database
9/9/09 2. Chapter: 2-The Relational Model 1: Introduction and QBE Midnight
11:59pm
2 3. Demo: Interpreting ER Diagrams 9/15/09
4. Demo: Querying with Access the Basics
5. Demo: Querying with Access SQL
Page 2 of 4
Date / Due Date
Activities
Module
9/16/09 Midnight
1. Chapter: 3 - The Relational Model 2 – SQL
11:59pm
3 9/22/09
9/23/09 Midnight
GRADED PROJECT – Chapters 2-3 11:59pm
4 9/29/09
9/30/09
1. Midnight
Chapter: 4 - The Relational Model 3 – Advanced Topics
5 11:59pm
10/6/09
Attend the Catonsville Campus room H215 from 5:45pm – 8:40pm
Scheduled Activities:
10/7/09 Distribution of MySQL Database software
Distribution of Instructions for Installing MYSQL
Create Database and Tables using Script Files (*.sql)
Write Queries in MySQL | Save As a Script (*.sql) file
Create and Manage a Database using MySQL
1. Lab Handout: Installing MySQL Midnight
10/7/09 2. Lab Handout: Creating/Managing a DBMS using MySQL Lab Handout 11:59pm
3. Review for Midterm Exam 10/13/09
6
Midnight
Midterm Exam: 11:59pm
Chapters 1 – 4 Take WebCT: 234 Midterm Exam Open Textbooks / Notes
10/14/09
Extra Learning for Extra Credit: Worth 10 points towards the Midterm Exam
Do items 1, 3, 5, 7, 10 and 11 of the Chapter 4 Henry Books Case – due 3/18/09
Attend the Catonsville Campus room H215 from 5:45pm – 8:40pm
10/14/09 Scheduled Activities: - Please return the MySQL cds
Lecture Chapter 5
Work with Normalization
Database Design Overview
10/14/09 Midnight
1. Chapter: 5 - Normalization
11:59pm
7 10/20/09
10/21/09 Midnight
1. Lab Handout: Database Design Overview 11:59pm
8 10/27/09
Page 3 of 4
Date / Due Date
Activities
Module
10/28/09 Midnight
GRADED PROJECT – Chapter 5 11:59pm
9 11/3/09
Attend the Catonsville Campus room H215 from 5:45pm – 8:40pm
11/4/09 Scheduled Activities:
Lecture on Chapter 6 Database Modeling
Demonstrate creating a Database Model using Visio
Complete a Tutorial: Creating a Database Model using MS Visio
1. Chapter: 6 - Design Methodology
11/4/09 Midnight
2. Lab Handout: MS Visio 2007 Professional Example 11:59pm
10 11/10/09
3. Lab Handout: MS Visio 2007 Professional Tutorial
11/11/09 GRADED PROJECT – Chapter 6 Midnight
11:59pm
11 IMPORTANT: This project will not be accepted late and corrections will not be allowed 11/17/09
11/18/09 GRADED PROJECT - FINAL PROJECT Midnight
11:59pm
Use the Official E-R Diagram that will be available on Learning Module
12 12/1/09
12 or the Handouts page on 11/8/09
Thanksgiving Break: College Closed November 25 – November 29, 2009
1. Chapter: 7 - DBMS Functions
2. Chapter 9: Database Management Approaches these topics:
a. Client/Server Systems pages 283 – 287
12/2/09 b. Web Access to Databases pages 287 – 293 Midnight
11:59pm
13 c. Data Warehouse and Data Mining pages 293 – 299 12/8/09
3. Lab Handout: Data Warehouse and Data Mining
4. Lab Handout: Creating an Excel Pivot Table Using a Cube Lab Handout
**If you must missed 12/9: Visual Studio 2008 is installed in Catonsville and Essex Open Labs
Page 4 of 4
Date / Due Date
Activities
Module
Extra Learning for Extra Credit: Worth 10 points towards the Final Exam
Complete Reverse Engineering Lab Handout
Under the Handouts Page (Module 14) – due 12/8/09
Attend the Catonsville Campus room H215 from 5:45pm – 8:40pm
12/9/09 Scheduled Activities:
Client Server Computing Lab Handout
Web Database Applications Handout
1. Review for Final Exam: Chapters 1 – 7 and 9
2. Lab Handouts:
a. Client Server Computing (use Open Lab if you missed 12/9 class)
12/9/09
b. Web Database Applications (use Open Lab if you missed 12/9 class) --
14
c. MySQL: Managing | Securing a Database (OPTIONAL)
3. Final Exam Available Starting Today
12/9/2009 Final Project Corrections (optional) Due by midnight 11:59pm
12/16/2009 Final Exam Due by midnight 11:59pm
Take WebCT: 234 Final Exam Open Book and Open Notes
Related docs
