Central Arizona College Back
CIS 178 Database Fundamentals and Programming
Credit Hours:  3
Effective Term: Fall 2017
SUN#: None
AGEC: None  
Credit Breakdown: 2 Lectures, 3 Labs
Times for Credit: 1
Grading Option: A, B, C, D, F

Description: Fundamentals of relational database management systems and their use in business environments. Topics include: database classifications, data models with extensive coverage of the relational model, entity-relationship and extended entity models, normalization, advanced data modeling, and Structured Query Language (SQL) programming. Students design and implement a real-world relational database and create complex SQL queries to retrieve data from the database. Prerequisite: CIS120.

Prerequisites: CIS120

Corequisites: None

Recommendations: None

Measurable Student Learning Outcomes
1. (Application Level) Use modern techniques of database organization and access in a database environment. (CSLO 3)
2. (Comprehension Level) Describe the importance of database modeling and design. (CSLO 2)
3. (Comprehension Level) Understand the relational database model and Entity Relationship Diagrams. (CSLO 2)
4. (Synthesis Level) Plan, create, and analyze databases for reporting. (CSLO 4)
5. (Synthesis Level) Design and create multiple tables and table relationships. (CSL0 3)
6. (Application Level) Implement queries with Structured Query Language to solve a business problem. (CSLO 3)
7. (Comprehension Level) Discuss normalization of a database. (CSLO 2)
8. (Comprehension Level) Understand what transaction management and concurrency are in a database. (CSLO 2)
9. (Comprehension Level) Discuss the different types of databases. (CSLO 2)
Internal/External Standards Accreditation