ITIS 5160 Applied Database

Course Description

3 Credit hours. Cross-listed as HCIP 5160. Prerequisite: Full graduate standing or permission 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.

Grding Policy

Quiz 10%, Term project 40%, Midterm 20%, Final 30%

Text Book

Raghu Ramakrishnan, Johannes Gehrke. Database Management Systems (3rd), McGraw Hill, June 2003.

Topics (by week)

  1. Intro
  2. ER model
  3. Relational model
  4. SQL
  5. SQL
  6. DB programming and JDBC
  7. Review, midterm
  8. Normal forms
  9. Normal forms
  10. Data warehouse conceptual design
  11. Data warehouse physical design
  12. Query optimization, indexing, polyinstantiation
  13. Project presentation
  14. Database security, vulnerabilities, DBA tuning, Review
  15. Final

    Academic Integrity

    All students are required to read and abide by the Code of Student Academic Integrity. Violations of the Code of Student Academic Integrity, including plagiarism, will result in disciplinary action as provided in the Code.Definitions and examples of plagiarism are set forth in the Code. The Code is available from the Dean of Students Office or online.