Syllabus

Course Description

This class is designed as a follow-up to V22.0004, "Computers in Principle and Practice I," which examined basic computer principles, theory and history, and also explored word processing, spreadsheets, web browsing and basic web authoring techniques.

This second course will cover an in-depth exploration of database design and implementation for desktop and web-based database implementations.

In order to take this course, students should have completed Computers in Principle and Practice I (V22.0004) or equivalent, and have either completed one semester of programming (such as V22.0002 or V22.0101) or have equivalent programming experience in a high level programming language such as Pascal, C,  or Java.

Course Materials

Books

MySQL: Visual Quickstart Guide
by Larry Ullman
ISBN: 0-321-12731-5
Peachpit Press

Database Concepts
By David M. Kroenke
ISBN: 0-13-145141-3
Pearson/Prentice Hall

XML
By Elizabeth Castro
ISBN: 0-201-71098-6
Peachpit Press

Optional

Microsoft Office Excel 2003 for Windows: Visual QuickStart Guide
By Maria Langer
ISBN: 0321200381
Peachpit Press

Microsoft Office Access 2003 for Windows: Visual QuickStart Guide
By Steve Schwartz
ISBN: 0321193938
Peachpit Press

Internet Resources

All students will be assigned a Unix account with access to MySQL and all required software for this class to use for their websites. MS Office is available for the students to use in the ITS PC labs.

Software

The primary PC software package that will be used during the course is Microsoft Office Professional for Windows (including Word, Excel, PowerPoint, and Access). The other software required for this course will be available on the "i5" server through ITS.

Additional Information

Grading

This course will require one mid-term exam (20% of the final grade); one final exam (30% of the final grade); and approximately 8 homework assignments (accounting for 50% of the final grade). The final project will be due before the final exam.

Topics

This course will cover:


Send questions by email to: