DatabaseDesignConceptualModelandERDiagramming.ppt

Database Design: Conceptual Model and ER Diagramming;Announcements;Lecture Outline;Lecture Outline;Information Systems Planning;Information Systems Planning;Information Systems Architecture;Information Systems Architecture;Information Systems Architecture;Zachman Framework;Information Engineering;Information Engineering;Focus;Lecture Outline;Database Design Process;Stages in Database Design;Database Design Process;Database Design Process;Database Design Process;Database Design Process;Database Design Process;Database Design Process;Lecture Outline;Entity;Attributes;Relationships;Relationships;Types of Relationships;Other Notations;Other Notations;More Complex Relationships;Weak Entities;Supertype and Subtype Entities;Many to Many Relationships;Lecture Outline;Developing a Conceptual Model;Developing a Conceptual Model;Developing a Conceptual Model;Primary Business Operations;Business Operations (cont.);Business Operations (cont.);Business Operations (cont.);Business Operations (cont.);Entities ;Diveshop Entities: DIVECUST;Diveshop Entities: DIVEORDS;Diveshop Entities: DIVEITEM;Diveshop Entities: SHIPVIA;Diveshop Entities: DIVESTOK;Diveshop Entities: DEST;Diveshop Entities: SITES;Diveshop Entities: BIOSITE;Diveshop Entities: BIOLIFE;Diveshop Entities: SHIPWRCK;Functional areas;Ordering;Ordering;Ordering Normalization;Details of DiveItem;Ordering: Full ER;Location/Site Selection;Destination/ Sites ;Sites and Sea Life 1;Diveshop ER diagram: BioSite;Sites and Sea Life 2;Sites and Shipwrecks;DiveShop ER Diagram;What must be calculated?;What is Missing??;Next Week;Assignment 2