PPT-1 Entity Relationship Modeling

2 Outline Data Modeling Big picture ER Model Attributes types Relationships connectivity cardinality strength participation degree Entities composite entity supertypesubtype Table Normalization. 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. Girts Karnitis, Janis Bicevskis, . Jana . Cerina-Berzina. The work is supported by a European Social Fund Project . No. . 2009/0216/1DP/1.1.1.2.0/09 /APIA/VIAA/044. Problems of Business process modeling. Tahmina Ahmed, Ravi Sandhu and . Jaehong. Park. ACM CODASPY. March 22-24, 2017. 1. Institute for Cyber Security. World-Leading Research with Real-World Impact!. by. Outline. Introduction . Background & Motivation. 1. Enhanced-ER (EER) Model Concepts. Includes all modeling concepts of basic ER . Additional concepts: subclasses/. superclasses. , specialization/generalization, categories, attribute inheritance. 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.. 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. . 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 INTRODUCTION TO NUMERICAL MODELING IN GEOTECHNICAL ENGINEERING WITH EMPHASIS ON FLAC MODELING www.zamiran.net By Siavash Zamiran, Ph.D., P.E. Geotechnical Engineer, Marino Engineering Associates, Inc. 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.