CS5530 Database Systems

Instructor: Feifei Li

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

Overview

Undergraduate-level introduction to database systems and applications using databases. Introduces the ER model and its mapping to the relational data model. Studies the logical language in the relational data model and its relationship to the commercial relational query language: SQL. Examines in depth how to design a database conforming to different normal forms. Understand how various programs are able to connect to the database through ODBC. Briefly covers indexing and hashing. Finally, we will cover database integrity and security. An important related topic is the social and ethical issues with data management, examples include but not limit to data privacy, laws and technologies that protect data, encryption and interception of information. Furthermore, students will participate in a semester-long project and build a web-based database system (e.g., an online bookstore) starting with a customer specification. In summary, this course is about the principles of designing and developing applications using the relational database system.

Announcements

       01/02/13: Course website is up. Course syllabus is ready for review.
       01/02/13: Please sign up for the class mailing list at https://sympa.eng.utah.edu/sympa/info/cs5530. The mailing list is cs5530@list.eng.utah.edu. Feel free to post your questions to this list.
       01/08/13: NO class on Wednesday, 1/9/13.
       01/14/13: Ben's (one of our TAs) office has changed to MEB 3412.
       01/23/13: HW1 is now released. It's due in a week.
       01/30/13: HW2 is now released. It's due in a week.
       01/30/13: Our DB server is up on georgia.eng.utah.edu. You can connect via the mysql client program on any linux/windows/mac machine. For example, to connect from Shell or CADE machine, type "mysql -h georgia.eng.utah.edu -u cs5530 -p cs5530db", we will release the password in class. cs5530db is a class-wide database where you only have SELECT privilege (under the user account cs5530). Each of you will also be given a separate database of your own, where you have full access. You will email one of our TAs to get the user id, password, and the database name for that database.
       01/30/13: You can also connect to our database server via a GUI interface, in particular, using the MySQL Workbench program, which you can download from here.
       02/11/13: Project is now officially releasted. The first deadline is on Feb 25th.
       02/18/13: HW3 is released, it's due on 02/27/2013.
       02/18/13: Midterm will be given on Wed, 03/06/2013.
02/25/13: A sample design for Phase 1 has been released.

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.

Both books have been reserved at the library, available for loan up to 4 hours for each transaction.

Schedule

Lecture: Monday, Wednesday, 10:45am - 12:05pm, WEB 1230.

Office hour: Monday 1:30-3:00pm; Wednesday 1:30-3:00pm.

TA Office hour: Chenxu, MEB 4152, Monday and Friday, 3:30-5:00pm. Ben, MEB 3412, Tuesday and Thursday, 10:00-11:30.

Exam: Midterm: Wed, 03/06/13 in class; Final: Friday, April 26, 10:30-12:30pm.

Detailed weekly schedule can be found in the course syllabus.

Slides

Slides will be posted before each lecture. Updates to slides may happen 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: Part1
Lecture 6: SQL: Part2
Lecture 7: SQL: Part3
Lecture 8: Disk and Files

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:
Written assignment 1: HW1
Written assignment 2: HW2
Written assignment 3: HW3

Project

Project description is now avaiable here.