CSCE 5350 DataBase Design

Instructor: Dr. Yan Huang             Fall 2010


 

 

 

Announcements | Syllabus | Class Notes | Assignments | Books | Links

 

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!

 

 

 

 

Announcements | Syllabus | Class Notes | Assignments | Books | Links

 

 

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



 

 

 

Announcements | Syllabus | Class Notes | Assignments | Books | Links

 

 

Schedule and Class Notes

 

Lecture Notes

Reading material

Introduction [ppt]

Silberschatz 1

 

Relational Model [ppt]

Silberschatz 2

 

SQL I [ppt] bank database; Queries

Silberschatz 3

SQL II [ppt]

Silberschatz 4

Relational Algebra [ppt]

Silberschatz 6

 

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.

 

 

 

Announcements | Syllabus | Class Notes | Assignments | Books | Links

 

 

Assignments

1.      Assignment 1, due Sep. 09.

2.      Assignment 2, due Sep. 21.

3.      Assignment 3, due Sep. 28.

4.      Project, due pre-final week.

5.      Assignment 4, due Oct. 19.

6.      Assignment 5, due Oct. 26.

7.      Assignment 6, due. Nov. 04.

8.      Assignment 7, due. Dec. 02.

 

 

 

Announcements | Syllabus | Class Notes | Assignments | Books | Links

 

 

Books

Required textbook

image001

Database Systems Concepts
by Abraham Silberschatz, Henry F. Korth, S. Sudarshan

ISBN: 0072958863

Publisher: McGraw-Hill Science/Engineering/Math

Buy this book (new) from Amazon.
Compare prices (new or used) at BestBookBuys

 

 

 

 

 

 

 

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.

 

 

 

Announcements | Syllabus | Class Notes | Assignments | Books | Links

 

 

Links

The book authors’ website

 

MySQL:

·          Requesting MySQL account

·         MySQL manual

·          

Oracle

·         Oracle E-Support from UNT

·         Oracle basics (SQLplus commands, simple SQL) from Stanford University database group

·         Oracle tutorials from MIT (tuning, dwh, java) ... web nerds series

·         Oracle 9i Manuals (may need to sign up)

SQL Standard

·         Article from The DA Newsletter

·         SQL Links

·         Various Documents on SQL