Database Design

Object Role Modelling

IIS Topics: SQL- PHP - Access - ORM - AI

Related Resources - Links to other people's pages covering related content - suggestions welcome.

What is an Information System? - Components; Concepts; 5GIS; Turings Test; UoDs

Facts - Atomic Propositions - Communicating facts; 5th Generation Architectures (intro); CIP Problems

Fifth Generation Systems - 3 Schema Architecture; Software Development Cycle

Object Role Modelling Methodology:

Object Role Modelling - ORM/NIAM/CSDP History; Fact Type Identification ; First Draft of the Schema ; Eliminate Surplus Entities and Identify Derived Facts; Uniqueness Constraints

ORM Constraints - Check Facts are of the Right Arity; Constraining the model ;

Final Constraints and Checking - Check Each Entity can be precisely defined; Exotic Constraints ; Final Checks

Representing Knowledge: Alternative Conceptual Representations; 'Z' State Schemas; E-R Diagrams

Relational Schema (table design): Introduction to conceptual-relational transformation; Ideals; Optimal Normal Form; The ONF Algorithm; Data Dictonaries