PPT-Enhanced Entity-Relationship Model (EER)

1 EnhancedER EER Model Concepts Includes all modeling concepts of basic ER Additional concepts subclasses superclasses specializationgeneralization categories attribute inheritance. 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. Entity. “An . entity. is a business object that represents a group, or category of data.”. 1. Do we know a similar concept? . 1) Stephens, R.K. and Plew. R.R., 2001. . Database Design. . SAMS, Indianapolis , IN.. 2. Outline. Data Modeling: Big picture. E-R Model. Attributes. types. Relationships. connectivity, cardinality. strength, participation, degree. Entities. composite entity. supertype/subtype. Table Normalization. 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. . Jose M. Peña. jose.m.pena@liu.se. Overview. Real world. Model. Queries. Answers. Databases. Physical . database. . DBMS. Processing of queries and . updates. Access to stored data. . Translation ER/EER to Relational. 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 . Requirements & collection analysis. Conceptual Design. Data Model Mapping. Physical Design. Database Requirements. Conceptual Schema (in a high-level data model). DBMS independent. DBMS specific. Modeling:. 1. CIS . 4365 . Entity Relationship Diagrams. Part 2. Your Individual Project. 2. CIS 4365 . Entity . Relationship Diagrams. We will develop the ERD as a class; you must execute complete the project . 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 Chapter Five: Data Modeling with the Entity-Relationship Model Chapter Objectives To understand the two-phase data modeling/database design process To understand the purpose of the data modeling process Basis Data 2. ER, Relational Model. Database Design. The database design process can be divided into six steps. The ER model . is most . relevant to the first three steps. .. Requirements . Analysis. Queries . Using . an . Extended . Graph Model. Ankur. . Agrawal. . S. Sudarshan . Ajitav. . Sahoo. . Adil. . Sandalwala. . Prashant. . Jaiswal. . IIT . Bombay. History of Keyword Queries.