CS6360 Database Design

Instructor: John Cole Section 004 Monday/Wednesday 8:30 to 9:45 AM
Office and Hours  Room: JSOM 11.206

Teaching Assistant: Erick Skorupa Parolin
Office hours: Tue/Thu from 1:30 - 3:30 in ECSS 2.104A1

Last update: 9/26/2017
Syllabus is on Coursebook Schedule
Textbook: Fundamentals of Database Systems, Seventh 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 as well as theory, such as the entity-relationship model, normal forms and relational algebra.  You will write quite a bit of code for this course.  Projects will include writing a program to index a file by creating your own B+ tree.  For a computer scientist it is not enough to understand how to use a database manager you must understand how to write one, as well.

Code to connect to SQL Server
Code to connect to MySQL
Binary and Random Access I/O in C++
Binary and Random Access I/O in Java
B+ Tree manipulation visualization

Exam Rules