代做MIS631 – A, B Spring 2025 Data Management代写SQL语言

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