|
|
CSCE 5350 DataBase Design
Instructor: Dr. Yan Huang
Fall 2010
|
|
|
|
|
|
Announcements
- 11/11,
hw7
(the last one) is posted.
- 10/21,
hw6 has been posted.
- 09/20,
project
has been posted.
- 08/27, welcome to
CSCE5350 class!
|
|
Syllabus [pdf]
|
Instructor:
|
Dr. Yan Huang
|
|
Office:
|
Discovery Park, F251, tel: 940-369-8353
|
|
Email:
|
huangyan ‘at’ unt.edu
|
|
Class hours:
|
TTh 12:30-01:50pm, Discovery Park B142
|
|
Office hours:
|
TTh 10:00-11:00am
|
|
|
|
|
Teaching assistant:
|
Vishwanathan, Roopa
|
|
Office:
|
F205
|
|
Email:
|
RoopaVishwanathan@my.unt.edu
|
|
Office hours:
|
Mondays 2:00pm – 6:00pm
|
|
|
Schedule and
Class Notes
|
|
|
|
Lecture Notes
|
Reading material
|
|
Introduction [ppt]
|
Silberschatz
1
|
|
Relational Model [ppt]
|
Silberschatz
2
|
|
ER [ppt],
Conerting ER to Relational Database [ppt]
|
Silberschatz
7
|
|
Relational Database
Design I[ppt]
|
Silberschatz
8
|
|
Relational Database
Design II[ppt]
|
Silberschatz
8
|
|
Object Oriented Databases [ppt]
|
Silberschatz
22
|
|
XML [ppt]
|
Silberschatz
23
|
|
XML II [ppt]
|
Silberschatz
23
|
|
Indexing [ppt]
|
Silberschatz
11
|
|
Indexing and Hashing
[ppt]
|
Silberschatz
11
|
|
Query Processing and
Optimization [ppt]
|
Silberschatz
12,13
|
|
Transactions [ppt]
|
Silberschatz
14
|
|
Concurrency Control [ppt]
|
Silberschatz
15
|
|
Database System
Architectures [ppt]
|
Silberschatz
17
|
|
Data Warehousing [ppt]
|
Silberschatz
20
|
|
Data Mining [ppt]
|
Silberschatz
20
|
|
·
Exam
I, Sep. 30, in-class.
·
Exam
II, Nov. 04, in-class.
·
Final
Exam, Dec. 14, 10:30am-12:30pm.
·
In-class
project Q & A session, Oct. 05
and Nov. 02.
·
Project
presentation: pre-final week.
|
|
|
|
|
|
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.
|
|
|
