CPT242 B01 Summer 2009 12:10-02:05 TTH LB102

Instructor: Joe Greer WM213 738-7806

e-mail – greer@midlandstech.edu

Office Hours:

F BC 10:00-01:30 WM213

MW AC 02:10- 3:30 CO147

Class Schedule

Tuesday 05/19/09 Orientation

E-Learning Introduction

Introductory Concepts

Introductory Slide

Chapter 1

Thursday 05/21/09 Introductory Concepts (cont.)

Tuesday 05/26/09 Introductory Concepts (cont.)

Thursday 05/28/09 Test 1

Beginning SQL

Relational Algebra

Tuesday 06/02/09 Beginning SQL (cont.)

Thursday 06/04/09 Beginning SQL (cont.)

SQL Project Assigned

Tuesday 06/09/09 Test 2

Data Modeling with the Entity Relationship Model

Thursday 06/11/09 Data Modeling with the Entity Relationship Model

Tuesday 06/16/09 Data Modeling with the Entity Relationship Model

Thursday 06/18/09 The Relational Model and Normalization

Design Assignment

Disney Solution

Tuesday 06/23/09 The Relational Model and Normalization

Thursday 06/25/09 Database Design Using Normalization

Tuesday 06/30/09 Database Design Using Normalization

Thursday 07/02/09 Database Design Using Normalization

Database Design Project Assigned

Tuesday 07/07/09 Test 3

Transforming Data Models into Database Designs

Thursday 07/09/09 Transforming Data Models into Database Designs

Tuesday 07/14/09 Managing Multiuser Databases

Thursday 07/16/09 Managing Multiuser Databases

Tuesday 07/21/09 Access

Thursday 07/23/09 Access

Prentice Hall Site

** The order of topics is correct, but actual date material is covered is tentative

All topics needed to complete a project will not be covered by the time it is assigned,

but will be covered by the time it is due.

If a project is turned in late, then there is an automatic one time deduction of 10

points.

Final grades will be figured as follows:

3 Tests 30%

2 Projects 30%

Class Participation 20%

Final Exam (comprehensive) 20%

All projects are to be turned in on or before the due date for that program or project. Late projects are subject to a one-time deduction of 10 points.

Projects may be turned in via e-mail attachments at greer@midlandstech.edu

No incomplete grades will be given.

All forms of academic dishonesty, including but not limited to cheating on tests, plagiarism, collusion, and falsification of information, will call for discipline.

Campus Emergency Protocol

Students and employees are asked to report safety concerns or suspicious activities to Campus Security at 7199(on campus), or 738-7199 (cell phone and off campus). In the event of an emergency, student and employee protocol is to immediately call Campus Security or local 911. If an emergency occurs, employees and students may seek additional information and instructions via MTC Information Centers, email, college Intranet, the MTC website, campus voice mail and loud speakers.

Attendance Policy

The departmental policy is as follows: The number of absences allowed is equal to 15% of scheduled classes. At this time you will be withdrawn from class.

Any deviation from this policy must be authorized by the Department Head.

**The instructor reserves the right to make changes to this addendum (with proper notification) at any time due to time/equipment constraints, etc.

*** Students with disabilities requiring in-class accommodations should call the Counseling/Disabilities Resource Center at 738-7636 Beltline or 822-2508 Airport.