| | Searching Current Courses For Spring 2015 |
| |
Course: |
CIS 240
|
|
| |
Title: | Database Design & Development |
|
| |
Long Title: | Database Design and Development |
|
| |
Course Description: | Introduces the basic concepts of relational databases, data storage, and retrieval. Covers database design, data modeling, transaction processing, and introduces the Structured Query Language for databases. |
|
| |
Min Credit: | 3 |
|
| |
Max Credit: | |
STANDARD COMPETENCIES:
I. The student will gain a working knowledge of Relational Database Systems.
II. The student will be able to effectively apply design tools to the design of a relational database.
III. The student will be able to properly execute queries to retrieve information from a relational database.
IV. The student will be able to place database tables in the first three normal forms.
V. The student will be able to implement concurrency control in a relational database.
VI. The student will be able to create a backup plan for a relational database.
TOPICAL OUTLINE:
I. Introduction to Relational Databases
II. Entity Relationship Modeling
III. Database Table Design
IV. Table Normalization
V. Basic SQL code
VI. Queries
VII. Transaction Processing
VIII. Database Backup and Recovery
| |
Arapahoe Community College |
ACC |
| |
Colorado Community College Sys |
CCCS |
| |
Community College of Denver |
CCD |
| |
Colorado Northwestern CC |
CNCC |
| |
Front Range Community College |
FRCC |
| |
Lamar Community College |
LCC |
| |
Morgan Community College |
MCC |
| |
Northeastern Junior College |
NJC |
| |
Otero College |
OJC |
| |
Pueblo Community College |
PCC |
| |
Pikes Peak State College |
PPCC |
| |
Red Rocks Community College |
RRCC |
Skip to top of page
