Fall 2014

CS 405G : Introduction to Database Systems

 


1. Instructor and course information

2. Syllabus

3. Announcement

4. Programming Instructions

5. Course Schedule

 
Instructor and Course Information

Jinze Liu

liuj@cs.uky.edu

http://www.cs.uky.edu/~liuj

(859) 257 - 3101

 

 

 

Meeting Time:   MWF    9am – 9:50am   

Meeting Place:  FPAT 255  

Office Hours:     Wednesday 10am – 12pm

Office:  235 James F. Hardymon Building

 

Syllabus

The course teaches fundamental concepts behind the design, implementation and application of database systems. In detail, it will review entity-relationship database models and give extensive coverage on the relational model including relational algebra and calculi, relational database theory, concepts in schema design and commercial database languages. At the conclusion of the course, the successful student will be able to:
1. understand and appreciate the theoretical foundation of database systems
2. write SQL queries of moderate complexity
3. create a web front end to a database application
4. use sound design principles when designing a database
5. understand through hands-on experience the management techniques used by database systems.

Detailed Syllabus  here.

 Announcement

09/16/2014

Homework 1 is due 09/24

08/27/2014

 Fall 2014 CS405G class website is up. Welcome!

 
Schedule (Tentative)

 

 

Date

Topic

Slides

Reading Chapter

Assigned

Due

Note

08/27

1.       Introduction

PDF

Chapter 1:  Database and Database Users

08/29

2.       Continued

 

 

 

 

 

09/03

3.       ER Model

PDF

Chapter 7.2-7.7: Database Modeling

 

 

 

09/10

4.       ER Design Principle

PDF

 

 

 

 

09/12

5.       Relations

PDF

Chapter 3.1-3.3: The Relational Database Model

Assn 1

 

 

09/15

6.       Relational Constraints

PDF

 

 

 

 

09/17

7.       Relational Algebra

PDF

Chapter 6.1-6.5: Relational Algebra

 

 

 

09/19

Continued

 

 

 

 

 

09/22

Continued

 

 

 

 

 

09/24

        Continued

 

 

 

Assn 1

 

09/26

        Continued

 

 

Assn 2

 

 

09/29

8.       SQL I

 

Chapter 4: Basic SQL

 

 

 

10/06

Continued

PPT

 

 

Assn2

 

10/08

Continued

 

 

 

 

 

10/10

9.       SQL II

PPT

Chapter 5: SQL

Project

 

 

10/13

        Continued

 

 

Assn 3

 

 

10/15

 

 

 

 

 

 

10/17

 

 

 

 

 

 

10/20

Mid-Term Review

 

 

 

Assn 3 Part 1

 

10/22

Mid-Term

 

 

 

 

 

10/29

10.    Database Programming

PDF

 

 

 

 

10/31

11.    Transactions

PDF

 

 

 

 

11/03

12.    Functional Dependency

PDF

 

 

 

 

11/05

13.    Database Normalization

PDF

 

Assn 4

 

 

11/07

Continued

 

 

 

 

 

11/10

14.    Database storage

PDF

 

 

 

 

11/12

Continued

 

 

 

Assn 4

 

11/14

Continued

 

 

 

 

 

11/19

15.    Indexing

PDF

 

Assn 5

 

 

11/19

Project update