Section menuClose menu Columbia College


Master Syllabus

Print this Syllabus « Return to Previous Page

Administrative Unit: Computer and Mathematical Sciences Department
Course Prefix and Number: CISS 430
Course Title: Database Systems
Number of:
Credit Hours 3
Lecture Hours 3
Lab Hours 0
Catalog Description:

Design and implementation of relational and object-oriented database systems. Relational algebra, normal forms and normalization, query processing, efficiency and security considerations. Prerequisite: CISS 280 or CISS 285.

Prerequisite(s) / Corequisite(s):

CISS 280 or CISS 285.

Course Rotation for Day Program:

Offered Spring.

Text(s): Most current editions of the following:

Fundamentals, Design, and Implementation: Database Processing.
By Kroenke, D.M. (Prentice Hall)
Database System Concepts
By Silberschatz, A., et. al. (McGraw-Hill)
Course Learning Outcomes
  1. Demonstrate basic knowledge of databases, with a focus on relational databases.
  2. Develop conceptual and logical data models and perform normalization and denormalization for a moderately complex business scenario.
  3. Write and interpret moderately complex SQL queries.
  4. Develop moderately complex databases for a business problem on a major platform (e.g. Oracle).
Major Topics/Skills to be Covered:
  • Explain data modeling including constructing entity-relationship diagrams.
  • Explain database design and normalization including functional dependencies, first through third normal forms, Boyce-Codd normal form, lossless join and dependency-preserving design trade-offs.
  • Explain physical data design and denormalization.
  • Explain SQL and how to use SQL to create, maintain and inquire of database systems.

Recommended maximum class size for this course: 20

Library Resources:

Online databases are available at You may access them from off-campus using your CougarTrack login and password when prompted.

Prepared by: Suzanne Tourville Date: April 14, 2015
NOTE: The intention of this master course syllabus is to provide an outline of the contents of this course, as specified by the faculty of Columbia College, regardless of who teaches the course, when it is taught, or where it is taught. Faculty members teaching this course for Columbia College are expected to facilitate learning pursuant to the course learning outcomes and cover the subjects listed in the Major Topics/Skills to be Covered section. However, instructors are also encouraged to cover additional topics of interest so long as those topics are relevant to the course's subject. The master syllabus is, therefore, prescriptive in nature but also allows for a diversity of individual approaches to course material.

Office of Academic Affairs