MIS631 – A, B
Spring 2025
Course Title: Data Management
Program(s): BI&A, MSIS
Description:
This 2-credit course focuses on data and database management, with an emphasis on modeling and design, and their application to business decision making. The course provides a conceptual understanding of both organizational and technical issues associated with data. The central theme concerns data modeling and databases. We examine organizational approaches to managing and integrating data. Among the topics included are normalization, entity-relationship modeling, relational database design, SQL, and data definition language (DDL). Discussed are specific applications such as strategic data management, master data management, and physical database design. The course concludes with a brief overview of Decision Support Systems, data warehousing and business intelligence, NoSQL databases (e.g., MongoDB) and cloud computing. The course includes several case studies and modeling and design projects.
Students in MIS 631 must also enroll in the associated 1-credit lab course MIS 632 Managing Data Lab.
Course Objectives:
1. Understand the role of data in the competitiveness and strategy of organizations
2. Design relational databases in normalized form.
3. Build SQL queries
4. Develop and critique entity-relationship (ER) data models
5. Elucidate advanced data modeling issues e.g., temporal data modeling, meta-data, etc.
6. Identify and analyze data quality in a business context
7. Develop and evaluate strategic data plans; e.g., Master data management plan, enterprise data strategy & models
8. Understand the growing importance and issues associated with data warehousing, business intelligence and analytics, and big data.
ASSIGNMENTS
Individual & Team Assignments (10%)
Review and comment on several assigned readings from the research and professional literature and modeling exercises. Developing a business case.
SQL Certification (10%)
Required SQL Module: https://www.sololearn.com/Course/SQL/
Information Modeling Exam (15%)
Mid Term (15%) - Individual
The mid-term paper is an individual assignment and is technology focused. References and all sources used (articles, texts, Web sites, etc.) must be provided in standard format.
Team Database Project (40%)
Students will develop a functional database that will be demonstrated at the conclusion of the course. The assignment includes business problem analysis, identification of database requirements, data modeling, creation of the database, and the development of business specifications for key processes. The final deliverable consists of a presentation and a set of PowerPoint slides.
Participation (10%)
Students will be assessed on their contributions to in-class discussions throughout the semester.
Course Outcomes
After taking this course, students are able to:
· Understand basic deep modeling constructs
· Creatively apply data modeling to solve real business problems
· Assess model performance accurately to understand each model’s pros/cons
· Explain models, interpret model outcomes, and understand potential bias
· Execute SQL queries
Prerequisites: Cross-listing: — show cross-listed course number(s)
Grading Percentages: HW 20% Class work 10% Mid-term 20%
SQL Certificate 10% Database Projects 40%
Other (specify both percent and kind of work)
Credits: 2 credits Other
For Graduate Credit toward Degree or Certificate
Yes No Not for Dept. Majors Other
PREREQUISITES
· Students must satisfy the requirement for enrollment in either the BI&A or MIS master’s degree programs.
TEXTBOOK(S) OR REFERENCES
Required Textbook: Database Concepts (9th Edition), by David Kroenke, David Auer, Scott
L. Vandenberg, Robert C. Yoder. Pearson 2019.
Required SQL Module: https://www.sololearn.com/Course/SQL/
Required Software:
ERwin
Department Point of Contact and Title: Joseph Morabito; [email protected]
Syllabus:
NOTE: -à Indicates an MIS 632 lab exercise
|
Session
|
Subject(s)
|
Assignment(s)
|
|
Tuesday
Jan 21
|
First Day of Spring 2025 Semester
|
|
|
|
PART 1 - DATABASE FOUNDATIONS
|
|
|
1
Jan 27
|
Introduction to MIS631
Introduction to Data Management Functions
Factors Affecting Data Management Functions
|
Read Ch. 1
-à ERwin installation
--> Install PostgreSQL
|
|
2
Feb 3
|
Tutorial on Database and Database Design
|
Read Ch. 2
-à ERwin basics+ normalization
|
|
3
Feb 10
|
Organizations and Data
Research paper presentations & discussion
|
Prepare research paper presentations (Team)
|
|
Feb 17
|
President’s Day – No Class
|
|
|
4
Tuesday
Feb 18
|
Stevens follows the Monday Schedule
Query Languages – SQL
|
Read Ch 3, 3A
-à ERwin tutorial + examples
|
|
|
PART II – Data Modeling
|
|
|
5
Feb 24
|
Tutorial on Abstraction and ER Data Modeling
|
Read Ch 4, 5
-à SQL queries - basics
|
|
6
Mar 3
|
Extended ER; Generalizating Data Model Patterns
Information Modeling
|
-à Construct complex SQL queries
|
|
7
Mar 10
|
Information Modeling – Advance Modeling (continued);
Contracts and Formal Methods
Discuss Key Semester Learnings
|
-à SQL queries - advanced
|
|
|
PART III - DATABASE MANAGEMENT
|
|
|
Mar 16 – Mar 23
|
Spring Break
|
|
|
8
Mar 24
|
Data and Database Administration Functions
Physical Database Design
Strategic Data Modeling
Major Data Project Requirements Presented
|
-à Extended ER data modeling
Information Modeling Exam due (25%)
è Major Project
|
|
9
Mar 31
|
Application of Data Modeling and Database Design to a business area
Major Data Project Requirements Presented
|
-à Extended ER data modeling II – complex business examples
Midterm Exam Due
è Major Project (continued)
|
|
10
Apr 7
|
Data Warehouse, Business Intelligence, and Big Data
Row & Column data storage
MapReduce exercise
|
---> Develop a DB model in Postgres using DDL
è Major Project (continued)
|
|
11
Apr 14
|
Cloud Computing and Data Architectures
Review Final Project with Teams
|
-à Install a database in the cloud (AWS)
è Major Project (continued)
|
|
12
Apr 21
|
NoSQL: document, key-value, column-wide, graph
Review Final Project with Teams
|
è Major Project (continued)
|
|
Sunday Apr 28
|
Final Team Projects must be submitted in Canvas
|
|
|
May 5
|
Major Data Project Presentation (Team)
Groups:
|
|
|
13
May 12
|
Major Data Project Presentation (Team)
Groups:
|
-à Use Erwin for data design project: modeling and database design
|
|
|
Last Day of Spring 2025 Classes:
May 17
Final Exam Period: Sunday May 11 – Sunday May 18
|
|
|
14
May 19
|
Major Data Project Presentation (Team)
Groups:
|
|
|
15
Dec
|
Major Data Project Presentation (Team)
Groups: Overflow
|
|