PPT-Chapter3 : Entity-Relationship

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 . 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. 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.. 2. Outline. Data Modeling: Big picture. E-R Model. Attributes. types. Relationships. connectivity, cardinality. strength, participation, degree. Entities. composite entity. supertype/subtype. Table Normalization. Practice . (3) . :. Data Modelling & the Entity-Relationship Approach. UFCE8V-20-3 . Information Systems Development 3 (SHAPE HK). E-R modelling concepts (1). Entity & Attribute. An . entity. 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 . Requirements & collection analysis. Conceptual Design. Data Model Mapping. Physical Design. Database Requirements. Conceptual Schema (in a high-level data model). DBMS independent. DBMS specific. Spring 2011. Instructor: Hassan . Khosravi. Database Modeling and . implemnation. process. Ideas. High-Level . Design. Relational Database. Schema. Relational. DBMS. The Entity/Relationship Model . 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. 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 Cal Poly Pomona. Overview of Database Design Process. Two main activities:. Database design. Applications design. Focus in this chapter on . conceptual database design. To design the conceptual schema for a database application. Queries . Using . an . Extended . Graph Model. Ankur. . Agrawal. . S. Sudarshan . Ajitav. . Sahoo. . Adil. . Sandalwala. . Prashant. . Jaiswal. . IIT . Bombay. History of Keyword Queries.