CS6360.501 Database Design Monday/Wednesday 7:00 to 8:15 PM
Instructor: John Cole
Office hours: 5:15 to 6:45 in ECSS 4.609		 Room ECS 2.410

Teaching Assistant: Timothy Rozario
 Office Hours: Monday/Tuesday 5:30 to 6:30 PM in 4.702

 Last update: 8/21/2011
Syllabus Schedule (UPDATED 10/16/2011)
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.

Slides for Chapters 1-5
Slides for Chapters 6-10
Slides for Chapters 11-15
Slides for Chapters 16-20

Exam Rules

Access Redistributable.  This should work on 64-bit systems.
http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

Exam 1 average: 74.6, median 76

Final grades have been posted as of 12/16/2011.  I wish you all a pleasant and safe holiday.

Homework Assignments:
Assignment 1 Due October 14, 2011 Deadline extended!
Assignment 2, Due November 14, 2011.  Deadline extended 2 days! Deadline extended again!!  See assignment for more clarification.
Assignment 3, Due December 8, 2011. Reprieve! Deadline extended!

In-Class Notes.  These are what I wrote using WordPad during class, if any.  I cannot post the slides from the text because they are copyrighted material.  They're just a dilute form of the book anyway.

Company SQL Script File
Company Access Database
Company Zip File from Textbook
 A new copy of the Access database has been uploaded as of 9/27/2011 at about 9:00 PM.  This has some primary keys and relationships defined.  I have also added some clarification to the assignment concerning referential integrity.
public static Connection getConnection() {
        String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
        String url = "jdbc:odbc:test"; //test is the database
        String username = ""; //leave blank if none
        String password = ""; //leave blank if none
        
 try {
      Class.forName(driver);
     }
 catch (ClassNotFoundException e) {
      e.printStackTrace();
     }
 try {
      return DriverManager.getConnection(url, username, password);
     } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
     }
     return null;
}


this could be used in the main function or any function which needs to connect

                Connection conn = getConnection();
                Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
                st.executeQuery("SELECT * FROM employee");
                rs=st.getResultSet();

This code requires a DSN to be created , for windows 7 users using 64 bit system the DSN should be created using
C:\Windows\SysWOW64\ODBCAD32.exe
 Java code from Mahendiran Chandrasekar
to connect to Access.