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:
- understand and appreciate the theoretical foundation of database systems
- write SQL queries of moderate complexity
- create a web front end to a database application
- use sound design principles when designing a database
- 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 |
1.1-1.5 |
In class |
|
||
|
08/24 |
2. E-R model |
3.1-3.4 |
|
|||
|
08/27 |
3. E-R model (examples) |
3.5-3.6 |
|
|||
|
08/29 |
4. Relations |
5.1 |
|
|||
|
08/31 |
5. Relational Constraints |
5.2 |
|
|||
|
09/03 |
No Class |
Labor day |
||||
|
09/05 |
6. Database operations and constraints |
5.3 |
|
|||
|
09/07 |
7. Relational Algebra I |
6.1-6.3 |
|
|||
|
09/10 |
8. Relational Algebra II |
|
||||
|
09/12 |
9. Relational Algebra III |
|
||||
|
09/14 |
10. Database design |
7.1 |
Quiz 1 |
|
||
|
09/17 |
11. SQL I |
8.1~8.4 |
|
|||
|
09/19 |
12. SQL II |
Assn 1 |
|
|||
|
09/21 |
13. SQL III |
|
||||
|
09/24 |
SQL III (continued) |
|
||||
|
09/26 |
14. SQL IV |
8.5-8.7 |
Assn 2 |
|
||
|
09/28 |
SQL IV (continued) |
|
||||
|
10/01 |
15. SQL V: View; Transactions |
8.8, 17.2-17.3 |
|
|||
|
10/03 |
16. Programming with databases |
Assn 3 |
|
|||
|
10/05 |
17. Functional Dependency |
|
Quiz 2 |
|||
|
10/08 |
FD (continued), BCNF |
|||||
|
10/10 |
Homework review |
|||||
|
10/12 |
18. Mid-term Review |
|||||
|
10/15 |
Mid-Term |
|
||||
|
10/17 |
19. Disk |
|
||||
|
10/19 |
20. Indexing (ISAM, B+ tree) |
Ch.14 |
|
|||
|
10/22 |
Class Canceled |
E-Science 2007 |
||||
|
10/24 |
Indexing (Continued) |
Assn 4 |
|
|||
|
10/26 |
21. File & index organization |
|
||||
|
10/29 |
Class Canceled |
ICDM 2007 |
||||
|
10/31 |
22. Intro to XML |
|
||||
|
11/02 |
XML & DTD |
Quiz 3 |
|
|||
|
11/05 |
XML query |
|
||||
|
11/07 |
23. XML & relational mapping |
Assn 5 |
|
|||
|
11/09 |
PHP, XML continued |
|
||||
|
11/12 |
24. 3NF and 4NF |
|
||||
|
11/14 |
4NF Continued |
|
||||
|
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 |
|
||||
|
11/28 |
DM Continued |
(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 |
|