Article Header
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum
Course Number: |
CIS 260 |
Course Title: |
Database Management Systems (Pierce College) |
||
Course Catalog Description: | Credits: | 5 | |||
Concepts, theory, analysis and design of relational database management systems (RDBMS). This project-based class explores Entity Relationship modeling and advanced Microsoft Access techniques in preparation for the Microsoft Office Specialist exam. Practical application includes case study analysis within the healthcare industry and comparison to other industries as applicable. | |||||
Course Content: | |||||
|
|||||
Student Outcomes: | |||||
1. Discuss database management systems and database administration. (A1)2. Analyze, design, and create relational databases to meet industry and customer needs using current relational database management system software. (B1)
3. Identify the business rules and customer requirements to be included in the data model. (C1) 4. Differentiate between and create conceptual data models, logical data models and physical data models.(D1) 5. Normalize relationships in tables. (E1) 6. Use database design patterns in data modeling. (F1) 7. Use modeling/diagramming software to model data. (F2) 8. Validate, import, convert, and export data from one application to another (G1) 9. Create data queries that sort, filter, manipulate and calculate data (H1) 10. Develop effective queries, forms, reports and custom user interfaces for databases. (I1) 11. Discuss ethics and security issues and regulations surrounding data and databases. (J1) 12. Test the integrity of the database design. (K1) |
|||||
Degree Outcomes: Enter the appropriate FAK (GER) or Program Outcome (Pro-Tech), and at least one Core Abilitiesoutcome which will be formally taught and assessed in this course. FAK and Core Abilities outcomes are on the Pierce
|
|||||
Core Abilities
Program Outcomes
|
|||||
Potential Methods and Tools for Assessment: | |||||
|
More information about our Programs of Study for 2012-2013