ISBA 330 01: Database Management

ISBA 330 - Database Management

2023 Spring Syllabus, Section 01, CRN 15852

Course Information

You are responsible for knowing this material, so please read carefully. Any changes will be announced in a Blackboard Announcement. You will be responsible for any changes. Your continued enrollment in this course is your implicit agreement to abide by the requirements of this class.

This syllabus describes the requirements and procedures for Database Management. This course carries 3 credits. We meet Mondays, Wednesdays, and Fridays 12:20-1:10pm in Nistler Hall 207

Times and Location

MWF 12:20pm-1:10pm in Nistler, Rm 207

Instructor Information

Yanjun Zuo


Office: Nistler Hall 331-K

2023 Spring Office Hours:
Mon, Wed, Fri 10:00 a.m. to 11:00 a.m. and by appointment

Office Phone: (701) 777-6798

About the Professor

For information about your instructor, see Introduction to Class in Blackboard.

Course Description

This course covers the fundamentals of database design and management. Topics include, but not limited to, database models, database normalization, entity-relationship diagramming, SQL and database implementation and management. The course will provide a balance of theory and practical applications and will culminate in database implementation exercises conducted by students.

This course covers the fundamentals of database design and management. Topics include, but not limited to, database models, database normalization, entity-relationship diagramming, SQL, big data, and NoSQL databases. The course will provide a balance of theory and practical applications.

Learning Outcomes

After successfully completing this course, you should be able to:

  • Recognize the role of a database management system in an organization.
  • Explain basic database concepts, including the structure and operation of the relational data model.
  • Construct database queries using Structured Query Language (SQL).
  • Apply logical database design principles, including E-R diagrams and database normalization.
  • Describe big data and NoSQL databases.

Course Materials

Database Systems – Design, Implementation & Management by Carlos Coronel and Steven Morris, 13th Edition, 2019, ISBN: 978-1-337-62790-0.

Technical Requirements/Assistance

Whether you’re taking courses in the classroom or online, it’s important to have the right technology and equipment.  Visit the UND Technical Requirements webpage for more information. Students are expected to use their official UND email in the course. For technical assistance, please contact UND Technical Support at 701.777.2222. Visit the University Information Technologies (UIT) website for their hours, help documents and other resources.

Minimum Technical Skills Needed

In order to succeed in this course, at a minimum, you should be able to:

Insert minimum requirements expected and needed. In the bulleted example list below

  • Navigate in and use basic Blackboard functions
  • Download and open electronic documents
  • Create, save, and upload/attach electronic documents
  • Send, receive, and manage email

Course Logistics

Access and Log in Information

This course was developed and will be facilitated utilizing Blackboard. To get started with the course, please go to: and log in with your NDUS.Identifier, Username and Password. If you do not know your NDUS Identifier or have forgotten your password, please visit Your NDUS Account page on the UIT website.

Course Overview

The course content is organized into several lessons in the semester. Homework, labs, and exams will be used to assess your comprehension and application of those materials.


Many services are available to UND students such as writing assistance from the UND Writing Center, free online tutoring from Smarthinking, and more. Visit the Student Resources page for more information. Students also have access to the UND Student Resource Site via Blackboard. It is recommended that you become familiar with the tools and tutorials within the site to better equip you in navigating the course.

Course Requirements/Expectations

Insert the course requirements/expectations. An example is posted below.

  1. The student will review the syllabus and course schedule posted in Blackboard.
  2. The student will access and follow all course instructions found in the weekly area of the Blackboard course.
  3. The student will participate in any lecture or discussion sessions on campus or online as provided and as part of this course.
  4. The student will complete and submit assignments, exams, quizzes, etc. by the dated noted and in the manner described in Blackboard and on the course schedule. We will use Central Standard Time for due dates and times.
  5. The student will participate fully and in a timely manner to get the benefit of learning from instructor and/or peers.

Instructor Responsibilities and Feedback

  • The instructor will provide feedback on the assignments when they are graded.
  • The instructor will be available during appointed Office Hours to answer questions, provide feedback, and offer advice.



Announcements will be posted in Blackboard on a regular basis. Be sure to check the class announcements regularly as they will contain important information about class assignments and other class matters.


