Section menuClose menu Columbia College

MASTER SYLLABUS

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 285 or CISS 280 or CISS 465.

 
Prerequisite(s) / Corequisite(s):

CISS 285 or CISS 280 or CISS 465.

 
Course Rotation for Day Program: Offered odd Spring.
 
Text(s): Most current editions of the following:

Fundamentals, Design, and Implementation: Database Processing.
By Kroenke, D.M. (Prentice Hall)
Recommended
Database System Concepts
By Silberschatz, A., et. al. (McGraw-Hill)
Recommended
 
Course Objectives
  • To develop a strong foundation in database concepts.
  • To learn theory and practice of designing and using databases.

  •  
    Measurable Learning
    Outcomes:
    • 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.
     
    Topical Outline:
  • Abstraction in a database management system
  • ER diagrams
  • The relational model:
    - Relational algebra
    - Normal forms for relational schemes
  • Physical data organization:
    - Hashed files
    - Indexed files
    - B-trees
  • Query processing and query optimization
  • Integrity and security issues

  •  
    Culminating Experience Statement:

    Material from this course may be tested on the Major Field Test (MFT) administered during the Culminating Experience course for the degree. 
    During this course the ETS Proficiency Profile may be administered.  This 40-minute standardized test measures learning in general education courses.  The results of the tests are used by faculty to improve the general education curriculum at the College.

     

    Recommended maximum class size for this course: 20

     
    Library Resources:

    Online databases are available at http://www.ccis.edu/offices/library/index.asp. You may access them from off-campus using your CougarTrack login and password when prompted.

     
    Prepared by: Yihsiang Liow Date: November 11, 2013
    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 objectives and cover the subjects listed in the topical outline. 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
    12/04