Southern Utah University

Course Syllabus

Southern Utah University
Southern Utah University
Fall Semester 2025

Database Design and Management (Face-to-Face)

CSCY 3200-01

Course: CSCY 3200-01
Credits: 3
Term: Fall Semester 2025
Department: CSIS
CRN: 30375

Course Description

Introduction to database management systems, database processing, data modeling, and database design, development, and implementation. Contrasts alternative modeling approaches. Includes implementation of current DBMS tools and SQL.

Required Texts

Required Textbook/Materials:

  • Ricardo, Urban and Davis, Databases Illuminated, 4th edition. Jones and Bartlett. ISBN 9781284232158. Course ID: 283378
  • Link to purchase eBook for Labs
  • Course Notes and Handouts

Learning Outcomes

Course Learning Outcomes:

  • Explain the conceptual, logical, and physical models of a relational database.
  • Explain the concepts of keys, foreign keys, and referential integrity.
  • Write SQL statements to create, query, and update a relational database.
  • Explain normalization and its role in database design.
  • Design and implement a relational database.
  • Understand database security issues and vulnerabilities, such as SQL injection, and implement security measures.
  • Learn about database security models.
  • Learn about alternatives to relational databases, such as flat, network, object-based, object-oriented, and NoSQL.

Course Requirements

Course Requirements

  • Access to a computer where you can download and install the assigned software.
  • Reliable Internet connection and necessary software.
  • Access to Canvas.
All assignments and discussions for this course will be submitted electronically through Canvas unless otherwise instructed.
Acceptable and Unacceptable Use of AI
The use of generative AI tools is permitted for brainstorming and refining ideas, finding information (students are responsible for verifying it), and checking grammar and style. It is not permitted for impersonation, completing individual or group work assigned to you, writing drafts of assignments, or writing entire sentences, paragraphs, or papers to complete class assignments. Unauthorized use will result in a zero for the assignment. AI usage must be properly documented and cited.
Grading Plan
Points for each assignment and quiz can be found on Canvas. Each assignment has a grading rubric available for students to view on Canvas.
Labs | 25%
Quizzes | 15%
Tests | 20%
Final Exam | 15%
Database Project | 25%
Total | 100%
Grading Scale
94 - 100 | A
90 - 93 | A-
87 - 89 | B+
84 - 86 | B
80 - 83 | B-
77 - 79 | C+
74 - 76 | C
70 - 73 | C-
67 - 69 | D+
64 - 66 | D
61 - 63 | D-
Below 61 | F
Major assignment and examination
1. Labs 25%
         Lab1: Interpreting Entity-Relationship Diagrams
         Lab2: Designing Entity-Relationship Diagrams
         Lab3: Writing Relational Algebra Queries Using RelaX
         Lab4: Forward Engineering Entity-Relationship Diagrams to Relational Schemas
         Lab on SQL1: Create a database schema
         Lab on SQL2: Implement SQL Queries
         Lab on SQL-Northwind: Create the Northwind Database.

2. Quizzes 15%
         Quiz1: On Chapter 1: Introductory Database Concepts
         Quiz2: On Chapter 2: Database Planning and Database Architecture
         Quiz3: On Chapter 3: The Entity-Relationship Model
         Quiz4: On Chapter 4: The Relational Model
         Quiz5: On Chapter 5: Relational Database Management Systems and SQL
         Quiz6: On Chapter 6: Normalization and De Normalization
         Quiz7: On Chapter 7: Big Data and NoSQL
         Quiz8: On Chapter 8: Introduction to Database Security
3. Tests 20%
         Test1.
         Test2.

4. DB Project 25%
         Database Project (DB Project) Phase 1
         DB Project Phase 2
         DB Project Phase 3
         DB Project Phase 4
         DB Project Phase 5
         DB Project Final Submission and Project Presentations

5. Final Exam 15%
       
Covers the entire course chapters. 

Course Outline

Course Schedule

Note: Schedule subject to change. Any modifications will be announced via Canvas.

WeekTopicAssignments
1Chapter 1: Introductory Database Concepts
2Chapter 2: Database Planning and Database Architecture
3Chapter 3: The Entity-Relationship ModelLab 1
4Chapter 4: The Relational ModelLab 2
5Test 1Lab 3, Lab 4
6Chapter 5: Relational Database Management Systems and SQL
7Chapter 6: Normalization and DenormalizationLab 5
8Chapter 7: Advanced SQL
9Test 2Lab 6
10Chapter 8: Introduction to Database Security
11Chapter 14: Big Data and NoSQLLab 7
12Chapter 14: Big Data and NoSQLLab 8
13Chapter 11: Transaction ManagementProject Workday
14Database AdministrationProject Workday
15Project WorkdayDB Project Presentations
16Finals WeekFinal Exam Dec 10, ELC 311, 1:00 pm – 2:50 pm

