CS6360.5U1 Database Design

Fall Semester 2013 Monday/Wednesday 7:00 to 9:15 PM
Instructor: John Cole
Office hours: 5:30 to 6:30 PM M/W in ECSS 3.203
Room: ECSN 2.126

Teaching Assistant: Ahsanul Haque
Office hours: 3:30 to 5:30 MW in ECSS 4.205

Last update: 6/6/2013
Syllabus: On coursebook Schedule (Updated 6/6/2013)
Book: Fundamentals of Database Systems, Sixth edition, by Elmasri and Navathe

This is the graduate course in Database Design.  Although material such as SQL will be covered, there will be an emphasis on the internals of database management systems.  You will write quite a bit of code for this course.

Welcome to Database Design.  Here are some suggestions for preparing for the start of the class.  Since this is a graduate course, you will be expected to know or learn quickly the following, which should have come from the prerequisites:
  • Basic SQL, including SELECT queries
  • Java and/or C/C++
  • Binary I/O in some language
  • Data structures and algorithms, including binary trees and hashing

We will be using MySQL for parts of this course.  You can get a free version from Oracle, along with some really good developer tools. 

 

Exam Rules


Homework Assignments are now posted only on eLearning.

In-Class Notes and links to useful things.

Company SQL Script File
Company Zip File from Textbook
Java JDBC link to MySQL sample
Test script for Assignment 4
B-Tree Animation