Spring 2012

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    2pm - 3:15pm   

Meeting Place:  MMRB 243  

Office Hours:     Monday 2pm – 4pm

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/18/2012

 Spring 2012 CS405G class website is up. Welcome!

Schedule (Tentative)

Date

Topic

Slides

Reading Chapter

Assigned

Due

Note

01/12

1.       Introduction

PPT

Chapter 1:  Database and Database Users

01/17

2.       Database Design

-          Entity

-          Relationship

PPT

Chapter 7.1 - 7.5:  Data Modeling, Entities,Relationships

Assn 1

 

01/19

3.       Database Design

-          Principles

PPT

Chapter 3.1 – 3.2: Relations

 

01/24

4.       Relations & Relational Constraints

PPT

PPT

 

 

01/26

5.       Relational Algebra

PPT

Chapter 6.1 – 6.5:Relational Algebra

Assn1

 

01/31

continued

 

 

Assn2

 

 

02/02

continued

 

02/07

continued

 

 

 

 

 

02/09

6.       SQL

PPT

Chapter 4.1 – 4.5. SQL

Assn3

Assn2

 

02/14

Continued

 

 

 

 

 

02/16

Continued

 

 

 

 

 

02/21

Continued

 

 

 

 

 

02/23

 

 

 

 

Assn3

 

02/28

Mid-term review

 

 

 

 

 

03/01

Mid-Term

 

 

 

 

 

03/06

 

 

 

 

 

 

03/08

 

 

 

 

 

 

03/13

No class

Spring break

03/15

No class

Spring break

03/20

7.       Functional Dependency

PPT

Chapter 15.2

Assn 4

 

 

03/22

8.       Database Normalization

PPT

Chapter 15.3 ~ 15.5

 

 

PHP by Song

03/27

Continued

PPT

 

Project

Assn4

 

03/29

 

 

 

 

 

 

04/03

9.       Database Storage

PPT

Chapter 17.1 ~ 17. 6

 

 

Project proposal

 

04/05

10.    Indexing

PPT

Chapter 18.1 ~ 18.3

Assn5

 

 

04/10

Continued

 

 

 

 

 

04/12

Project update

PPT

 

Assn6

Assn5

 

04/17

 

 

 

 

 

 

04/19

No Class

 

 

 

Assn6

 

04/24

Final exam review

 

 

 

 

 

04/26

Project Presentation

 

 

 

Project Report due

 

05/01

Final Exam at 1pm.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

?Copyright 2007. All rights reserved. Contact: liuj (at) cs (dot) uky (dot) edu