IS 361: Data Management Concepts
Course Description:
This course provides an overview of data management concepts.
This course will explore the enterprise perspective of managing
data needs of an organization. This includes data integrity, database models,
and integration of databases, security, and database administration issues.
The student will be introduced to query processing within a database environment.
Prerequisite: CS 219. 3:0:3
Learning Outcomes:
Upon completion of this course, the student should be able to:
- Analyze the difference between Data and Database management
- Explain the duties of the data and database administrator.
- Describe the creation and use of metadata and data dictionaries.
-
Identify the organizational perspective of managing data such as
efficiency, privacy, security, ethical responsibility, and strategic advantage
- Compare a Relational Database and Object-Oriented Database.
-
Analyze components of a Database Management System and the techniques used
to store and access data within DBMS.
- Describe a Data Warehouse including possible designs, use and terminology.
- Explain and apply the fundamentals of Structured Query Language (SQL).
Assessment Measures:
| Assessment Tool |
Linkage to Learning Outcome #: |
| |
|
| Homework Assignments: |
|
|
Instructor will utilize various case studies that illustrate multiple scenarios to evaluate student's ability
to meet and understand concepts.
|
1-8 |
|
To achieve "creativity and problem solving skills, "students must be
required to produce programming project solutions from a given problem
description. Note that objectives are not met if a student is only able to
produce solutions by pasting together given code fragments. Although this is
appropriate at times, it does not enforce the development of these skills.
|
8 |
|
|
| Exams: |
|
|
Tests will be used to evaluate student's ability to understand terminology
and basic concepts of managing data. This should include at minimum a final
and include at least one or more of the following: short answer, trace given
code, debug given code, and/or develop a fragment of code given a problem description.
|
1-8 |
Textbooks
To view the approved textbook list, click
here.
