|
|
CSCE 5350 DataBase Design
Instructor: Dr. Yan Huang
Fall 2009
|
|
|
|
|
|
Announcements
- 11/04, exam II will be on
Dec. 03, covers OO DB, XML, indexing, QP, transactions, and CC.
- 11/04, assignment 3 has been
posted and will be due Nov. 24 before class.
- 10/05, exam II will be on
Oct. 29, covers SQL and relational database design.
- 10/05, assignment 2 has
been posted and will be due Oct. 22 before class.
- 09/23, project posted and
will be due in pre-final week.
- 09/01, the teaching
assistant’s office hours have been changed to Fridays 2:00pm –
6:00pm.
- 08/27, exam I will be on
Sep. 09/29, covers ER, relational data model, relational algebra.
- 08/27, welcome to
CSCE5350 class!
|
|
Syllabus [pdf]
|
Instructor:
|
Dr. Yan Huang
|
|
Office:
|
Research Park, F251, tel:
940-369-8353
|
|
Email:
|
huangyan ‘at’ unt.edu
|
|
Class hours:
|
TTh 12:30-01:50pm, Research Park B142
|
|
Office hours:
|
TTh 10:00-11:00am
|
|
|
|
|
Teaching assistant:
|
Vishwanathan, Roopa
|
|
Office:
|
F205
|
|
Email:
|
RoopaVishwanathan@my.unt.edu
|
|
Office hours:
|
Friday 2:00pm to 6:00 p.m.
|
|
|
Schedule and
Class Notes
|
Lecture Notes
|
Reading material
|
|
Introduction [ppt]
|
Silberschatz 1
|
|
ER [ppt]
|
Silberschatz 6
|
|
Relational
Data Model[ppt]
|
Silberschatz 2
|
|
Relational Algebra[ppt], Relational Algebra II[ppt], bank
ER
|
Silberschatz 2
|
|
SQL [ppt], SQLII [ppt];
bank database; Queries
|
Silberschatz 3
|
|
Relational Database Design I[ppt]
|
Silberschatz 7
|
|
Relational Database Design II[ppt]
|
Silberschatz 7
|
|
Object Oriented Databases [ppt]
|
Silberschatz 9
|
|
XML [ppt]
|
Silberschatz 10
|
|
XML II [ppt]
|
Silberschatz 10
|
|
Indexing [ppt]
|
Silberschatz 12
|
|
Indexing and Hashing [ppt]
|
Silberschatz 12
|
|
Query Processing and Optimization
[ppt]
|
Silberschatz 13
|
|
Transactions [ppt]
|
Silberschatz 15
|
|
Concurrency Control [ppt]
|
Silberschatz 16
|
|
Data Warehousing [ppt]
|
Silberschatz 18
|
|
Data Mining [ppt]
|
Silberschatz 18
|
|
|
|
|
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.
|
|
|
