FIT2094 Lecture Notes - Lecture 3: Peter Chen, Database Design, Database Model

• School: Monash University
• Department: Information Technology
• Course: FIT2094
• Professor: Mr Lindsay Smith

Document Summary

A user view may be a report to be produced or a particular type of transaction that should be supported. Corresponds to the external level of the ansi/sparc architecture. Output is a statement of specifications which describes the user views" particular requirements and constraints. Admin view (allocate+ with a lot of information and the ability to delete and edit) Er (entity-relationship) model developed by peter chen in 1976 to aid database. May be used for concept (erd)/logical design (erd like) Er diagrams give a visual indication of the design. Corresponds to the conceptual level of ansi/sparc architecture. Various design methodologies may be employed, including the er approach. Develop a data model which targets a particular database model (eg. relational, hierarchical, network, object-oriented) Independent of any implementation details which are specific to any particular dbms package. Normalisation technique (week 5) is used to test the correctness of the logical model.