CS5530 Database Systems

Instructor: Feifei Li

[Overview] [Syllabus] [Textbook] [Schedule] [Slides] [Written Assignments] [Project] [YouTube Link] [Additional Resources] [Contact] 

Overview

Undergraduate-level introduction course to database systems and applications using databases. Introduce the ER model and its mapping to the relational data model. Study the logical language in the relational data model and its relationship to the practical relational query language: SQL. Examine in depth how to design and implement a database application. Understand how various programs are able to connect to the database through ODBC. Briefly cover indexing and hashing. Introduce the concept of transactions. Database integrity and security issues will also be briefly discussed. An important related topic is the social and ethical issues with data management. A semester-long project will build a web-based database system (e.g., an online bookstore) starting with a customer specification. In summary, the main focus of course is about the principles of designing and developing applications using the relational database system. Lastly, if schedule allows, we will also expand the discussion to NoSQL systems. In particular, we will discuss MongoDB as an example.

Syllabus

Syllabus for the course in PDF format:

Textbook

Database Management System by R. Ramakrishnan and J. Gehrke, 3rd Edition. Details and additional material supporting this book could be found here.

  Complementary Reading: Database Systems, The Complete Book, 2nd Edition. Details could be found here.

Schedule

Lecture: Monday, Wednesday, 11:50AM to 13:10PM, MEK 3550.

Office hour: Monday 2pm-3:30pm; Wednesday 2pm-3:30pm.

TA Office hour:
Rui Dai, Monday, 9:30-11:30am.
Elijah Grubb, Tuesday, 11am-1pm
Guineng Zheng, Wednesday, 3-5pm
Husan Lee, Thursday, 3-5pm
Dyllon Gagnier, Friday, 12-2:00pm

TA email address: utahdbta@gmail.com

Exam: Midterm: Wed, March 8; Final: Wednesday, May 3, 10:30am to 12:30pm.

Detailed weekly schedule can be found in the course syllabus.

Slides

Slides will be posted before each lecture. Updates to slides may be made after the lecture.
Lecture 1: Data Modelling: ER Diagram
Lecture 2: Data Modelling: Relational Model
Lecture 3: ER-Diagram to Relational Model
Lecture 4: Relational Algebra
Lecture 5: SQL
Lecture 6: Functional Dependency and Normalization
Lecture 7: Transaction
Lecture 8: Concurrency Control
Lecture 9: Disk, Buffer, and Files
Lecture 10: Access methods
Lecture 11: MapReduce and Spark
Lecture 13: NoSQL

Written Assignments

1. Assignment will be posted after it is announced in the class.
2. Solution will be posted once the assignment due date is passed. You can get the solutions by following the link below.
3. To work on more excises on your own, the solutions to all odd-numbered questions in the textbook are available here.

Enter your password:

Project

Project description will be available here once it's released.

YouTube Link to Lecture

Live streaming link: follow this link

Youtube channel link: follow this link

Additional Resources

Database Research: ACM SIGMOD  VLDB  IEEE ICDE

Database Products: ORACLE   Microsoft SQL Server  IBM DB2  PostgreSQL  MySQL MongoDB

Contact

Feifei Li (Instructor)     
Elijah Lloyd Grubb (half time TA)
Dyllon Gagnier (half time TA)
Rui Dai (TA)
Guineng Zheng (TM)
Hsuan Lee (TA)