If you need to contact me directly, check the Faculty tab in Blackboard or the syllabus for my contact information. I will respond back to you within 48 hours during the week or weekend.

Course Etiquette

When participating in class (online or in person) it is important to interact with your peers in an appropriate manner. Always use professional language (no netspeak) in your postings and emails. Please be respectful of your classmates at all times even if you disagree with their ideas.




The mid-term exam carries 100 points



The course includes 7 homework. All those assignments are based on the materials covered in the class. Each homework is worth 10 or 20 points, which covers a set of written questions. 



The course includes 14 labs. Each lab carries 10 points and covers the practical database design/management practice.

Final Exam


The final exam carries 120 points.

Course Evaluation

Around the middle of the semester, we will complete a formative assessment to see how the course is going. Near the end of the semester, you will be asked to complete an online course evaluation form (SELFI). Your feedback on the course is extremely valuable to me. I read my students’ comments carefully and use them to improve the course the next time I teach it.
  • When the time comes, please let me know which aspects of the course helped you learn—and which aspects might be modified to help future students learn more effectively. 
  • Please note that the course evaluations are anonymous and that I won’t see the results until after the grades for the course are submitted, allowing you to provide honest and constructive feedback. 

And if you have feedback to offer before the end of the semester, please let me know.

Assessment Summary

Assignment                                               Final Grade

  1. Labs                                                                            140 Points
  2. Homework                                                                   120 Points
  3. Mid-term Exam                                                            100 Points
  4. Final Exam                                                                   120 Points

                  Total: 480 Points

Note: If you are taking this course for graduate credits, you are required to do extra work. The extra work can be a paper or a database project. The extra work carries 40 points. If you choose to write a paper, it must be at least 5 pages, 12-font, single spaced and one column. The project or paper must be closely related to our discussions on database in this class. The due day of the extra work is 5:00pm on May 5, 2023.

Final Grade Scale

A            90% to 100%

B            80% to 89%

C            70% to 79%

D            60% to 69%

F               0% to 59%

Schedule of Topics and Assignments

Day: Date: Reading(s): Agenda/Topic: Due:
Mon 1/9 Chp01
Wed 1/11 Chp01
Fri 1/13 Chp01
Mon 1/16 Chp01
Wed 1/18 Chp01 HW#1 due 5pm CST
Fri 1/20 Chp02
Mon 1/23 Chp02
Wed 1/25 Chp02 Lab #1 due 5pm CST
Fri 1/27 Chp02
Mon 1/30 Chp02
Wed 2/1 Chp02 HW#2 due 5pm CST
Lab #2 due 5pm CST
Fri 2/3 Chp03
Mon 2/6 Chp03
Wed 2/8 Chp03
Fri 2/10 Chp03 Lab #3 due 5pm CST
Mon 2/13 Chp03
Wed 2/15 Chp03
Fri 2/17 Chp03 HW#3 due 5pm CST
Lab #4 due 5pm CST
Mon 2/20 Chp04
Wed 2/22 Chp04
Fri 2/24 Chp04
Mon 2/27 Chp04 Lab #5 due 5pm CST
Wed 3/1 Chp04 Lab #6 due 5pm CST
Fri 3/3 Chp04
Mon 3/6 Chp04 HW#4 due 5pm CST
Lab #7 due 5pm CST
Wed 3/8 Mid-term Exam: 12:20-1:10pm
Fri 3/10 Spring break
Mon 3/13 Spring break
Wed 3/15 Spring break
Fri 3/17 Spring break
Mon 3/20 Chp05
Wed 3/22 Chp05
Fri 3/24 Chp05 Lab #8 due 5pm CST
Mon 3/27 Chp06
Wed 3/29 Chp06
Fri 3/31 Chp06
Mon 4/3 Chp06
Wed 4/5 Chp06 HW#5 due 5pm CST
Lab #9 due 5pm CST
Fri 4/7 Chp07
Mon 4/10 Chp07
Wed 4/12 Chp07
Fri 4/14 Chp07 Lab #10 due 5pm CST
Mon 4/17 Chp07
Wed 4/19 Chp07 Lab #11 due 5pm CST
Fri 4/21 Chp07
Mon 4/24 Chp07 Lab #12 due 5pm CST
Wed 4/26 Chp07 HW#6 due 5pm CST
Lab #13 due 5pm CST
Fri 4/28 Chp08 Lab #14 due 5pm CST
Mon 5/1 Chp14
Wed 5/3 Chp14
Fri 5/5 Chp14 HW#7 due 5pm CST
Wed 5/10 Final Exam: 10:15AM - 12:15PM

