|
|
CSCE 4350 DataBase Design
Instructor: Dr. Yan Huang
Fall 2007
|
|
|
|
|
|
Announcements
1.
11/11/07, makeup assignment has been
posted and will be due 11/29 before class.
2.
11/11/07, assignment 4 has been posted
and will be due 11/27 before class.
3.
10/25/07, assignment 3 has been posted
and will be due 11/08 before class.
4.
10/09/09, term
project has been posted and the first due date (for phase I)
will be Oct. 23 before class.
5.
09/25/07, assignment
2 has been posted and will be due 10/09 before class.
6.
09/15/07, Oracle accounts have been created for each
student. Please refer to Oracle
E-Support from UNT for login instructions. Sample database and
questions are available from the class
notes section.
7.
09/04/07, assignment
1 has been posted and will be due 09/18 before class.
8.
08/27/07, welcome to CSCE4350 class!
|
|
Syllabus [pdf]
|
Instructor:
|
Dr. Yan Huang
|
|
Office:
|
Research Park, F251, tel: 940-369-8353
|
|
Email:
|
huangyan ‘at’ cs.unt.edu
|
|
Class hours:
|
TTh 02:00-03:20pm, Research Park
B190
|
|
Office hours:
|
TTh 10:00-11:00am
|
|
|
|
|
Teaching assistant:
|
Hector Cuellar
|
|
Office:
|
F205
|
|
Email:
|
hectorgcr‘at’ gmail.com
|
|
Office hours:
|
M, 2:00pm
- 6:00pm
|
|
|
Schedule and
Class Notes
|
Date
|
Lecture
|
Reading material
|
NB
|
|
08/28/07
|
Introduction [ppt]
|
Silberschatz
1
|
-
|
|
08/30/07
|
ER [ppt]
|
Silberschatz
6
|
-
|
|
09/04/07
|
ER [ppt]
|
Silberschatz
6
|
Assignment 1 has been posted and will be due 09/18
before class.
|
|
09/06/07
|
Relational Data Model[ppt]
|
Silberschatz
2
|
-
|
|
09/11/07
|
Relational Algebra[ppt]
|
Silberschatz
2
|
bank ER
|
|
09/13/07
|
Relational Algebra [ppt]
|
Silberschatz
2
|
-
|
|
09/18/07
|
SQL [ppt], SQLII [ppt]
|
Silberschatz
3
|
TA Vishant Geol will give the lecture.
Assignment 1 due before class. Assignment 1 due.
|
|
09/20/07
|
Lab
|
-
|
Will be at teaching Lab Room 218
Create and populate tables for the banking enterprise database
Sample
questions
Sample queries
|
|
09/25/07
|
Relational Database
Design I[ppt]
|
Silberschatz
7
|
Assignment 2 has been posted and will be due 10/09
before class.
|
|
09/27/07
|
Discussion on Hw1
Relational Database
Design I[ppt]
|
Silberschatz
7
|
-
|
|
10/02/07
|
Object Oriented Databases [ppt]
|
Silberschatz
9
|
-
|
|
10/04/07
|
XML [ppt]
|
Silberschatz
10
|
-
|
|
10/09/07
|
XML II [ppt]
|
Silberschatz
10
|
Assignment 2 due. Term
project has been posted and the first due date (for phase I)
will be Oct. 23 before class.
|
|
10/11/07
|
Discussion
on Hw2
Term
Project Overview
Midterm
review
|
-
|
-
|
|
10/16/07
|
Midterm Exam
|
-
|
-
|
|
10/18/07
|
Indexing [ppt]
|
Silberschatz
10
|
-
|
|
10/23/07
|
Indexing and
Hashing [ppt]
|
Silberschatz
10
|
Term project phase 1 due.
|
|
10/25/07
|
Query Processing
and Optimization [ppt]
|
Silberschatz
13
|
Assignment 3 has been posted and will be due 11/08
before class.
|
|
10/30/07
|
Project discussion.
|
-
|
-
|
|
11/01/07
|
Query Processing
and Optimization [ppt]
|
Silberschatz
13
|
-
|
|
11/06/07
|
Transactions [ppt]
|
-
|
Term project phase 2 due.
|
|
11/08/07
|
In class poster
session.
|
-
|
Assignment 3 due. Assignment 4 will be posted and will be due 11/27
before class.
|
|
11/13/07
|
Transactions [ppt]
|
Silberschatz
15
|
|
|
11/15/07
|
Disscussion on Hw3.
Concurrency Control
[ppt]
|
Silberschatz
16
|
Makeup Assignment will be posted and will be due
12/04 before class.
|
|
11/20/07
|
Project phase 3
discussion.
|
-
|
Term project phase 3 due.
|
|
11/22/07
|
Thanks
Giving, no class.
|
|
|
|
11/27/07
|
Data Warehousing [ppt]
|
Silberschatz
18
|
Assignment 4 due. Term project phase 4
due.
|
|
11/29/07
|
Data Mining [ppt]
|
Silberschatz
18
|
Makeup Assignment due.
|
|
12/04/07
|
Disscussion on Hw4.
Final review.
|
-
|
-
|
|
12/06/07
|
Term project
demonstration.
|
-
|
Term project extra credit due.
|
|
12/11/07
|
Final Exam
(1:30pm-3:30pm)
|
-
|
-
|
|
|
|
|
Assignments
1.
11/11, makeup
assignment has been posted
and will be due 11/29 before class.
2.
11/11, assignment
4 has been posted and will be due 11/27 before class.
3.
10/25, assignment
3 has been posted and will be due 11/08 before class.
4.
10/09,
term
project has been posted and the first due date (for phase I)
will be Oct. 23 before class.
5.
09/25, assignment
2 has been posted and will be due 10/09 before class.
6.
09/04, assignment
1 has been posted and will be due 09/18 before class.
|
|
Books
Required textbook
Supplements:
- Elmasri, Navathe, Fundamentals Of
Database Systems, 5rd, Addison Wesley, ISBN: 0321369572
- Hector Garcia-Molina, J. Ullman, J.
Widom, Database Systems - The Complete Book, Prentice Hall, ISBN
0-13-031995-3.
|
|
|
Links
The book authors’ website
Oracle
SQL Standard
|
|
|