Instructor's policies on late assignments and/or makeup work

All assignments and discussions must be submitted by the given deadline or special permission must be requested from the instructor before the due date. Extensions will not be given beyond the next assignment except under extreme circumstances. Late or missing assignments and discussions will affect the student’s grade.

Assignments and quizzes are due when specified and may be accepted up to 3 days after their specified due date with a 20% deduction or at the discretion of the instructor. Access to assignments and quizzes will be restricted three days after the specified due dates. Students unable to complete an assignment or quiz by the due date must make prior arrangements with the instructor. This restriction is lifted during the first week of classes to accommodate late enrollment.

Attendance Policy

Attendance and Participation Requirements:

  • Class attendance is mandatory for face-to-face classes.
  • Students may miss class only for authorized reasons (athletic events, academic travel, special ceremonies, etc.).
  • Illness and personal emergencies may also cause students to be absent for legitimate reasons.
  • If absent, students should notify the instructor in advance with evidence.
  • Students are responsible for any material covered in class.
  • If a student will miss an exam or major graded requirement, they must coordinate completion/submission requirements with the instructor.
  • Active participation in class discussions and activities is expected.

Course Fees

All CSIS classes have a per credit hour student fee. These fees go toward funding mediated classes, computer labs, software upgrades and licenses, printer paper and toner, and other student-related costs.

Custom

Prerequisites

CS 2420 - Introduction to Algorithms and Data Structures (Minimum Grade: C)

Instructor Information

Instructor: Prosenjit Chatterjee, PhD

Class Time(s): MW 1:00 pm – 2:15 pm, ELC 311

Office: ELC 414

Phone: 435-865-8399

Email: prosenjitchatterjee@suu.edu

All office hours meetings require appointments by email at least 24 hours in advance.

Canvas Information

Canvas is where course content, grades, and communication will reside for this course. Students must check Canvas regularly.

Technical Support:

Canvas Help:

Email

Assignments will not be accepted via email. Check your SUU email frequently (at least once daily).

Academic Integrity

Scholastic dishonesty will not be tolerated and will be prosecuted to the fullest extent. Violations may result in a zero for the assignment or an F in the course, and University officials will be notified. Withdrawal to avoid transcript impact is not permitted.

ADA Statement

Students with disabilities desiring academic adjustments, accommodations, or auxiliary aids should contact the SUU Coordinator of Services for Students with Disabilities in Room 206G Sharwan Smith Center or phone (435) 865-8022.

Emergency Management Statement

In case of emergency, the University's Emergency Notification System (ENS) will be activated. Maintain updated contact information on mySUU and familiarize yourself with Emergency Response Protocols posted in each classroom. Details at SUU Emergency Procedures.

HEOA Compliance Statement

Sharing copyrighted material through peer-to-peer file sharing, except as provided under U.S. copyright law, is prohibited. Details at SUU P2P Notice.

Disclaimer

Information in this syllabus, other than grading, late assignments, makeup work, and attendance policies, may be subject to change with advance notice.

Continuity of Instruction (COI)

During any event that suspends face-to-face instruction, check SUU email and Canvas announcements for instructions.

Online Course Requirements

  • Computer
  • Reliable Internet connection and software
  • Access to Canvas
  • Webcam
  • Scanning capability

SUU Campus Resources and Services

Review Campus Resources and Services and the Student Handbook.

Financial Security Statement

If you are struggling financially, visit the Financial Wellness Center in room 201C Sharwan Smith Center, contact Ashleigh Zimmerman at (435) 865-8436, or text 435-708-1952.

General Health Practice Statement

University leadership recommends modeling the following health practices:

  • Vaccination
  • Daily health self-assessment
  • Coronavirus testing
  • Hand hygiene (wash hands for at least 20 seconds or use sanitizer)
  • Cover coughs and sneezes
  • Social distancing (stay at least six feet apart)
  • Mask usage as recommended

ADA Statement

Students with medical, psychological, learning, or other disabilities desiring academic adjustments, accommodations, or auxiliary aids will need to contact the Disability Resource Center, located in Room 206F of the Sharwan Smith Center or by phone at (435) 865-8042. The Disability Resource Center determines eligibility for and authorizes the provision of services.

If your instructor requires attendance, you may need to seek an ADA accommodation to request an exception to this attendance policy. Please contact the Disability Resource Center to determine what, if any, ADA accommodations are reasonable and appropriate.

Academic Credit