Course Policies

The section below contains examples of course policies you may wish to include in your course such as late work, class participation, netiquette, technology statements, etc.  You may fully edit this section to add and/or remove polices as they pertain to your course.

Assignment Policy

Due dates for each assignment or activity will be posted in Blackboard.

Late Work

Due dates for each homework and lab will be posted in Blackboard. All assignments (including the homework, labs and exams) must be submitted or conducted by the due dates or on the scheduled time.  No late submission will be accepted. All requirements for this course must be completed during the course dates.


It is expected that students will complete all requirements for a course during the time frame of the course. For reasons beyond a student’s control, and upon request by the student or on behalf of the student, an incomplete grade may be assigned by the instructor when there is reasonable certainty the student will successfully complete the course without retaking it. The mark “I,” Incomplete, will be assigned only to the student who has been in attendance and has done satisfactory work up to a time within four weeks of the close of the semester, including the examination period, and whose work is incomplete for reasons satisfactory to his or her instructor. More information regarding UND’s Incomplete policy can be found on The Grading System webpage.

Resolution of Problems

Should a problem occur, you should speak to your instructor first. If the problem continues to be unresolved, go to the department chair, and next to the college Dean. Should the problem persist, you have the right to go to the Provost next, and then to the President.


When participating in class (online or in person) it is important to interact with your peers in an appropriate manner. Netiquette is a set of rules for behaving properly online. Here are a few basic points to remember when communicating in this course:

Be scholarly. Use proper language, grammar, and spelling. Explain your thoughts, justify opinions, and credit the ideas of others by citing scholarly resources. Avoid misinforming others when you are unsure of the answer.  When discussing something and supplying a guess, clearly state that.

Be respectful. Respect the privacy of others. Do not share personal or professional information about others unless permission has been granted. Respect diversity and opinions that differ from their own. Be tactful when you communicate.

Be professional. Everyone should strive to give their best impression online. Truthfulness, accuracy, and running a final spell check are appropriate expectations for university students. Writing in a legible font and limiting the use of emoticons is considered professional behavior. Profanity and participation in hostile interactions, known as flaming, is unprofessional as well as disruptive.

Be polite. Students should address professors and instructors by the appropriate title or requested name. Students should interact online politely, just as they would be expected to do in a physical environment. Sarcasm, rudeness, and writing in all capital letters (shouting) should be avoided.


Everyone has the right to be addressed by the name and personal pronouns that correspond to their gender identity, including non-binary pronouns, for example: they/them/theirs, ze/zir/zirs, etc.

I recognize that preferred names and pronouns may change during the quarter, if at any point during the quarter you would like to be addressed differently, please let me know.

As part of our commitment to inclusion in this course, it is important that all students in this class respect the preferred names and pronouns of their peers. Mistakes in addressing one another may happen. If you make a mistake or are corrected, please briefly apologize and correct yourself.

Technology Statement

In this class we will have a technology policy that is designed to support your attention to one another and to the course material.  We will spend the majority of our time engaged in activities that depend upon you being present and attentive to one another, and course content we will study. We are all challenged these days by the ways in which our digital devices—including laptops, tablets, phones, and watches—can steal our attention away from our immediate surroundings. Technology should be used for educational purposes only during scheduled class times.

Collaboration and Recording (For Online, Hybrid, Hyflex courses)

Sharing personal experiences and opinions is an important part of the learning process. In the (hybrid, hyflex, synchronous, etc.) environment of this course, all of our interactions are recorded (via Zoom, Blackboard Collaborate Ultra, Yuja, etc) and made available to students in the course. The purpose of these recordings is to enhance learning for all students. If your peers make personal statements in this course, consider those comments in the context of our learning goals and do not share them with people outside the course. If you have questions or concerns about any recordings, please contact me.

