CIS 260 Introduction to Database Systems (5 credits)
Prerequisite CIS 121 with a 2.0 or above, concurrent enrollment, or instructor permission.
Course Description
A study of concepts, theory, analysis and design of database management systems. The course includes modeling, database design fundamentals, related concepts, and preview of current databases.
Course Content
A. Database Management Systems
B. Database development
C. Business rules
D. Entity-Relationship diagrams
E. Normalization
F. Azure SQL and NoSQL databases
G. Data Validation
H. Data queries
Student Outcomes
1. Analyze, design, and create databases using current database management software
2. Create and modify data models
3. Explain conceptual, logical and physical data models
4. Normalize relationships in tables
5. Create data queries that sort, filter, manipulate and calculate data
6. Analyze and discuss data security issues
7. Describe NoSQL databases
Degree Outcomes
Information Literacy: Graduates will be critical users, creators, and disseminators of information by examining how information is created, valued, and influenced by power and privilege.
Critical, Creative, and Reflective Thinking: Graduates will evaluate, analyze, synthesize, and generate ideas; construct informed, meaningful, and justifiable conclusions; and process feelings, beliefs, biases, strengths, and weaknesses as they relate to their thinking, decisions, and creations.
Program Outcomes: Model and develop database and data warehouse applications to meet user needs. Manage, and work with stakeholders and project teams using practices such as systems lifecycle and agile methods. Research, analyze and integrate information to stay current.
Lecture Contact Hours 50
Lab Contact Hours 0
Clinical Contact Hours 0
Total Contact Hours 50
Potential Methods
A. Student Demonstration
B. Individual and Group Projects
C. Class Discussions
D. Peer Review
E. Instructor Observation
Add to Portfolio (opens a new window)
|
