Cs 2203 Databases 1

CIU Request Information

Course Outline

CS 2203: Databases 1

Prerequisites

None

Course Description:

This course introduces the fundamental concepts necessary for designing, using and implementing database systems. We stress the fundamentals of database modeling and design, relational theory and the Structured Query Language (SQL).

Required Textbook and Materials: The main required textbooks for this course are listed below, and can be readily accessed using the provided links. There may be additional required/recommended readings, supplemental materials, or other resources and websites necessary for lessons; these will be provided for you in the course’s General Information and Forums area, and throughout the term via the weekly course Unit areas and the Learning Guides.

Software Requirements/Installation:

See description at the bottom part of this document.

Learning Objectives and Outcomes:

By the end of this course students will be able to:

  1. Describe the differences between the network, hierarchical, relational, and entity relationship information models
  2. Demonstrate knowledge of relational algebra
  3. Describe the attributes and functions of database management systems (DBMS)
  4. Create and normalize a database schema to meet the requirements of an information system
  5. Create entity relationship (ER) diagrams to represent a database schema
  6. Apply Structured Query Language (SQL) statements including (create, alter, select, insert, update, and delete) to manipulate both data structures and data within a database system
  7. Apply SQL dynamically and statically within a program

Course Schedule and Topics:

This course will cover the following topics in eight learning sessions, with one Unit per week. The Final Exam will take place during Week/Unit 9 .

Unit 1 Week 1 – Databases and the Relational Data Model
Unit 2 Week 2 – Constraints, Relational Algebra, and Relational Calculus
Unit 3 Week 3 – Conceptual Data Model
Unit 4 Week 4 – Relational Database Design
Unit 5 Week 5 – An introduction to SQL
Unit 6 Week 6 – DDL and DML Commands
Unit 7 Week 7 – Querying the Database using SQL
Unit 8 Week 8 – Database Programming
Unit 9 Week 9 – Final Exam