Class hours
Monday, Wednesday, Friday 12:00pm - 12:50pm EST, Rice Hall 130 (This course will be held in person)
Meet the team
Instructor: Upsorn Praphamontripong
Teaching Assistants
Jianing Cai,
Jared Conway,
Martin Crow,
Charles Fish,
Olivia Fountain,
Kevin Grieco,
Prateek Gunnam,
Parker Hutchinson,
Thumay Huynh,
Alex Kim,
Bailey Phillips,
Ary Suri
Overview
This course introduces the fundamental concepts for the design and development of database systems.
The course will focus on five main concepts:
- Database Design — design philosophies such as E-R and normalization
- Query Languages — SQL and relational algebra
- Database System Implementation — the basics of data storage, indexing, and transaction processing
- Database Programming — database interfacing, database security in web apps, SQL injection attacks and how to prevent them
- Database Types — while the majority of the semester will focus on centralized relational databases, this course briefly introduces distributed databases and NoSQL databases
Prerequisite
You must have passed CS 2150 or (CS 2100 and CS 2120) with a grade of C- or better, or COVID CR grade. Please note: the CS student services staff will monitor and remove students not meeting prerequisites in courses in which they are enrolled.
Textbook
In addition to the recommended book, you might find the following book useful if you require another explanation of a topic
Where appropriate, additional references that can be relevant for further reading will be provided on the Schedule page.
You should read the relevant material before class meeting. Doing so will allow you to ask specific questions in class that will further your understanding of the material and also better prepare you for class activities. The schedule for the readings is given on the Schedule page. The class meetings may not cover everything in the readings and will often include material not found in the readings (based on class discussion).
Learning activities
What you will do to succeed in learning? To facilitate your learning process, the course structure consists of five main activities: hands-on activities, practice-of-the-days, homework assignments, a semester project, and exams.
1. Hands-on activities
These hands-on activities scattered throughout the course serve as the main driver of your learning success. These activities help you to (i) understand the underlying concepts of database systems and apply them to design and implement databases, (ii) get started with specific theories and technologies, (iii) get ready to work on homework assignments and the project, (iv) prepare for the exams, and (v) practice skills database engineers need (such as technical skills, collaboration, and communication). Each activity is designed to get you to think about some specific aspect of the material we are learning that day. It helps you to develop competency in basic and advanced concepts.
We will do hands-on activities almost every class meeting. You are encouraged to work in small groups, allowing peer learning and imitating industrial software development scenarios.
Your engagement and participation is the most important aspect of your learning experience. If you fall behind for any reason, you should do your best to do the posted activity on your own to learn the material.
These activities will not be graded. Although no submission is required, you are encouraged to do all the activities.
Hands-on activities will form the basis for POTDs, homework assignments, the course project, and the exams.
2. Practice-of-the-days (POTDs)
Five main purposes of this activity are to help you to (i) refine your thoughts and reinforce the concepts, (ii) assess your understanding of the concepts in recent classes, (iii) get ready to work on homework assignments and the course project, (iv) prepare for the exams, and (v) practice skills database engineers need (such as technical skills, collaboration, and communication).
POTDs help you develop competency in basic and advanced concepts. This activity helps you to reinforce and assess your understanding of the concepts in recent classes. It also gives me an opportunity to work with you on any particular topics or skills that can be improved.
We will do POTDs on most Mondays, and some Wednesdays and Fridays. Most will be done in small groups and some will be individual exercises. You will submit your POTDs electronically. They will be graded on a completion basis. Full credit can only be received if it is complete and submitted by 12pm (noon) EST the next day. Any submission received after this time will be considered to be late. Details on submission guidelines will be provided on the POTD pages.
If you miss class, you should do the posted POTD on your own to learn the material.
POTDs will form the basis for homework assignments, the course project, and the exams.
3. Homework assignments
Homework assignments are the main mechanism to help you learn the fundamentals of database systems and database programming. Some homework assignments will be written and some will require programming. Most will allow collaboration to help you practice team working skills. The maximum limit will be 4 students.
Assignments will be posted on the class website and discussed in class. You will submit your homework assignments electronically. Requirements, specific grading criteria, and details on submission guidelines will be provided on the assignment pages.
Because each homework helps you master the database system concepts, it is important that you manage your time wisely. All homework assignments must be submitted before class on the day they are due — this will also help you focus on the class discussion instead of being worried about the homework. Any submission received after this time will be considered to be late.
You are expected to have a backup disk (or storage somewhere) for every assignment you turn in. In this way, if there is any problem with the copy that is handed in, the backup can be used for grading purposes.
The UVA Honor Code is in effect. Please refer to the collaboration and Professionalism sections of the course policies.
Homework assignments will form the basis for the course project and the exams.
4. Project
A project will provide you the opportunity to explore and experience database design and programming in practice. The project will entail the design of a database, with all accompanying evidence of its good design, along with front-end and back-end components that will interact with the database to provide common functionalities such as record inserting, updating, deleting, browsing, and searching and filtering.
You will collaborate with two or three other students in this course (the maximum group size is four). You will choose what to build, with the project constraining the features that must be used. The project must be complex enough so that it is not a trivial exercise, but cannot be so complex as to take longer than two months of effort.
You may choose to implement your project in one of the two ways:
- Web-based project — you will be provided with a MySQL database server and PHP-enabled webspace. However, you may use any programming language(s) and host your web application on any web server of your choice.
- Non-web-based project — you may host your project locally (i.e., on your machine)
By the end of the semester, you will have designed a working relational database and developed a realistic application. With a large portion of the process that involves teamwork, interpersonal skills and conflict management, and time management, this course will help you practice and prepare for your professional development.
To help you keep track of your progress, the project consists of several milestones (see the Project page for more information). Some milestones will be written and some will require programming. Because each project milestone is a step toward your final deliverable and your professional development, it is important that you manage your time wisely. Due dates are specified on the Schedule and project description pages. No late submission will be accepted.
At the end of the semester, we will have a "Showtime." As part of the project, all students are required to present their projects. You will demonstrate how your system works, and explain your design decisions and features. You are encouraged to discuss your classmates' design and implementation. You may find something interesting from their systems. This is a great opportunity to share ideas and opinions; you may learn something useful for your future projects. The fun part is, we will vote for "the most practical project" and "the coolest project."
You are expected to have a backup disk (or storage somewhere) for every project milestone you turn in. In this way, if there is any problem with the copy that is handed in the backup can be used for grading purposes.
The UVA Honor Code is in effect. Please refer to the collaboration and Professionalism sections of the course policies.
5. Exams
Exam1 and Exam2 are closed book/notes/web, paper-based, administered in class, no collaboration. The only exception is a single sheet of 8 1/2 x 11 paper (single / double-sided, your choice) with hand-written notes by the person taking the exam.
Only handwriting on a single sheet of paper is allowed. No writing on electronic device(s) and print.
Picture IDs are required to take the exam.
To request a make-up exam, please refer to the make-up exam policy.
Assessment
How will your learning be evaluated? The grade you will earn for this course will be based on how well you demonstrate your understanding.
Your overall score will be mapped to a letter grade as follows.
| You get | If you score |
| A+ | >= 98 |
| A | >= 93 |
| A- | >= 90 |
| B+ | >= 87 |
| B | >= 83 |
| B- | >= 80 |
| C+ | >= 77 |
| C | >= 73 |
| C- | >= 70 |
| D+ | >= 67 |
| D | >= 63 |
| D- | >= 60 |
| F | < 60 |
By default, grades will not be rounded or curved in this course, and there is no grade bump.
Grading concerns and appeals — All regrade requests must be made within one week of the graded work being returned to the student. See Policies for more details.
Cheating/Plagiarism/Professionalism Penalty — up to 100% penalty
Inappropriate behavior toward course staff (instructor and TAs) or classmates,
unauthorized homework assistance,
contacting TAs when they are not on the clock, etc.,
can result in a penalty up to and including a failing grade in the course.
This is independent of, and in addition to, the operations of the Honor Code.
Discussion board
We will use Piazza for a discussion board. In addition to in-person assistance, this is the place where you can seek help, offer help, share your thoughts and discoveries, or discuss technical difficulties and potential troubleshooting. Information for accessing our class Piazza site will be provided on the first day of class. Ask all technical questions about the material, the assignments, or the project on Piazza.
The sooner you begin asking questions on Piazza, the sooner you will benefit from the collective knowledge of your classmates, TAs and instructor.
Use Piazza — for questions related to course material, technical issues, and regrade requests.
Use email — for personal issues and emergencies.
Do not post code — any code at all — on a "public" thread in Piazza. Posting program source code publicly will usually be considered an honor code violation. If you need to include a "fragment" of your code in your post, please make your post "private" and tag instructor and all TAs.
Updates to the course will generally be noted on the Piazza page.
Submission site
We will be using Gradescope for student submissions (POTDs, Homework Assignments, Project). If you have not used Gradescope before, you may find an introduction on how to use Gradescope video helpful. If you have any questions or encounter any issues, please post your questions or concerns in the course Piazza.
Academic integrity
The School of Engineering and Applied Science relies upon and cherishes its community of trust. We firmly endorse, uphold, and embrace the University’s Honor principle that students will not lie, cheat, or steal, nor shall they tolerate those who do. We recognize that even one honor infraction can destroy an exemplary reputation that has taken years to build. Acting in a manner consistent with the principles of honor will benefit every member of the community both while enrolled in the Engineering School and in the future.
Students are expected to be familiar with the university honor code, including the section on academic fraud. Each assignment will describe allowed collaborations, and deviations from these will be considered Honor violations. If you are in doubt regarding the requirements, please consult with me before you complete any requirement of this course. Unless otherwise noted, exams, quizzes, and individual assignments will be considered pledged that you have neither given nor received help. Among other things, this means that you are not allowed to describe problems on an exam (or a quiz) to a student who is currently taking or has not taken it yet. You are not allowed to show exam (or quiz) papers (or copies) to another student or view another student’s exam (or quiz) papers while working on an exam (or a quiz). Sending, receiving, or copying electronic files that are part of course assignments are not allowed collaborations (except for those explicitly allowed in assignment instructions).
If course staff detect violations such as cheating, plagiarism, improperly sharing, copying another solution to an assignment (including portions thereof), or other dishonest behavior and honor code infractions, they may impose any penalty up to and including a failing grade (F) in the course. This is independent of and in addition to the operations of the Honor Code.
- 1st Offense: You will receive zero (0) points on that assessment and your final course grade will be reduced by one full letter grade (e.g., B- goes down to C-)
- 2nd Offense: Automatic F in the course
Students who have had prohibited collaborations may not be allowed to work with partners on remaining homework assignments.
SDAC and other special circumstances
It is my goal to create a learning experience that is as accessible as possible. If you anticipate any issues related to the format, materials, or requirements of this course, please meet with me outside of class so we can explore potential options. Students with disabilities may also wish to work with the Student Disability Access Center (SDAC) to discuss a range of options to removing barriers in this course, including official accommodations. We are fortunate to have an SDAC advisor, Courtney MacMasters, physically located in Engineering. You may email her at cmacmasters@virginia.edu to schedule an appointment. For general questions please visit the SDAC website: sdac.studenthealth.virginia.edu. If you have already been approved for accommodations through SDAC, please send me your accommodation letter and meet with me so we can develop an implementation plan together.
Religious accommodations
It is the University's long-standing policy and practice to reasonably accommodate students so that they do not experience an adverse academic consequence when sincerely held religious beliefs or observances conflict with academic requirements.
Students who wish to request academic accommodation for a religious observance should submit their request to me by email as far in advance as possible. Students who have questions or concerns about academic accommodations for religious observance or religious beliefs may contact the University's Office for Equal Opportunity and Civil Rights (EOCR) at UVAEOCR@virginia.edu or 434-924-3200.
Accommodations do not relieve you of the responsibility for completion of any part of the coursework missed as the result of a religious observance.
Safe environment
The University of Virginia is dedicated to providing a safe and equitable learning environment for all students. If you or someone you know has been affected by power-based personal violence, more information can be found on the UVA Sexual Violence website that describes reporting options and resources available – www.virginia.edu/sexualviolence.
The same resources and options for individuals who experience sexual misconduct are available for discrimination, harassment, and retaliation. UVA prohibits discrimination and harassment based on age, color, disability, family medical or genetic information, gender identity or expression, marital status, military status, national or ethnic origin, political affiliation, pregnancy (including childbirth and related conditions), race, religion, sex, sexual orientation, veteran status. UVA policy also prohibits retaliation for reporting such behavior.
If you witness or are aware of someone who has experienced prohibited conduct, you are encouraged to submit a report to Just Report It (justreportit.virginia.edu) or contact EOCR, the office of Equal Opportunity and Civil Rights.
If you would prefer to disclose such conduct to a confidential resource where what you share is not reported to the University, you can turn to Counseling & Psychological Services (CAPS) and Women's Center Counseling Staff and Confidential Advocates (for students of all genders).
As your course instructor and as a person, know that I care about you and your well-being and stand ready to provide support and resources as we can. As a faculty member, I am a responsible employee, which means that I am required by University policy and federal law to report certain kinds of conduct that you report to me to the University's Title IX Coordinator. The Title IX Coordinator's job is to ensure that the reporting student receives the resources and support that they need, while also determining whether further action is necessary to ensure survivor safety and the safety of the University community.
Student support team
If you are feeling overwhelmed, stressed, or isolated, there are many individuals here who are ready and wanting to help. The Student Health Center offers Counseling and Psychological Services (CAPS) for all UVA students. Call 434-243-5150 (or 434-972-7004 for after hours and weekend crisis assistance) to get started and schedule an appointment. If you prefer to speak anonymously and confidentially over the phone, Madison House provides a HELP Line at any hour of any day: 434-295-8255.
If you or someone you know is struggling with gender, sexual, or domestic violence, there are many community and University of Virginia resources available. The Office of the Dean of Students, Sexual Assault Resource Agency (SARA), Shelter for Help in Emergency (SHE), and UVA Women's Center are ready and eager to help. Contact the Director of Sexual and Domestic Violence Services at 434-982-2774.
There are many resources available to you when you experience academic or personal stresses. In addition to your instructor, the School of Engineering and Applied Science offers free tutoring, and has staff members located in Thornton Hall who you can contact to help manage academic or personal challenges. Please do not wait until the end of the semester to ask for help.
Learning
- Lisa Lampe, Assistant Dean for Undergraduate Affairs, academic-coaching, ll4uu@virginia.edu
- Director of Student Success (search underway)
- Courtney MacMasters, Accessibility Specialist cmacmasters@virginia.edu
Health and wellbeing
- Kelly Garrett, Assistant Dean of Students, Student Safety and Support, mwu5gs@virginia.edu
- Elizabeth Ramirez-Weaver, CAPS counselor
- Katie Fowler, CAPS counselor
You may schedule time with the CAPS counselors through Student Health When scheduling, be sure to specify that you are an Engineering student. You are also urged to use TimelyCare for either scheduled or on-demand 24/7 mental health care.
Community and Identity
The Center for Diversity in Engineering (CDE) is a student space dedicated to advocating for underrepresented groups in STEM. It exists to connect students with the academic, financial, health, and community resources they need to thrive both at UVA and in the world. The CDE includes an open study area, event space, and staff members on site. Through this space, we affirm and empower equitable participation toward intercultural fluency and provide the resources necessary for students to be successful during their academic journey and future careers.
Top
Acknowledgments:
** This course is generously supported by Google by giving us access to their
Cloud Platform.
Thanks to Professor Nada Basit and Professor Mary Smith for the input and material provided for this course; Professor Lindsay Wheeler and Professor Brian Helmke for suggestions on course redesign and improvement.
Copyright © 2024 Upsorn Praphamontripong
Released under the
CC-BY-NC-SA 4.0 license.
Last updated 2024-01-13 17:48