Fall 2007 ITCS3160: Database Design and Implementation

Classroom: STECH 155

Class Time: Monday: 8:00AM-11:00AM

Text Book:

R. Ramakrishnan and J. Gehrke, ``Database Management Systems", third edition, McGraw-Hill, 2000.

you can get Oracle account at: http://coit-ora01.uncc.edu http://coit-ora01.uncc.edu:8080/isqlplus/

Course Outline:

  • Introduction;
  • E-R model, relational model;
  • SQL and query by example;
  • Database Indexing structure;
  • Database storage management;
  • Database security;
  • Database Transaction management;
  • Issues on modern database systems;

    • Grading Format:

  • Questions: ask and answer questions in the class 5%
  • Homework and Projects 25%
  • Middle and Final test 70%

    • Instructor Office Time:

  • Friday 3:00PM-6:00PM or make appointment

    • Schedule:

  • Aug. 24, 2007 Introduction: class topics and issues.
  • Aug. 24, 2007: Entity-Relationship Model Homework 1, due day Aug. 31
  • Aug. 31, 2007: Chapter 2 Excercises
  • Sept. 7, 2007: Relational Database Model Homework 2, due day Sept. 14
  • Sept. 14, 2007: Relational Algebra

    • you can get Oracle account at: http://coit-ora01.uncc.edu http://coit-ora01.uncc.edu:8080/isqlplus/

  • Sept. 21, 2007: SQL: Queries, Programming, Triggers Homework 3, due day Sept. 28
  • Sept.28, 2007: Examples and in-class test!
  • Nov. ?, 2007:

    Hands-on Learning SQL Computer lab 335!

  • Oct. 5, 2007: project introduction
  • Oct. 5, 2007: illustrating project implementation
  • Oct. 5, 2007: Storing Data: Disks and Files
  • Oct. 12, 2007: Files Organizations and Indexs Homework 6, due day Oct. 19

  • Oct. 19, Mid-Test

    (one page note is permitted!)
  • Oct. 26, 2007: Question answering for mid-test!
  • Oct. 26, 2007: Tree-Structured Indexing Homework 7, due day Nov. 9

  • Nov. 2: No Class (leave for conference)

  • Nov. 9, 2007: Hash-Based Indexing
  • Nov.9, 2007: External Sorting Homework, due day Nov. 16
  • Nov.16, 2007: Evaluation of Relational Operations
  • Nov.16, 2007: Evaluation of Relational Operations Homework, due day Nov. 30
  • Nov. 23: No Class (Happy Thanksgiving)
  • Nov.30, 2007: Query Optimization and Examples
  • Nov.30, 2007: Examples and in-class test!
  • Nov.30, 2007: Case Study: Multimedia Database System Design
  • Nov. 30, 2007: Review for final test!
  • Nov. 30, 2007: Project Due!!!!!!!! Computer lab 335!

    • Do what you can, with what you have, where you are! ---Theodore Roosevelt---