讲解 MIS 632 Data Management LAB讲解 留学生SQL 程序

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.