MIS-332 Database Design & Implementation

(under revision)

University of Massachusetts Dartmouth

Charlton College of Business
Department of Decision and Information Sciences

Class MIS 332, 2026 Spring (Online)

Instructor: Zhengzhong Shi, Ph.D.
Prerequisite(s): MIS 315 Information Systems, and at least junior standing.
Email: [email protected]
Course Web Site: myUmassD at https://my.umassd.edu/ first and then select Canvas
Phone: 508-910-6513
Office Hours: XXXXX
Class Time: XXXX
Class Location: XXXX

Course Objectives
Theories and techniques of database design, implementation, and application for data resource
management. Topics include data structure techniques for databases, data modeling techniques,
logical database design, physical database design, SQL, distributed database, and data warehouse.

Course Materials
Zybook: Database Systems with SQL and zyLabs home

1
Software Tools: MySQL Workbench, ACCESS

• You can use ACCESS and mySQL system through cors airdes ktop.um as s d.edu.
• You may also install the mySQL system yourself.
1) https://dev.mysql.com/downloads/installer/
2) https://dev.mysql.com/downloads/connector/odbc/

Evaluation Activities and Percentages

Items Evaluation Activities Percentages

1 2 Exams 50%
2 Assignments 50%
Total 100%

2
Grading Criteria:

Score Final Grade Score Final Grade

94% and Up A 73%-76.9% C
90%-93.9% A- 70%-72.9% C-
87% - 89.9% B+ 67% - 69.9% D+
83%-86.9% B 63%-66.9% D
80%-82.9% B- 60%-62.9% D-
77% - 79.9% C+ Less than 60% F

Substantive Participation Should:

• Add value to the discussion and avoid simply repeating, agreeing with, or answering yes
or no to peer’s comments.
• Challenge comments in class, including those of the facilitator.
• Ask insightful questions.
• Answer other people’s questions.
• Exemplify the point with real-life events, when possible.
• Make comments that are relevant to the course content and objectives.

Examples for Substantive Participation Include:

• Share an experience that is related to the discussion. Comment on other participants’
experiences that are related to the course.
• Ask other students questions about their ideas and experiences that are related to the
course.
• Challenge a point that another participant made in a respectful manner. Offer a different
perspective on an idea that is being discussed.
• Give insights gained from readings that were assigned for the week. If you need more
information, ask the participants a question about the week's reading.
• Discuss a work issue that is related to the course or discussion and ask for feedback.
• Relate how you have applied what you have read, learned or discussed regarding the
course to your personal and professional life.
• Share another resource such as Web links, books, etc. that you have used to answer other
participants’ questions or as you explore the topics of the course, (as it is a violation of
copyright law to copy the actual page).

3
 Tentative Schedule
Week Content
Syllabus
1
Chapter 1: Introduction to Database
2 2. Relational Databases
2. Relational Databases
3
3. Complex Queries
4 3. Complex Queries
5 4. Database Design
6 4. Database Design
7 5. Data Storage
Exam1
8
6. Transaction Management
9 6. Transaction Management

10 7. Database Architecture

11 8. Complex Data Types

12 9. Database Programming
13 10. NoSQL Databases
14 11. Case Study
12. MySQL Workbench
15
Exam 2 in Finals Week

Course Policies

University Policies: https://www.umassd.edu/provost/resourcesforfaculty/syllabus-language/

Statement Regarding Email as Official Means of Communication: Each student must have a
UMASS email address to be able to communicate with the professor, graduate assistant, and
students in the group or the class. Email communication will be sent only to official UMASS email
addresses. If you use a different email package at home, please ensure that your UMASS email is
forwarded correctly.

Assignments and Exams: No late assignments and exams will be accepted. Exceptions will be
made given extenuating circumstances such as a note from a doctor.

Ethical Behavior: Business professionals must be trusted, because they may have access to a wide
variety of confidential and personal information. Cheating will not be tolerated.

4
Changes in the Syllabus: Any administrative decisions regarding matters arising that are not
covered by the syllabus will be made on an “as-needed” basis. Students will be informed of any
changes in as timely a manner as possible.

Medical Needs: If you have any special learning or testing requirements please let me know as
soon as possible so special arrangement can be made. If you have any special medical condition
(e.g., epilepsy) that you feel it would be helpful for me to know about, let me know. If you have
any special needs in terms of evacuating the building in case of an emergency, let me know.

Getting to Know the University

Please visit the following web pages and read through the introduction.

1. Academic Resource Center: http://www1.umassd.edu/arc/

2. Career Development Center: http://www.umassd.edu/cdc/
3. Writing Center: http://www1.umassd.edu/arc/wrc/
4. Academic Advising Center: http://www1.umassd.edu/acadvising/welcome.cfm

If you are interested in getting to know more about centers in this university, please visit
http://www1.umassd.edu/campus/centers.cfm for more information about centers in this
University.