According to the federal definition of a Carnegie credit hour: A credit hour of work is the equivalent of approximately 60 minutes of class time or independent study work. A minimum of 45 hours of work by each student is required for each unit of credit. Credit is earned only when course requirements are met. One (1) credit hour is equivalent to 15 contact hours of lecture, discussion, testing, evaluation, or seminar, as well as 30 hours of student homework. An equivalent amount of work is expected for laboratory work, internships, practica, studio, and other academic work leading to the awarding of credit hours. Credit granted for individual courses, labs, or studio classes ranges from 0.5 to 15 credit hours per semester.

Academic Freedom

SUU is operated for the common good of the greater community it serves. The common good depends upon the free search for truth and its free exposition. Academic Freedom is the right of faculty to study, discuss, investigate, teach, and publish. Academic Freedom is essential to these purposes and applies to both teaching and research.

Academic Freedom in the realm of teaching is fundamental for the protection of the rights of the faculty member and of you, the student, with respect to the free pursuit of learning and discovery. Faculty members possess the right to full freedom in the classroom in discussing their subjects. They may present any controversial material relevant to their courses and their intended learning outcomes, but they shall take care not to introduce into their teaching controversial materials which have no relation to the subject being taught or the intended learning outcomes for the course.

As such, students enrolled in any course at SUU may encounter topics, perspectives, and ideas that are unfamiliar or controversial, with the educational intent of providing a meaningful learning environment that fosters your growth and development. These parameters related to Academic Freedom are included in SUU Policy 6.6.

Academic Misconduct

Scholastic honesty is expected of all students. Dishonesty will not be tolerated and will be prosecuted to the fullest extent (see SUU Policy 6.33). You are expected to have read and understood the current SUU student conduct code (SUU Policy 11.2) regarding student responsibilities and rights, the intellectual property policy (SUU Policy 5.52), information about procedures, and what constitutes acceptable behavior.

Please Note: The use of websites or services that sell essays is a violation of these policies; likewise, the use of websites or services that provide answers to assignments, quizzes, or tests is also a violation of these policies. Regarding the use of Generative Artificial Intelligence (AI), you should check with your individual course instructor.

Emergency Management Statement

In case of an emergency, the University's Emergency Notification System (ENS) will be activated. Students are encouraged to maintain updated contact information using the link on the homepage of the mySUU portal. In addition, students are encouraged to familiarize themselves with the Emergency Response Protocols posted in each classroom. Detailed information about the University's emergency management plan can be found at https://www.suu.edu/emergency.

HEOA Compliance Statement

For a full set of Higher Education Opportunity Act (HEOA) compliance statements, please visit https://www.suu.edu/heoa. The sharing of copyrighted material through peer-to-peer (P2P) file sharing, except as provided under U.S. copyright law, is prohibited by law; additional information can be found at https://my.suu.edu/help/article/1096/heoa-compliance-plan.

You are also expected to comply with policies regarding intellectual property (SUU Policy 5.52) and copyright (SUU Policy 5.54).

Mandatory Reporting

University policy (SUU Policy 5.60) requires instructors to report disclosures received from students that indicate they have been subjected to sexual misconduct/harassment. The University defines sexual harassment consistent with Federal Regulations (34 C.F.R. Part 106, Subpart D) to include quid pro quo, hostile environment harassment, sexual assault, dating violence, domestic violence, and stalking. When students communicate this information to an instructor in-person, by email, or within writing assignments, the instructor will report that to the Title IX Coordinator to ensure students receive support from the Title IX Office. A reporting form is available at https://cm.maxient.com/reportingform.php?SouthernUtahUniv

Non-Discrimination Statement

SUU is committed to fostering an inclusive community of lifelong learners and believes our university's encompassing of different views, beliefs, and identities makes us stronger, more innovative, and better prepared for the global society.

SUU does not discriminate on the basis of race, religion, color, national origin, citizenship, sex (including sex discrimination and sexual harassment), sexual orientation, gender identity, age, ancestry, disability status, pregnancy, pregnancy-related conditions, genetic information, military status, veteran status, or other bases protected by applicable law in employment, treatment, admission, access to educational programs and activities, or other University benefits or services.

SUU strives to cultivate a campus environment that encourages freedom of expression from diverse viewpoints. We encourage all to dialogue within a spirit of respect, civility, and decency.

For additional information on non-discrimination, please see SUU Policy 5.27 and/or visit https://www.suu.edu/nondiscrimination.

Pregnancy

Students who are or become pregnant during this course may receive reasonable modifications to facilitate continued access and participation in the course. Pregnancy and related conditions are broadly defined to include pregnancy, childbirth, termination of pregnancy, lactation, related medical conditions, and recovery. To obtain reasonable modifications, please make a request to title9@suu.edu. To learn more visit: https://www.suu.edu/titleix/pregnancy.html.

Disclaimer Statement

Information contained in this syllabus, other than the grading, late assignments, makeup work, and attendance policies, may be subject to change with advance notice, as deemed appropriate by the instructor.