CIS 143: Introduction to Database Systems
Course Description
Provides students with a comprehensive introduction to database concepts. Primary focus is on the relational model of database management and querying databases using Structured Query Language (SQL). Existing relational databases are examined and manipulated, and new relational databases are created. Recommended preparation: CAS 125, CAS 160 or CIS 101 or equivalent experience.
Course Outline
- Introduction
- Single Table Query By Example
- Multiple Table Query By Example
- Single and Multiple Table SQL
- Microsoft Database Management Systems
- Other Database Management Systems
- Advanced SQL
- Normalization
- Database Design Language and Entity Relationship Diagrams
- Database Design Approaches
- Group Design Project
- Database Management Systems
- Database Administration
- Database Management Approaches
- Final Project Demonstration
Required Materials
-
Concepts of Database Management (Sixth Edition) – Course
Technology –
ISBN 13: 978-1-4239-0147-1 ISBN 10: 1-4239-0147-9 - Internet access and a Harper Blackboard account.
- Access to a computer running Microsoft Access 2000, Microsoft Access 2002, Microsoft Access 2003, or Microsoft Access 2007, and access to a licensed or free trial version of one other relational database management system (DB2, Microsoft SQL Server or SQL Server Express, MySQL, or Oracle). Harper lab I 205 has computers and software that may be configured as necessary for this course.
Optional Materials
-
Microsoft® SQL Server™ 2005: Database Essentials Step by Step –
Microsoft Press –
ISBN 13: 9780735622074
Faculty Contact
For questions about this course contact the department coordinator:
Dave Braunschweig
dbraunsc@harpercollege.edu
847.925.6817