CSCE 4350 DataBase Design

Instructor: Dr. Yan Huang             Fall 2012


 

 

 

 

Announcements

·       11/29, final review is posted here.

·       11/25, project presentation schedule.

·       11/25, project grading criteria have been posted.

·       11/20, Please complete the exit survey. After you complete the survey, there will be a graphic image like this. Please print, write down your name, and bring it to final exam as a pass to take the final exam.

·       11/20, Assignment 6 is posted and will be due Dec. 04.

·       10/25, Assignment 5 is posted and will be due Nov. 13.

·       10/04, Assignment 4 is posted and will be due Oct. 18.

·       10/02, Bonus assignment is posted and will be due Oct. 09.

·       09/27, Matt has cleared up the glitch and recreated MySQL accounts. Please try your account and let Matt know if you have any problems.

·       09/20, Project is posted and will be due 12/04 and 12/06.

·       09/20, Assignment 3 is posted and will be due Oct. 09.

·       09/18, Assignment 2 is posted and will be due Sep. 25.

·       09/13, we will have a MySQL lab session on Sep. 25. Please go to F218 that day.

·       08/30, please request a MySQL account at here.

·       08/30, 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 1:00-02:00pm

 

 

Teaching assistant:

Jason Powell

Office:

F236

Email:

jasonpowell@my.unt.edu

Office hours:

TTh 12:00-2:00pm



 

 

 

 

 

Schedule and Class Notes

Date

Lecture

Reading material

NB

08/30/12

Introduction

Silberschatz 1

Assignment 1 has been posted and will be due 09/13 before class

09/04/12

ER

Silberschatz 7

-

09/06/12

Relational Database Basics

Silberschatz 2

-

09/11/12

Relational Database Basics/Bank ER

Silberschatz 2

-

09/13/12

Basic SQL

Silberschatz 3

-

09/18/12

Immediate SQL, SQL practice

Silberschatz 4

Assignment 2 has been posted and will be due 09/25 before class

 

09/20/12

Project discussion, Advanced SQL

Silberschatz 5

Assignment 3 has been posted and will be due 10/09 before class;

Project has been posted and will be due on in pre-final week

09/25/12

Lab, create table

-

-

09/27/12

Relational Algebra

Silberschatz 6

-

10/02/12

Relational Database Design

Silberschatz 8

Bonus assignment is posted and will be due 10/09 before class.

10/04/12

Relational Database Design

Silberschatz 8

Assignment 4 is posted and will be due Oct. 18.

10/09/12

Access Methods

Silberschatz 11

-

10/11/12

SQL assignment discussion

-

Jason Powell is the lecturer.

10/16/12

Hashing, Bitmap Indexing

Silberschatz 11

-

10/18/12

Query Processing

Silberschatz 12

-

10/23/12

Query Processing

Silberschatz 12

-

10/25/12

Transactions

Silberschatz 14

Assignment 5 is posted and will be due Nov. 13.

10/30/12

Transactions, Concurrency Control Example

Silberschatz 14

-

11/01/12

Concurrency Control

Silberschatz 15

Exam review

11/06/12

OO/OR Databases

Silberschatz 22

Jason Powell is the lecturer.

11/08/12

Midterm

-

Material up to relational database design

11/13/12

XML

Silberschatz 23

-

11/13/12

XML II

Silberschatz 23

-

11/20/12

Data Warehouse

Silberschatz 20

-

11/27/12

Data Mining

Silberschatz 20

-

11/29/12

Project presentation.

-

Final review

12/13/12

Final Exam (1:30pm-3:30pm)

-

-

 

 

 

 

 

 

 

Assignments

1.      Assignment 6, issued 11/20, due 12/04.

2.     Assignment 5, taxi dataset, issued 10/25, due 11/13.

3.     Assignment 4, issued 10/04, due 10/18.

4.     You may do this assignment to replace Assignment 1, Problem 4. We will take the higher of the two scores, issued 10/02, due 10/09.

5.     Project, issued 09/20, due 12/04, 12/06.

6.     Assignment 3, create table, additional information, issued 09/20, due 10/09.

7.     Assignment 2, issued 09/18, due 09/25.

8.     Assignment 1, issued 08/30, due 09/13.

 

 

 

 

 

 

Books

Required textbook

Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Database System Concepts

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

ISBN: 0073523321

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, 6th edition, Addison Wesley, ISBN: 0136086209
  • Hector Garcia-Molina, J. Ullman, J. Widom, Database Systems - The Complete Book, Prentice Hall, ISBN 0131873253.

 

 

 

 

Links

MySQL:

·       Requesting MySQL account

·       MySQL manual

The book authors’ website