Syllabus
Catalog description: An introduction to database design and management with emphasis on data definition, data manipulation and query languages found in modern database management systems. 3 credits.
Prerequisite: A grade of "C–" or better in CS 240 or CS 343 or equivalent.
Section 1: Dr. Rizvi¶
Tu/Th 12:45–2:00pm in King Hall 260
Dr. Mona Rizvi, Associate Professor of Computer Science
Email: elkadima@jmu.edu | Office Phone: 540-568-2775
The best way to contact me is by email or Telegram @maerizvi.
Office Hours: Tues 9:30–10:30am, Wed 1:00–4:00pm, Thurs 2:30–3:30pm in King 253 or online by appointment.
Section 2: Dr. Mayfield¶
Tu/Th 2:20–3:35pm in EnGeo 2209
Dr. Chris Mayfield, Professor of Computer Science
Email: mayfiecs@jmu.edu | Office Phone: 540-568-3314
The best way to contact me is by email, not via Canvas.
Office Hours: M/W/F 12:30–1:30 and Tu/Th 1:00–2:00 in King 208 or online.
Course Objectives¶
By the end of CS 374, you should be able to:
- Summarize features of the relational model including structured data, relational operations, and integrity constraints.
- Construct a conceptual model (E/R diagram) and a physical model (relational design) from a general data description.
- Illustrate anomalies and inconsistencies that can occur within a database design and how to correct them.
- Write analytical queries in SQL (select, project, inner/outer join, grouping, aggregation, sorting, distinct, subqueries).
- Design and implement a substantial three-tier application, both individually and with others.
- Manage a successful semester-long team project (communication, source control, frequent code reviews).
Last but not least, you should have fun exploring and working with several exciting database technologies this semester!
Required Textbook¶
Painter‑Wakefield, Christopher. (Aug 2023). A Practical Introduction to Databases. Runestone Academy.
"This book was created to fill the need for a low-cost [free], up-to-date textbook suitable for an introductory course on databases… The book is oriented to students encountering databases for the first time, with a focus on key skills needed by future software engineers."
Getting the Book
From the Runestone Registration page:
- Create a username that you will remember
- IMPORTANT – enter your JMU dukes email
- Make up a new password you will remember
- Use
jmu_cs374_fa25for the course name
Culture of Learning¶
Please help us maintain a collaborative environment that encourages questions, provides opportunities for significant learning, and actively involves everyone in discussions.
Professional Conduct¶
The ACM Code of Ethics (https://www.acm.org/code-of-ethics) forbids discrimination and harassment of all types. If you believe someone is violating these principles (e.g., by making inappropriate or demeaning remarks), it is your responsibility to take action by informing me or, if you feel comfortable doing so, addressing the individual directly. I will do my best to preserve your confidentiality when addressing the issue.
Inclusive Excellence¶
Learning environments should be built on mutual respect and support a diversity of thoughts, perspectives, experiences, and identities. Please advise me regarding any concerns or personal circumstances (including your name's proper pronunciation, any name or pronouns not reflected on MyMadison, or significant extracurricular commitments) that would be relevant to your full participation in this course.
Academic Honesty¶
Don't Cheat
Students who violate the Honor Code (https://www.jmu.edu/honorcode/code.shtml) will receive a reduced or failing grade in the course. Other penalties may be imposed, and all violations will be reported to the Honor Council. Automated tools may be used on any assignment, at any time, to detect inappropriate collaboration and the originality of submissions.
Generative AI
You may use AI technology in general ways that support your learning. However, do not ask ChatGPT or similar tools to do your homework for you. AI will not be available during exams, so make sure you can program without AI. See the Student Guide to Artificial Intelligence for examples of appropriate use.
Methods of Evaluation¶
Participation¶
You are encouraged to work with other students during class. In-class activities and out-of-class readings have points, because your participation impacts others. If you are occasionally absent, you will have the opportunity to make up missed work.
Homework¶
To help prepare you for the midterm and final exams, you will individual homework assignments. Written assignments will be submitted electronically via Canvas or Gradescope.
Late Work Policy
Deadlines exist so that we can discuss solutions in class. Therefore, late work will not be accepted without special permission. I am willing to work with you if your circumstances suddenly change. Please don't wait until the night before to get started!
Group Project¶
Throughout the course, you will work in a group of 3–4 students. Each group will design, implement, and present a database and a web application. The project will require deliverables, performance evaluations, and code reviews.
Midterm/Final¶
This course is inherently cumulative; each week builds on the prior weeks. We will have an in-class midterm before fall break and a two-hour exam during finals week. The content and format of the exams will be similar to the assignments.
Grading Criteria¶
Your grade in CS 374 will be based on:
Letter grades will be assigned on the scale A=90–100, B=80–89, C=70–79, D=60–69, F=0–59, with potential minor adjustments after considering the overall performance of the class and actual distribution of numeric scores. We will use + and – grades at our discretion. We do not assign WP or WF grades except in unusual circumstances.
University Requirements¶
Adding/Dropping¶
You are responsible for enrolling in courses and verifying your schedule on MyMadison. The last day to add a semester course without department permission is Friday, 08/29/2025. The last day to withdraw from a course with a W grade is Tuesday, 10/21/2025.
Attendance Policy¶
You are expected to participate in every class. We understand that things come up, and you might need to be absent occasionally. That's why we provide make-up opportunities for in-class work. If you are not feeling well or suspect you might be ill, please stay at home.
Disability Services¶
If you have a documented disability and need accommodations in this course, please register with the Office of Disability Services (http://www.jmu.edu/ods, Student Success Center, Room 1202, 540-568-6705). ODS will provide you with an Access Plan Letter to verify your need for services and make recommendations for the course.
Excused Absences¶
Students who are unable to attend class due to JMU sponsored activities (such as sports, band, academic competition, field trips, etc.) or personal religious observances may request reasonable accommodations. Please notify me during the first week of class regarding potential absences so that you and I can plan ahead.
University Closings¶
Given severe weather and other unexpected circumstances, be sure to watch for announcements relating to make-up dates. See http://www.jmu.edu/JMUpolicy/1309.shtml for JMU's cancellation policy. Although the schedule may adapt to canceled classes, assignment deadlines generally do not change.
Your Well-Being¶
As a university student, there may be times when personal stressors interfere with your academic performance and/or negatively impact your daily life. If you or someone you know is experiencing mental health challenges at James Madison University, please connect with the Counseling Center located within the Student Success Center on the 3rd floor. You can learn more about available services by visiting https://www.jmu.edu/counselingctr or calling 540-568-6552. These services are free and confidential. Other available support resources to consider include, but are not limited to, the Office of the Dean of Students, the Health Center, and Learning Strategies Instruction.