Advanced Databases

Outline

Detailed Outline

A Brief Introduction on Hierarchical and Network Models

The Relational Model

  • 3NF and BCNF Database Design
  • Synthesizing Method
  • 4NF
  • Decomposition Method

    Database Design Using Entity-Relationship Approach

  • Entity-Relationship Approach: Basic Concepts
  • Relational Database Design Using ER Approach
  • Normal Form Entity-Relationship Diagram

    Schema Integration (optional) (pdf)

    Nested Relational Model (optional)

  • Normal Form Nested Relation
  • Nested Relation Design

    Object-Oriented DBMS Concepts

  • Object-Oriented Database Concepts
  • Inadequacies of Object-Oriented Data Models
  • Inheritance Conflicts in Object-Oriented Systems
  • OO Schema Design

    Translating Relational Schema into OODB Schema

    Physical Database Design

  • Physical Database Design (brief)
  • Extending Classical Functional Dependencies for Physical Database Design

    Semistructured Data / Web Data

  • Introduction to XML
  • Schemas in XML
  • XPath
  • XQuery
  • Designing Semistructured Databases Using ORA-SS Data Model
  • Applications of ORA-SS Model

    Tutorials/Project

    Project Description

    Tutorial #1
    Tutorial #2
    Tutorial #3
    Tutorial #4
    Tutorial #5

    Reference Books and Papers

    Papers on Object-Relationship-Attribute Model for Semistructured Data (ORA-SS) and XML Query Processing

    Project Presentation Slides

  • project P1
  • project P2
  • project P3
  • project P4
  • project P5

    Project Reports

  • project P1
  • project P2
  • project P3
  • project P4
  • project P5

    Photos taken on 8 December 2014

  • Photo at the dinner
  • Photo at the dinner
  • Photo at the door of the restaurant:
    .... Back row: Tai, Duy
    .... Middle row: Tuan, Son, Dieu Linh, Si Linh, Huong, Quan
    .... Front row: Duc, Huy, Prof. Ling, Trang, Hang, Tu
  • Photo in front of Dang Anh Hotel
  • Photo with Can in the classroom
  • Photo with Tu in the classroom