Westwood College of Technology
Course Syllabus
Database Applications - CS224
Instructor: Tom Sinclair
Office Hours: 3 PM - 5 PM Fri. (By appt. all other times)
Office Phone: (303)934-1122 x678
Term: Oct04
E-mail:tsinclair@westwood.edu
Web page: http://homepage.mac.com/tsinclair
Contact/Credit Hours: 36/3
Text: Databases: Design, Development & Deployment Using Microsoft Access ,Second Edition, Rob & Semaan, 2004, Irwin-McGraw/Hill
Course Description:
In this course, students build databases using a database application.
Course Objective:
Topics include database creation/manipulation, creating keys, table relationships, and reports and forms. Upon completion of this course, students should be able to develop a database, establish relationships between tables, and design user-friendly views and reports.
Prerequisites:
None
Instructor Bio:
Tom comes to Westwood with over fourteen years of industry experience. He has done systems administration, technical support, IT architecture and systems design with such firms as AT&T, Lucent Technologies and KPMG LLP. He has a Master's Degree in Computer Science from Loyola University of Chicago. He is currently the Lead Instructor for the Computer Programming department as well as adjunct faculty at Regis University's School for Professional Studies. He is currently writing a textbook on Linux networking.
Policies:
Attendance -
Attendance will be taken at the beginning of each class session. Students are allowed emergency absences totaling no more than 10% of the total clock hours for this course. Student Action Reports (SAR) will be submitted to the Program Director for excessive absences.
**If you are going to be absent, you must contact the instructor at the following phone number: (303) 934-1122 Ext 678
Grading -
Quizzes 15%
Attendance and Participation 20%
Homework/Labs 15%
Final Exam/Project 50%
Other -
Cell Phones, Pagers and Headphones - Cell phones must be turned off and pagers turned off or set to vibrate during class time. Headphones are not allowed during the class period. However, any of these may be freely used during the scheduled class breaks.
Class Breaks - There will be two ten minute breaks per three hour class session.
Homework - To assist students with review and help them better prepare for the quizzes and final exams, I may choose to give out short homework assignments based on that week's work. We will go over them in class together, allowing us to review the material as a group.
Gaming and inappropriate Web surfing - Simply put, don't do this during class time.
Teamwork - Not everyone in this class will be at the same level with respect to technical ability and experience. This means that teamwork for labs or class exercises is strongly encouraged. If you finish early, please help someone else with their work.
Makeup work - If you wish to make up an assignment or a test, you must contact the instructor before being allowed to do so. If a make-up is allowed, then you have until the end of the next class period to complete the work. In addition, you may suffer a penalty on total points awarded for the work, depending on circumstances and at the instructor's discretion.
All students are expected to abide by the general rules of conduct as described in the college catalog, in addition to those set down in the Westwood LAN Acceptable Use Agreement. Additional policies or changes to existing policies specific to this course are to be at the discretion of the instructor and/or the Computer/Networking department.
________________________________________
Course Guide CS224 Database Applications
Week One: 10/22/2004
Introduction
Syllabus, Lesson plan Overview
Project Introduction
Week Two: 10/29/2004
Chapter 1 - Database Vocabulary, Concepts and Design Tools
Chapter 2 - Normalizing the Database Table Structures
Project Phase 1 due
Project work
Week Three: 11/05/2004
Chapter 3 - The POS Database Design Process
Project Phase 2 due
Project Work
Week Four: 11/12/2004
Finish Chapter 3
Chapter 4 - Implementing the Database Design
Project Phase 3 Due
Project Work
Week Five: 11/19/2002
Finish Chapter 4
Chapter 5 - Queries
Project Phase 4 Due
Project Work
Week Six: 11/26/2004
Project Work
Week Seven: 12/03/2004
Chapter 6 - Form Development
Project Phase 5 Due
Week Eight: 12/09/2004
Chapter 7 - Reports and Labels
Project Phase 6 Due
Review for Final Exam
Project Work
Week Ten: 12/16/2004
Project Phase 7 Due
Final Exam 12/17/2002
The above course guide may be changed at the discretion of the instructor to fit the needs of the class. In addition, students will also be responsible for the content of any supplemental materials provided by the instructor unless otherwise stated.
-------------------------------------------------------------------------------------------------------------------------------
I, __________________________________________, have received and read the course syllabus for and understand those policies outlined in it.
_________________________________________
signature
________________________________________
Sunday, October 15, 2000 , 7:04 PM , Rev #