| 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 Cross-Listed: |
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
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 |
| None |