PPT-Chapter Five: Data Modeling with the Entity-Relationship Model

Chapter Five Data Modeling with the EntityRelationship Model Chapter Objectives To understand the twophase data modelingdatabase design process To understand the purpose of the data modeling process. And 57375en 57375ere Were None meets the standard for Range of Reading and Level of Text Complexity for grade 8 Its structure pacing and universal appeal make it an appropriate reading choice for reluctant readers 57375e book also o57373ers students Man is a knot, a web, a mesh into which relationships are tied. Only those relationships matter. Saint-Exupéry. Data modeling. A technique for modeling data. A graphical representation of a database. Joe Meehean. 1. Entity Relationship Model. Entity type. an object (noun). e.g., student. attributes (e.g., last name). Relationship. association between entity types. bidirectional relationship between entities. Data Modeling Using the Entity-Relationship Model. Data Modeling. Process of creating a logical representation of the structure of the database. The most important task in database development. The Data Model. Shyam Pather (spather@microsoft.com). Development Manager. Microsoft. Session Code: DTL402. Session Objectives And Takeaways. Discuss the Entity Framework. Historic Perspective. Improvements. in Visual Studio 2010. System. s. Analysis. Structured analysis. Karolina . Muszyńska. Based partly on: http://www.csun.edu/~dn58412/IS431/IS431_SP13.html. Model-driven Analysis. Structured analysis. Information engineering. 1. Enhanced-ER (EER) Model Concepts. Includes all modeling concepts of basic ER . Additional concepts: subclasses/. superclasses. , specialization/generalization, categories, attribute inheritance. Man is a knot, a web, a mesh into which relationships are tied. Only those relationships matter. Saint-Exupéry. Data modeling. A technique for modeling data. A graphical representation of a database. Chapter 8 Outline. Subclasses, Superclasses, and Inheritance. Specialization and Generalization. Constraints and Characteristics of Specialization and Generalization Hierarchies. Modeling of UNION Types Using Categories. Pearson Education © 2009. 2. Chapter 17 - Objectives. How to derive . a set of . relations from a conceptual data model.. To create relations for the logical data model to represent the entities, relationships, and attributes that have been identified. . Chapter 2. Overview of Database Design. Conceptual design. : . (. ER Model . is used at this stage.) . What are the . entities. and . relationships. in the enterprise. ?. Students . sign up. . for . Data Modeling What are you keeping track of? You begin to develop a database by deciding what you are going to keep track of. Each “thing” that you are want to keep track becomes an entity in your database. MIS2502: Data Analytics Relational Data Modeling Acknowledgement: David Schuff Aaron Zhi Cheng http://community.mis.temple.edu/zcheng/ acheng@temple.edu Where we are… Transactional Database Analytical Data Store Peng Li, Jing Jiang, . Yinglin. Wang. Shanghai Jiao Tong University. Singapore Management University. An Example Entity Summary. July 13, 2010. ACL 2010. 2. An Example Entity Summary. July 13, 2010.