College/Department Policies

Then Nistler college is committed to providing reasonable accommodations in all courses to students regardless of religious beliefs, disability status, or pregnancy status. To request an accommodation, you must do so during the first two weeks of the semester, by following the official UND procedure(s) described here Failure to follow official UND procedures in requesting accommodations will be considered as forfeiting the right to accommodation.

Nistler College of Business and Public Administration policies can be found at

University of North Dakota Policies & Resources

Academic Integrity

Academic integrity is a serious matter, and any deviations from appropriate behavior will be dealt with strongly. At the discretion of the professor, situations of concern may be dealt with as a scholastic matter or a disciplinary matter.

As a scholastic matter, the professor has the discretion to determine appropriate penalties for the student’s workload or grade, but the situation may be resolved without involving many individuals. An alternative is to treat the situation as a disciplinary matter, which can result in suspension from the University, or have lesser penalties. Be aware that I view this as a very serious matter and will have little tolerance and/or sympathy for questionable practices. A student who attempts to obtain credit for work that is not their own (whether that be on a paper, quiz, homework assignment, exam, etc.) will likely receive a failing grade for that item of work, and at the professor’s discretion, may also receive a failing grade in the course. For more information read the Code of Student Life.

Access and Opportunity, Disability Support, & Medical Services

The University of North Dakota is committed to providing equal access to students with documented disabilities. To ensure access to this class and your program, please contact Disability Services for Students (DSS) to engage in a confidential discussion about accommodations for the classroom and clinical settings. Accommodations are not provided retroactively. Students are encouraged to register with DSS at the start of their program. More information can be obtained by email or by phone at 701.777.2664.


UND is committed to maintaining a safe learning environment while providing quality learning experiences for our students. COVID-19’s continued presence within our UND community may necessitate changes in classroom management as the academic year progresses. As such, UND asks students and instructors to be flexible when necessary to promote a safe environment for learning. Please do not attend an in-person class or lab if you are feeling ill, particularly if you are experiencing symptoms of COVID-19, or if you have been directed by health professionals to quarantine or isolate. If you are not able to attend class or lab, please notify your instructor as soon as possible and discuss options for making up any missed work in order to ensure your ability to succeed in the course. If you will have an extended absence due to serious illness or other uncontrollable circumstances, you may request an absence notification through the Office of Student Rights and Responsibilities. Similarly, if your instructor is ill they may need to cancel class or temporarily move your course to online delivery to ensure that you are able to complete the course successfully.  Instructors may require students to wear masks in the classroom or in the laboratory as a preventative measure designed to facilitate uninterrupted classroom engagement and to facilitate health and safety in the classroom.   If your instructor does require masks in class or in a laboratory, you are expected to comply with that request.

UND also strongly encourages all members of the University community, including students, to get vaccinated, seek out testing when needed, and model positive behavior both on- and off-campus to foster a healthy and safe learning environment for all students. Individuals who would like to discuss disability accommodations regarding masks should contact the Disability Services for Students (DSS) office at 701.777.2664 or Individuals who are unable to wear a mask due to a sincerely held religious belief should contact the UND Equal Opportunity and Title IX Office at 701.777.4171 or

Religious Accommodations

UND offers religious accommodations, which are reasonable changes in the academic environment that enable a student to practice or observe a sincerely held religious belief without undue hardship on the University. Examples include time for prayer or the ability to attend religious events or observe a religious holiday. To request an accommodation, complete the student religious accommodation request form. If you have any questions, you may contact the Equal Opportunity & Title IX Office.

Pregnancy Accommodations

Students who need assistance with academic adjustments related to pregnancy or childbirth may contact the Equal Opportunity & Title IX Office or Academic Affairs to learn about your options. Additional information and services may be found at Pregnancy Resources.

Notice of Nondiscrimination

It is the policy of the University of North Dakota that no person shall be discriminated against because of race, religion, age, color, gender, disability, national origin, creed, sexual orientation, gender identity, genetic information, marital status, veteran’s status, or political belief or affiliation and the equal opportunity and access to facilities shall be available to all. Concerns regarding Title IX, Title VI, Title VII, ADA, and Section 504 may be addressed to Donna Smith, Assistant Vice President for Equal Opportunity & Title IX and Title IX/ADA Coordinator, 102 Twamley Hall, 701.777.4171, or the Office for Civil Rights, U.S. Dept. of Education, 230 S. Dearborn St., 37th Floor, Chicago, IL 60604 or any other federal agency.

