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.
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]
Semester Contact Hours Lecture
30
Semester Contact Hours Lab
30
Grading Method
Letter grade
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