Applied Databases

ITIS 5160-091

Fall 2007

This page provides a general course overview. Detailed course content will be delivered to registered students through the UNCC Blackboard Vista system. Registered students are responsible for checking the course Blackboard pages frequently, as this is the primary mechanism for communicating course developments.

Course Description

Prerequisites: full graduate standing, or consent of department.

Identification of business database needs; requirements specification; relational database model; SQL; E-R modeling; database design, implementation, and verification; distributed databases; databases replication; object-oriented databases; data warehouses; OLAP; data mining; security of databases; vendor selection; DBMS product comparison; database project management; tools for database development, integration, and transaction control.

Meeting

6:30-9:15pm, Wednesday, Woodward Hall 135

The course session will typically (not necessarily always) be split into three segments, with short breaks in between: 6:30-7:20, 7:30-8:20, and 8:30-9:15.

Textbook

Fundamentals of Database Systems (5th Edition) by Ramez Elmasri, Shamkant B. Navathe
Publisher: Addison Wesley

Instructor

Dr. David Wilson
- Office: 310E Woodward Hall
- Office Hours: tba
- Email:
- Phone: 704-687-8585

TA: tba
- Office:
- Office Hours:
- Email:
- Phone:

Topics

Foundations
- Course Intro, Systems Life Cycle, Requirements Analysis
- Logical Database Modeling
- Relational Database Model
- SQL
Applications
- Database Development Tools
- Database Programming
- Refinement and Tuning
- Overview of Systems Concerns
- Security, Recovery, and Verification
Advanced
- Warehousing and Decision Support
- Object-Oriented Databases
- Distributed Databases
- Information Retrieval, Data Integration
- Spatial Databases

Grading

Tentative Breakdown: tba

Academic Integrity

Students are responsible for knowing and observing the requirements of The UNC Charlotte Code of Student Academic Integrity (Policy Statement #105). The code forbids cheating, fabrication, or falsification of information, multiple submission of academic work, plagiarism, abuse of academic materials, and complicity in academic dishonesty. There are no special requirements regarding academic integrity in this course. The code will be strictly enforced and is binding on the students. Grade and academic evaluations in this course include a judgment that the student's work is free from academic dishonesty of any type; and grades in this course therefore should be and will be adversely affected by academic dishonesty. Students who violate the code can be expelled from UNC Charlotte. The normal penalty for a first offense is zero credit on the work involving dishonesty and further substantial reduction of the course grade. In almost all cases the course grade is reduced to an F. Copies of the Code can be obtained from the Dean of Students Office or me. Standards of academic integrity will be enforced in this course. Students are expected to report cases of academic dishonesty immediately.