Fall 2007

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

Meeting Place:  OHR 226  

Office Hours:     MW     11:00AM - 12:00PM

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, hierarchical and network database models and in-depth coverage of 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 le management techniques used by database systems.

Detailed Syllabus:  .pdf

 
 Announcement

11/07/07

Please schedule project stage 2 meeting before Nov 16th.

10/03/07

Assignment 3 is due today! Project will be assigned today.

09/25/07

Assignment 2 is due 09/26. Quiz 2 is scheduled for Oct 5th.

09/12/07

Quiz 1 is on this Friday 09/14. 10 minutes, open book, and open notes.

09/05/07

Assignment 1 is out! Due 09/19!!!

08/29/07

Please send me an email to get your multi-lab and database accounts information.

08/21/07

CS 405G website is up!
 
 
Programming Instructions

1

Instructions for accessing multilab server and oracle database are here

2

Instructions for getting started in using oracle database are here.

3

Oracle Documentation can be found at this link.

4

A simple log file of creating a small database can be found here. The red colored texts are command line input.

5

Tutorial for connecting to Oracle database with JDBC is here.

6

Sample Java code with embedded SQL statement  is here.

7

Introduction to PHP: presentation. 

8

Query with PHP: sample code.
 
 
 
 Schedule (Tentative)

Date

Topic

Slides

Reading Chapter

Assigned

Due

Note

08/22

1.     Introduction

Lecture 1 

1.1-1.5

survey.pdf

In class

 

08/24

2.     E-R model

Lecture 2

3.1-3.4

 

08/27

3.     E-R model (examples)

Lecture 3

3.5-3.6

 

08/29

4.     Relations

Lecture 4

5.1

 

08/31

5.     Relational Constraints

Lecture 5

5.2

 

09/03

No Class

Labor day

09/05

6.     Database operations and constraints

Lecture 6

5.3

Assn 1

 

09/07

7.     Relational Algebra I

Lecture 7

6.1-6.3

 

09/10

8.     Relational Algebra II

Lecture 8

 

09/12

9.     Relational Algebra III

Lecture 9

 

09/14

10.   Database design

Lecture 10

7.1

Quiz 1

 

09/17

11.   SQL I

Lecture 11

8.1~8.4

 

09/19

12.   SQL II

Lecture 12

Assn 2

Assn 1

 

09/21

13.   SQL III

Lecture 13

 

09/24

SQL III (continued)

 

09/26

 14.  SQL IV

Lecture 14

8.5-8.7

Assn 3

Assn 2

 

09/28

         SQL IV (continued)

 

10/01

15.   SQL V: View;

Transactions

Lecture 15

8.8,

17.2-17.3

 

10/03

16.   Programming with databases

Lecture 16

Project

Assn 3

 

10/05

17.   Functional Dependency

Lecture 17

 

Quiz 2

10/08

         FD (continued), BCNF

10/10

Homework review

10/12

18.   Mid-term Review

Lecture 18

10/15

Mid-Term

 

10/17

19.   Disk

Lecture 19

Assn 4

 

10/19

20.   Indexing (ISAM, B+ tree)

Lecture 20

Ch.14

 

10/22

Class Canceled        

 E-Science 2007

10/24

         Indexing (Continued)

Assn 4

 

10/26

21.   File & index organization

Lecture 21

Assn 5

 

10/29

Class Canceled

 ICDM 2007

10/31

22.   Intro to XML

Lecture 22

XML&DTD

 

11/02

         XML & DTD

     Quiz 3

 

11/05

         XML query

 

11/07

23.   XML & relational mapping

Lecture 23

Assn 5

 

11/09

         PHP, XML continued

 

11/12

24.   3NF and 4NF

Lecture 24

 

11/14

          4NF Continued

Assn 6

 

11/16

 

11/19

25.   Query Processing

Lecture 25

 

11/21

No Class

Fall Break

11/23

No Class

Thanksgiving Holiday

11/26

26.   Intro to Data Mining

Lecture 26

 

11/28

         DM Continued

Assn 7

(extra)

Assn 6

 

11/30

         DM Continued

 

12/03

Final review I

 

12/05

Final review II

 Course Evaluation

12/07

 Project Demo

Project

Last day of Classes

12/12

Final Exam at 8am

 

 

 

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