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.
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
Credit Hours Narrative
3 Credits
Semester Contact Hours Lecture
45
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 (DBMS).
- Describe the concepts of data and relations underlying the four basic database operations (Create, Retrieve, Update, Delete)
- Describe the core ideas underlying the creation of databases and the relations they contain.
- Describe basic database security concepts, such as the creation and use of users and hosts for access control and the granting of user rights.
- Describe the grammar of the Structured Query Language (SQL)
- Using a provided DBMS and SQL, demonstrate the four basic database operations, the creation of new databases and relations, and administrative tasks such as user management.
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