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. 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. 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. 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. Bob Lambert. blambert@captechconsulting.com. , @boblambert12. October 30, 2014. SQL Server Users Group. Lynchburg, Virginia. Introductions. Bob Lambert. >20 years in app . dev. , data warehousing, and project management. 2. Outline. Data Modeling: Big picture. E-R Model. Attributes. types. Relationships. connectivity, cardinality. strength, participation, degree. Entities. composite entity. supertype/subtype. Table Normalization. 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. Mussbacher. , . Gregor. v. . Bochmann. , . with . material from:. K.E. . Wiegers. , D. . Leffingwell. & D. . Widrig. , M. Jackson, I.K. Bray, B. . Selic. , . Volere. , . Telelogic. , D. Damian, S. . 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. Data Management 02 Conceptual Design Matthias Boehm Graz University of Technology, Austria Computer Science and Biomedical Engineering Institute of Interactive Systems and Data Science BMVIT endowed chair for Data Management Queries . Using . an . Extended . Graph Model. Ankur. . Agrawal. . S. Sudarshan . Ajitav. . Sahoo. . Adil. . Sandalwala. . Prashant. . Jaiswal. . IIT . Bombay. History of Keyword Queries.