CSCE 5350 DataBase Design

Instructor: Dr. Yan Huang             Fall 2009


 

 

 

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

 

Announcements

  1. 11/04, exam II will be on Dec. 03, covers OO DB, XML, indexing, QP, transactions, and CC.
  2. 11/04, assignment 3 has been posted and will be due Nov. 24 before class.
  3. 10/05, exam II will be on Oct. 29, covers SQL and relational database design.
  4. 10/05, assignment 2 has been posted and will be due Oct. 22 before class.
  5. 09/23, project posted and will be due in pre-final week.
  6. 09/01, the teaching assistant’s office hours have been changed to Fridays 2:00pm – 6:00pm.
  7. 08/27, exam I will be on Sep. 09/29, covers ER, relational data model, relational algebra.
  8. 08/27, welcome to CSCE5350 class!

 

 

 

 

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

 

 

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.



 

 

 

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

 

 

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

 

 

 

 

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

 

 

Assignments

  1. assignment 3 due 11/24 before class.
  2. assignment 2 due 10/22 before class.
  3. project due in pre-final week.
  4. assignment 1 due 09/22 before class.

 

 

 

 

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

 

 

Books

Required textbook

image001.jpg

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

SQL Standard