Class Meetings and Locations:
51055: MWF 2:00 PM to 2:50 PM in room ART 1.110
Instructor:
Email: mpalacio@cs.utexas.edu
Office: GDC 5.418
Course Description:
This course is designed to present concepts of database design and database system implementation, data models, query processing, database design theory, crash recovery, concurrent control, and distributed databases.
The primary skills developed in this course are data modeling, achieving performant SQL and enabling students to better configure relational database management systems (RDBMSs) as a result of learning how RDBMSs are organized, and the algorithms integral to each architectural component. A “from first-principles approach” provides a foundation for understanding and addressing the same issues as they arise in other kinds of database management systems that are emerging as real alternatives to RDBMSs.
Below are some of the topics we will cover:
Prerequisites:
The prerequisites for this course are CS 429 or CS 429H with a grade of at least C-.
Textbooks:
The required textbook for this course is:
David M. Kroenke; David J. Auer; Scott L. Vandenberg. Database Processing: Fundamentals, Design, and Implementation, 16th Edition, 2022, Pearson.
Supplemental Readings:
There is an additional, on-line textbook for this course:
Alvaro Monge. Database design with UML and SQL, 4th Edition.
Grading Rubric:
The grading rubric is comprised of the components listed below:
Note: The final grade will use the plus/minus grading system.
Projects:
There will be 5 projects, each one due as indicated in the course schedule. They are designed to exercise important concepts in the course material, and they are aimed at giving you hands-on practice with the selected database systems.
They will require outside-class time to complete. All projects will be carried out in groups of two students. You will form groups at the start of the term and work with the same partner throughout the term. Both students will receive the same grade for each project.
All projects must run on the prescribed platforms. You will need to be able to access those platforms in order to prepare and test your project work.
Late projects are eligible for partial credit, although they will not be accepted without prior arrangements (i.e., letting me know in advance). Note that late projects will incur a penalty of 20% per day, for up to 2 days, after which time they will not be accepted at all.
Absences:
Excused absences may be given only for verifiable medical or family emergencies. Written documentation must be provided to qualify for an excused absence. The medical documentation must specifically state that you could not attend class due to your illness and must be signed by a physician. A job or internship interview or any other appointment does not constitute an excused absence.
Sexual Misconduct Reporting (SB 212):
Beginning January 1, 2020, Texas Senate Bill 212 requires all employees of Texas universities, including faculty, report any information to the Title IX Office regarding sexual harassment, sexual assault, dating violence and stalking that is disclosed to them. Texas law requires that all employees who witness or receive any information of this type (including, but not limited to, writing assignments, class discussions, or one-on-one conversations) must be reported. If you would like to speak with someone who can provide support or remedies without making an official report to the university, please email advocate@austin.utexas.edu. For more information about reporting options and resources, visit http://www.titleix.utexas.edu/, contact the Title IX Office via email at titleix@austin.utexas.edu, or call 512-471-0419.