Reporting of Discrimination, Harassment, or Sexual Misconduct

If you or a friend has experienced sexual misconduct, such as sexual harassment, sexual assault, domestic violence, dating violence, or stalking, please contact the Equal Opportunity & Title IX Office or UND’s Title IX Coordinator, Donna Smith, for assistance: 701.777.4171;; or visit the Title IX webpage. You may also contact the Equal Opportunity & Title IX office if you or a friend has experienced discrimination or harassment based on a protected class, such as race, color, national origin, religion, sex, age, disability, sexual orientation, gender identity, genetic information, pregnancy, marital or parental status, veteran's status, or political belief or affiliation.

Faculty Reporting Obligations Regarding Discrimination, Harassment, or Sexual Misconduct

It is important for students to understand that faculty are required to share with UND’s Title IX Coordinator any incidents of sexual misconduct or of discrimination or harassment based on a protected class that they become aware of, even if those incidents occurred in the past or are disclosed as part of a class assignment. This does not mean an investigation will occur if the student does not want that, but it does allow UND to provide resources to help the student continue to be successful at UND. If you have been impacted by discrimination, harassment, or sexual misconduct, you can find information about confidential support services on the Equal Opportunity & Title IX webpage..

UND Cares Program

How to Seek Help When in Distress

We know that while college is a wonderful time for most students, however, some students may struggle or have issues that arise. You may experience students in distress on campus, in your classroom, in your home, and within residence halls. Distressed students may initially seek assistance from faculty, staff members, their parents, and other students. In addition to the support we can provide to each other, there are also professional support services available to students through the Dean of Students and University Counseling Center. Both staffs are available to consult with you about getting help or providing a friend with the help that he or she may need. For more additional information, please visit the UND Cares Program Webpage.

How to Recognize When a Student is in Distress

The term “distressed” can mean any of the following:

  • Student has significant changes in eating, sleeping, grooming, spending, or other daily activities.
  • Student has cut off or minimized contact with family or friends.
  • Student has significant changes in performance or involvement in academics, sports, extracurricular, or social activities.
  • Student describes problems (missing class, not remembering, destructive behavior) that result from experiences with drinking or drugs.
  • Student is acting withdrawn, volatile, tearful, etc.
  • Student is acting out of character or different than usual.
  • Student is talking explicitly about hopelessness or suicide.
  • Student has difficulty concentrating or difficulty carrying on a normal conversation.
  • Student has excessive dependence on others for company or support.
  • Student reports feeling out of control of one’s emotions, thoughts, or behaviors.

Land Acknowledgement Statement

Today, the University of North Dakota rests on the ancestral lands of the Pembina and Red Lake Bands of Ojibwe and the Dakota Oyate - presently existing as composite parts of the Red Lake, Turtle Mountain, White Earth Bands, and the Dakota Tribes of Minnesota and North Dakota. We acknowledge the people who resided here for generations and recognize that the spirit of the Ojibwe and Oyate people permeate this land. As a university community, we will continue to build upon our relations with the First Nations of the State of North Dakota - the Mandan, Hidatsa, and Arikara Nation, Sisseton-Wahpeton Oyate Nation, Spirit Lake Nation, Standing Rock Sioux Tribe, and Turtle Mountain Band of Chippewa Indians.

Additional Resources

It is my goal to foster an environment of mutual respect in which everyone feels comfortable voicing their opinions, sharing their stories, and learning about potentially heavy or personally relevant material. If, at any point, you feel like the information covered in this class elicits thoughts, feelings, or concerns that you would like to discuss further, don’t hesitate to reach out to me, or the UND Counseling Center (701-777-2127).

Further, if you experience extenuating circumstances, sexual violence, identity-based harm, or any other personal crisis during the semester, don’t hesitate to reach out to me so we can provide academic assistance and help you in this course, and put you in contact with the appropriate resources and services (if needed).