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
|