《数据库原理（第6版）英文版》教学课件—ch04Data Modeling and the Entity-Relationship Model.pptxVIP

Data Modeling and theEntity-Relationship Model;Chapter Objectives;Chapter Objectives(Cont’d);Three Stages ofDatabase Development;The Requirements Analysis Stage;Requirements Become theE-R Data Model;Entity Class versus Entity Instance;Entity Class and Entity Instance;Attributes;Identifiers;Identifier Types;Levels of Entity Attribute Display;Relationships;Degree 2 Relationship:Binary;Degree 3 Relationship:Ternary;One-to-One Binary Relationship;One-to-Many Binary Relationship;Many-to-Many Binary Relationship;Maximum Cardinality;Minimum Cardinality;Cardinality Example;Entity-Relationship Diagrams;HAS-A Relationships;Types of Entity-Relationship Diagrams;Crow’s Foot Example:One-to-Many Relationship;Crow’s Foot Symbols;Crow’s Foot Example:Many-to-Many Relationship;Weak Entity;ID-Dependent Weak Entities;ID-Dependent Weak Entity Examples;Weak Entity Relationships;Weak Entity Identifier:Non-ID-dependent;Non-ID-Dependent Weak Entity Examples;Strong and Weak Entity Examples;Subtype Entities;Subtype Entity Identifiers;Subtype Entity Examples;Recursive Relationships;Developing an E-R Diagram;Heather Sweeney Designs:The Seminar Customer List;Heather Sweeney Designs:Initial E-R Diagram I;Heather Sweeney Designs:Initial E-R Diagram II;Heather Sweeney Designs:Initial E-R Diagram III;Heather Sweeney Designs:The Customer Form Letter;Heather Sweeney Designs:Data Model with CONTACT;Heather Sweeney Designs:Data Model with CONTACT as Weak Entity;Heather Sweeney Designs:Data Model with Modified CUSTOMER;Heather Sweeney Designs:Sales Invoice;Heather Sweeney Designs:Data Model with INVOICE;Heather Sweeney Designs:Data Model with LINE_ITEM;Heather Sweeney Designs:Final Data Model;Heather Sweeney Designs:Business Rules and Model Validation