| Course ID: | MIST 7510E. 3 hours. |
| Course Title: | Database Management |
Course
Description: | Provides a basic understanding of data management in
organizations and, specifically, the design and use of database
systems. Main topics include data modeling, relational
databases, structured query language, database structure,
storage, and integrity. In addition, recent developments
related to big data (and tools for their analysis) will be
introduced. |
| Oasis Title: | Database Management |
| Nontraditional Format: | This course will be taught 95% or more online. |
| Prerequisite: | CSCI 1301-1301L or permission of department |
Semester Course
Offered: | Offered fall semester every year. |
| Grading System: | A-F (Traditional) |
|
| Course Objectives: | Upon successful completion of this course, students will be
able to:
1. understand the organizational issues involved in data
management
2. develop a valid data model for a business system of medium
complexity
3. build and use a normalized relational database
4. formulate complex relational database queries
5. understand the different data structures and recommend one
6. understand the different data storages and recommend one
7. manage and use spatial and temporal databases
8. understand data integrity and how to maintain it
8. discuss issues related to managing "big data"
9. use R for data analtyics
10. use R for data visualization and dashboards |
| Topical Outline: | 1.The organizational perspective on data management
2.Data modeling
3.Relational DBMS
4.Structured query language
5.Data structure and storage
6.Spatial and temporal databases
7.Data integrity
8.Big data
9.Introduction to R
10.Data visualization and dashboards |
| Honor Code Reference: | Students are expected to adhere strictly to the University Honor
Code and Academic Honesty Policy and to follow generally accepted
standards of honesty in all assignments and examinations. |