MIS 632 Data Management LAB
Catalog Description
This 1-credit lab course provides an experiential learning component for MIS 631 Data Management for which it is a co-requisite. MIS 632 provides hands-on experience in designing, implementing, and querying databases. The relevant software is introduced using demonstrations, in-class exercises and homework exercises that are closely tied to and executed in synch with the conceptual and theoretical material covered in MIS 631. Specifically, students will gain hands-on experience in: (i) ERWIN - a widely used commercial tool for representing conceptual (e.g., E-R diagrams) and logical data models (e.g., relational DBMS), (ii) PostgreSQL (relational database software), (iii) SQL Structured Query Language) and (iv) a NoSQL document data store. Students in MIS 632 must also be enrolled in the associated 2-credit lecture course MIS 631 Managing Data course.
Course Objectives
Through immersion in practical applications of the concepts, data models and theory in the associated co-requisite course MIS 631, students are prepared for a world in which data and evidence-based decision making are increasingly important. The skills gained in this course are essential for employees in the information technology and analytics departments in all major industries.
List of Course Outcomes
Through their exposure to case studies, in-class demonstrations and exercises, assigned homeworks and a team project, students will be able to:
1. Understand the major phases of the data life-cycle (analysis of business needs, design, implementation and use)
2. Develop conceptual data models (E-R diagrams to design relational databases)
3. Implement a database in PostgreSQL
4. Build SQL queries
5. Work in a team to execute a database development project.
Corequisites: MIS 631
Students in MIS 632 must also be enrolled in the associated 2-credit lecture course MIS 631.
Grading Percentages: HW 40% Class work 40% Mid-term Final Projects Other 20% Class Participation
Credits: 1 credit Other
For Graduate Credit toward Degree or Certificate
Yes No Not for Dept. Majors Other
Textbook(s) or References
· Software and tool documentation for ERwin and PostgreSQL
Support for Team Project in MIS 631
Students will be assisted in their work on the MIS 631 class project in which teams of 3-4 students will develop a database in an application of their choice. There will be several deliverables including a proposal, progress update(s), final report and a final in-class presentation. Students use this project to develop skills required for the entire data life cycle.
· Project proposal: define a business problem and survey potential techniques for the data used to support the associated business process.
· Model development through the development of a conceptual database model and its realization in a relational (or other) database
· Application deployment and management: develop plans for deployment of the database
Mode of Delivery Class Online Modules Other
Program/Department Ownership: MIS
When first offered: Fall 2024
Department Point of Contact and Title: Joe Morabito
Syllabus
Note: Each MIS 632 lecture period will consist of a 10-20 minutes overview of the assignments, which will be completed by teams of students in the remainder of the class session.
|
Date
|
MIS 632 Subject
|
MIS 632 Assignment
|
|
Jan 27
|
Installation of relevant software
|
Install ERwin
Install PostgreSQL
|
|
Feb 3
|
Relational database theory (Normal Forms)
|
Normalization exercises
ERwin tutorial
|
|
Feb 10
|
Relational database theory (c.t.d) with examples
|
Design simple E-R models
|
|
Feb 18
|
Basic SQL: syntax & grammar
|
Construct SQL queries
|
|
Feb 24
|
Advanced SQL:
update/insert/delete/subqueries
|
Construct complex SQL queries
|
|
Mar 3
|
Advanced SQL (c.t.d)
|
SQL queries exercise
|
|
Mar 10
|
Extended ER data modeling
|
Extended ER with examples
|
|
Mar 17
Mar 24
|
Spring Break – No Class
Schedule Conflict – No Class
|
|
|
Mar 31
|
Extended ER data modeling (c.t.d)
|
Construct a use case for various business scenarios
|
|
Apr 7
|
Introduction to DDL and performance tuning
|
Develop a database model in PostgreSQL using DDL
|
|
Apr 14
|
Application of data modeling in business domain
|
Business examples
|
|
Apr 21
|
Database organizational structure: star schema
|
Use ERwin to construct a simple star schema
|
|
Apr 28
|
Develop cloud architecture
|
Install a database in the cloud (AWS)
|
|
May 5
|
Student projects presentation
|
|