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:
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 Learning Outcomes
Demonstrate basic knowledge of databases, with a focus on relational databases.
Develop conceptual and logical data models and perform normalization and denormalization for a moderately complex business scenario.
Write and interpret moderately complex SQL queries.
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
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.