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
II. Course Specification
Course Type
Program Requirement
Credit Hours Narrative
3 Credits
Semester Contact Hours Lecture
45
Semester Contact Hours Lab
0
Prerequisite Narrative
CISW 125
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)
VI. Delivery Methodologies