Spring 2013

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:   TR    11am - 12:15pm   

Meeting Place:  Funkhouser Biological Sciences Building Room B8-FB  

Office Hours:     Monday 11am – 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

1/7/2013

 Spring 2013 CS405G class website is up. Welcome!

1/17/2013  

 Assignment 1 will be due on 1/29/2013.

02/05/2013

 Assignment 2 will be due on 02/12/2013.

02/20/2013

 Assignment 3 will be due on 02/26/2013. Mid-term will be on March 5th, 2013.

 
Schedule (Tentative)
 

 

Date

Topic

Slides

Reading Chapter

Assigned

Due

Note

01/10

1.       Introduction

PPT

Chapter 1:  Database and Database Users

01/15

2.       Entity and relationship

PPT

Chapter 7:  Database Modeling using ER Model

01/17

3.       Design principle

PPT

Assn 1

01/22

4.       Relations

PPT

Chapter 3: Relational Data Model and Constraints (3.1, 3.2)

01/24

5.       Relational constraints

PPT

 

 

 

 

01/29

6.       Relational algebra

PPT

 

Quiz 1

Assn 1

 

01/31

Continued

 

 

Assn 2

 

 

02/05

Continued

 

 

 

 

 

02/07

7.       SQL

PPT

Chapter 4: Basic SQL queries (4.1~4.4)

 

 

 

02/12

Continued

 

 

 

Assn 2

 

02/14

Continued

PPT

 

Assn3

 

Acknowledgement to Berkeley CS186 Slides 

02/19

Continued

PPT

Chapter 5: More SQL (5.1)

 

 

Acknowledgement to Berkeley CS186 Slides

02/21

Continued

PPT

 

 

 

 

02/26

Continued

 

 

 

Assn3

 

02/28

Mid-term review

 

 

 

 

 

03/05

Mid-term

 

 

 

 

 

03/07

PHP

PPT

Code

 

Project

 

Project due April 23rd.

03/12

SPRING BREAK

 

 

 

 

Have a nice break!

03/14

SPRING BREAK

 

 

 

 

Have a nice break!

03/19

DB programming

Functional Dependency

PPT

PPT

Chapter 15: functional dependency 15.1 ~ 15.6

 

 

 

03/21

Database Normalization

PPT

 

Assn 4

 

 

03/26

Continued

PPT

 

 

 

Project first milestone due

03/28

 

 

 

Assn 5

Assn 4

 

04/02

 

 

 

 

 

 

04/04

Database storage

PPT

Chapter 17: Storage 17.1 ~ 17.4

 

Assn 5

 

04/09

Database index – B+ tree

PPT

Chapter 18: Index 18.1 ~18.3

Assn 6

 

 

04/11

Project update

 

 

 

 

 

04/16

 

 

 

 

 

 

04/18

Final exam review

 

 

 

Assn 6

 

04/23

Project presentation

 

 

 

 

 

04/25

Project presentation

 

 

 

 

 

04/30