Fall 2007: CS 405G : Introduction to Database Systems

Instructor and Course Information

Jinze Liu Meeting Time: MWF 10:00 AM - 10:50AM
liuj@cs.uky.edu Meeting Place:OHR 226
http://www.netlab.uky.edu/u/liuj/ Office Hours: MW 11:00 AM - 12:00 PM
(859) 257 - 3101 Office: 237 James 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

 

Announcements

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

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