CISW 217 Database Systems

This course is an introduction to design, development and administration issues of relational databases and database management systems, and their applications to real-business problems. There will be special emphasis on Structured Query Language, logical data design techniques, and rapid prototyping of end user business applications.

Credits

3

Semester Contact Hours Lecture

30

Semester Contact Hours Lab

30

General Education Competency

[GE Core type]

CISW 217Database Systems

Please note: This is not a course syllabus. A course syllabus is unique to a particular section of a course by instructor. This curriculum guide provides general information about a course.

I. General Information

Department

Information Technology

II. Course Specification

Course Type

Program Requirement

General Education Competency

[GE Core type]

Credit Hours Narrative

3

Semester Contact Hours Lecture

30

Semester Contact Hours Lab

30

Grading Method

Letter grade

Repeatable

N

III. Catalog Course Description

This course is an introduction to design, development and administration issues of relational databases and database management systems, and their applications to real-business problems. There will be special emphasis on Structured Query Language, logical data design techniques, and rapid prototyping of end user business applications.

IV. Student Learning Outcomes

Upon completion of this course, a student will be able to:

  • Demonstrate understanding of basic terminology and common uses for database management systems.
  • Describe relations and the theory behind relational databases
  • Demonstrate the use of relational algebra to describe data relations
  • Describe the basic grammar of the Structured Query Language, and demonstrate its use in retrieving and modifying data in a database
  • Describe the core ideas underlying creation of databases and the relations they contain; demonstrate use of entity relationship models and understanding of normalization and normal forms

V. Topical Outline (Course Content)

Introduction to the course material What problems do databases solve? Initial environment setup & quiz Data Relations The relational model Normal forms Creation CREATE DATABASE CREATE TABLE INSERT Retrieval SELECT, minus anything other than the standard (inner) join Using the JOIN keyword Subqueries Sorting Ordering and grouping Modification UPDATE DELETE Security CREATE USER GRANT Alternate forms of access Views Stored Procedures Adding Indices Creating whole database solutions Traditional Diagrams MySQL Workbench EER Diagrams Analyzing business needs Converting needs into production databases

VI. Delivery Methodologies

Required Assignments

Per-unit assignments, which typically focus on code, but early in the semester focus on theory first Quizzes for early theory units

Required Exams

Midterm project Final comprehensive project

Required Text

Database Concepts, 7th Ed.., David Kroenke and David Auer.

Specific Course Activity Assignment or Assessment Requirements

Per-unit assignments, which typically focus on code, but early in the semester focus on theory first Quizzes for early theory units Midterm project Final comprehensive project