EntityRelationship资料.pptVIP

Unit 5 Entity-Relationship Model E-R Diagram for a Banking Enterprise Chapter 6: Entity-Relationship Model 6.1. Design Process 6.2. E-R Model (名詞定義) 6.3. Constraints (對模型提出限制 e.g.對應數目) 6.4. E-R Diagram (模型解說) 6.5. E-R Design Issues (其他議題) 6.6. Weak Entity Sets 6.7. Extended E-R Features 6.8. Design for the Banking Enterprise 6.9. Reduction to Relation Schemas 6.10. Database Design 6.11. UML Design Process Relational Database Application Layer: SQL/ Host language Relational Model: Relational Algebra Logical Database Design Normalization Semantic Modeling, i.e., E-R model Physical Database Design Storage and File Structure Indexing and Hashing Query Process Optimization Transactions Concurrency Control Recovery System Modeling A database can be modeled as: a collection of entities, relationship among entities. An entity is an object that exists and is distinguishable from other objects. Example: specific person, company, event, plant Entities have attributes Example: people have names and addresses An entity set is a set of entities of the same type that share the same properties. Example: set of all persons, companies, trees, holidays Break (example: ER-model of “S, P, SP”) Attributes An entity is represented by a set of attributes, that is descriptive properties possessed by all members of an entity set. Domain – the set of permitted values for each attribute Attribute types: Simple and composite attributes. Single-valued and multi-valued attributes Example: multivalued attribute: phone_numbers Derived attributes Can be computed from other attributes Example: age, given date_of_birth E-R Diagram With Composite, Multivalued, and Derived Attributes Composite Attributes Entity Sets customer and loan Example (“S, P, SP”) Relationship Sets A relationship is an association among several entities Example: Hayes depositor A-102 customer entity relationship set account entity A relationship set is a mathematical relation among n ? 2 entities, each taken fr