ITIS 5160

1
ITIS 5160
Applied Databases Fall 2012
2
Overview

• Class hour 930am 1215pm, Friday, Woodward
  120
• Office hour 130 230pm, Wednesday
• Instructor - Dr. Weichao Wang
• email weichaowang_at_uncc.edu
• Office Woodward Hall 333C (after the labor day)
• Webpage
• http//coitweb.uncc.edu/wwang22/Teaching/2012F
  all-5160/index.htm
• Textbook
• Raghu Ramakrishnan, Johannes Gehrke. Database
  Management Systems(3rd) McGraw Hill, 2002
• Online information, http//www.cs.wisc.edu/dbboo
  k
• Lecture slides
• Solutions to odd-numbered exercises
• Minibase software

3
Topic Description

• Concept design, ER model, relational model, SQL,
  normal forms
• DB programming and JDBC
• Database indexing, physical database design and
  tuning
• Data warehouse
• Conceptual design, OLAP, data cube
• Physical design, indexing tuning
• Advanced database topics, distributed DB, OODB,
  web DB, KDD etc.

4
Course Prerequisite

• Data Structures
• Familiarity with programming with Java or C is
  assumed

5
Grading

• Composition
• Class participation 5
• Group project 40
• Midterm 25
• Final 30
• Scale
• Based on curves

6
Project reports

• Late policy
• 50 score within 24 hours
• After that 0
• Must be word or pdf files.
• Electronic submission accepted

7
Project

• Develop an information system using Oracle.
• Two components both OLTP and OLAP oriented
• Each group consists of 3-4 students
• 4-6 hours workload each week is expected
• Java or C assumed
• More information
• Will be provided on the class webpage

8
Midterm Final

• One cheat sheet will be allowed
• No discussion
• Cumulative
• No makeup