Spring 2011

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    11:00AM-11:50AM   

Meeting Place:  RGAN 203  

Office Hours:     MW     10:00AM - 10:50AM

Office:  237 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/11/2011

 Spring 2011 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/14

2.       Database Design

-          Entity

Chapter 7.1 - 7.3:  Data Modeling, Entities

 

01/17

No Class

 Martin Luther King Day

01/19

3.        Database Design

-          Relationship

PPT

Chapter 7.4 - 7.5: Relationships

 

01/21

4.        Database Design

-          Principles

PPT

Assn 1

 

01/24

5.        Relations

PPT

Chapter 3.1

 

01/26

6.        Relational Constraints

PPT

Chapter 3.2

 

01/28

Continued

Assn 2

Assn 1

 

01/31

Quiz 1 and Assignment 1

 

02/02

7.        Relational Algebra

PPT

Chapter 6.1 – 6.5: Relational algebra

 

02/04

Continued

Assn 2

 

02/07

Continued

Assn 3

 

02/09

Continued

 

02/11

Continued

 

02/14

8.        SQL I

PPT

Chapter 4.1, 4.3: Basic SQL

 

02/16

Continued

02/18

Continued

Assn 3

02/21

9.     SQL II

PPT

02/23

Continued

Assn4

02/25

9.        SQL III

PPT

Chapter 4.4

02/28

Continued

03/02

10.     SQL IV

PPT

Chapter 5.1, 5.2, 5.3

03/04

11.     SQL V

PPT

Assn4

03/07

Mid-Term review

03/09

Mid-Term

03/11

12.     Database programming

PPT

Examples of database connection with Java

Project

03/14

03/16

No class

Spring break

03/18

03/21

Continued

03/23

13. Functional Dependency

PPT

Chapter 15.1 - 15.2

Project: M1

03/25

03/28

14. Database Normalization

PPT

Chapter 15.3 - 15.5

04/01

Continued

PPT

04/04

15. Storage.

PPT

Assn 5

04/06

04/08

04/11

Assn 5

04/13

16.  Index

PPT

Assn 6

04/15

Continued

04/18

Continued

04/20

Assn 6

04/22

04/25

Project Presentation

 

 

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