|
|
|
May 13, 2024
|
|
CIS 260 Database Management Systems (5 credits)
Prerequisite CIS 122 , or concurrent, with 2.0 or above, or instructor permission.
Course Description
Concepts, theory, analysis and design of relational database management systems (RDBMS). This project-based class explores entity relationship modeling and database design fundamentals.
Student Outcomes
1. Discuss database management systems and database administration.
2. Analyze, design, and create relational databases to meet industry and customer needs using current relational database management system software.
3. Identify the business rules and customer requirements to be included in the data dictionary and data model.
4. Differentiate between and create conceptual data models, logical data models and physical data models.
5. Normalize relationships in tables.
6. Use database design patterns in data modeling.
7. Use modeling/diagramming software to model data.
8. Validate, import, convert, and export data from one application to another.
9. Create data queries that sort, filter, manipulate and calculate data.
10. Discuss ethics and security issues and regulations surrounding data and databases.
11. Test the integrity of the database design.
Add to Portfolio (opens a new window)
|
|
|
