Revised Apr 2008
Reviewed Sept 2007
Revised: June 2006

Course Title: Database Design

Course Number: CS 275

Credit: 3

Institution: Clackamas Community College

Outline Developed by: Douglas Cross Ph.D. 

Course Description: 
	
	The course will focus on design of a relational database management system (RDMS). Topics will include database development using the a) requirement b) design c) implementation model, database theory from flat table design to relational systems, entity-relationship model,  one-to-one, one-to-many, and many to many relationships,  table design with attributes, primary/foreign key, referential integrity, normalization of table, database programming with SQL, and database security.

	The first half of the course will focus on database design theory and design elements. The second half of the course will focus on database programming using SQL with various database programs including MS Access, MS SQL Server, MySQL and Oracle. Students will learn basic query programming using Structured Query Language (SQL) and the specific context for the different platforms. 

Objective: 
	
	To understand and utilize database development tools to assess needs, determine design and to implement a Relational Database Management System using various database application programs.

Expected Student Outcomes: 
Upon successful completion of this course the student should be able to:
•	define database terminology
•	understand the requirements of professional database deign
•	develop SQL statements 
•	compare and contrast MS Access, Oracle, MS SQL Server 2000 and MySQL

Length of Course: 33 hours
	
	3 hours per week in classroom lecture and experiential classroom environment 
	3 – 12 hours per week dedicated to homework assignments

Library:

	Use of library and information resources is integrated into computer science certificate and degree programs in general education requirements and in computer science classes as relevant to the curriculum. Use of library and information resource is encouraged and students can access a variety of program-appropriate materials via the library’s web-based electronic databases and print materials. Instruction in the use of library and information resources is available to all students. 

Prerequisite:
	
	CS135DB 

Required Text:
	
Database Concepts by  David Kroenke

Course Topics:

•	Introduction to Database Design
•	Flat file data systems vrs relational database design  
•	Database development
•	Requirements: information gathering
•	Design: putting it on paper
•	Entity-Relationship model
•	Primary/Foreign Key
•	Relationships
•	Normalization: reducing redundancy
•	Referential integrity
•	Database Administration 
•	Database security
•	Database queries with SQL
•	Preview of Database applications 
•	MS Access
•	SQL Server
•	MySQL
•	Oracle