Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

Entity Relationship Model

By Exforsys | on April 23, 2007 |
Data Modeling

Entity Relationship Model

Structured data is stored in databases. Along with various other constraints, this data’s structure can be designed using entity relationship modeling, with the end result being an entity relationship diagram. Data modeling entails the usage of a notation for the representation of data models. An entity relationship diagram can be thought of as a type of semantic data model, or a conceptual one.

Entity relationship models are used during the first stage of information system design in order to elucidate types of info that are needed to be stored in the database during the phase of requirements analysis. Any ontology can be described via the data modeling technique for a specific area of interest. If the information system being designed is based on a database, then the conceptual data model will later be mapped on to a logical data model, which in turn will be mapped on to a physical model during the physical design process. (Sometimes both of these phases are referred to as “physical design.”)

Numerous conventions exist for entity relationship diagrams. Conceptual modeling is based largely on classical notation. Other notations, mostly used in physical and logical database design, include ICAM Definition Language, dimensional modeling, and information engineering.

An entity can be thought of as the representation of a discrete object. They are also nouns. So, for example, a song is an entity, as is an employee, a computer, a mathematical theorem, etc.

Relationships capture how entities relate to one another. Relationships are also verbs. “Supervises” might designate the relationship between an overseer and a department, “performs” serves to describe the relationship between an actor and a role, etc.

Whereas relationships are drawn as diamonds, entities are represented in the form of rectangles.

Attributes are unique qualities that can be possessed by both relationships and entities. Attributes are represented by ovals, which are connected to the entity sets that possess them by a line. With the exception of weak entities, all entities have to have a minimum amount of attributes. These make up the primary key of the entity.

Rather than displaying single instances of relations or lone entities, entity relationship diagrams display sets of entities and relationships. So, one song on a database is an entity, whereas a collection of songs on the database is the entity set.

Lines connect sets of entities to the sets of relationships with which they are involved. A thick line, known as a participation constraint, will be drawn in those instances when all the entities in a particular set are involved with the relationship set. If it is possible for every entity in an entity set to participate in at most one relation in the set of relationships, an arrow, known as a key constraint, will be drawn connecting the set of entities to the set of relationships. A thick arrow represents that every entity in a set of entities is involved in one relationship.

A couple of other useful definitions:

Associative entities are often used to solve the conflict of a couple of entities with many-to-many relationships.

Unary relationships are those relationships between the rows of a single table.

Weak entities cannot be identified with the help of its own attributes. It is thus necessary to use these entities’ primary keys, as well as the primary key of an entity that is related to it.

In an entity relationship model, attributes can be composite, derived, or multi-valued. Multi-valued attributes might have more than one value in one or more instances of its entity. These attributes are denoted with a two line ellipse. So, if a piece of software happens to run on more than one operating system, it could have the attribute “platform”; this is a multi-valued attribute. Composite attributes, on the other hand, are those attributes that might contain two or more attributes.

A composite attribute will have contributing attributes of its own. An example of a composite attribute is an address, as it is composed of attributes that include street address, city, state/region, country, etc. Finally, there are derived attributes. The value of these attributes is dependent wholly on another attribute. Derived attributes are denoted with dashed ellipses. So, in a database of employees that has an age attribute, the age attribute would have to be derived from an atttribute of birth dates.

« « How To Make Your Conversation Meaningful
Physical Data Models » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Free Training

RSSSubscribe 394 Followers
  • Popular
  • Recent
  • Tips for Mastering Data Modeling

    April 24, 2007 - 0 Comment
  • Role of Data Modeling within Enterprise Management

    May 3, 2007 - 0 Comment
  • Data Modeling Overview

    May 4, 2007 - 0 Comment
  • Data Modeling Introduction

    June 19, 2007 - 0 Comment
  • Connection between Data Model and Data Warehouse

    June 20, 2007 - 0 Comment
  • What is a Data Model

    January 11, 2007 - 0 Comment
  • The History of Data Modeling

    January 11, 2007 - 0 Comment
  • Data Modeling Explained

    January 31, 2007 - 0 Comment
  • Data Warehouse Glossary

    March 3, 2007 - 0 Comment
  • Physical Data Models

    April 23, 2007 - 0 Comment
  • Connection between Data Model and Data Warehouse

    June 20, 2007 - 0 Comment
  • Data Modeling Introduction

    June 19, 2007 - 0 Comment
  • Data Modeling Overview

    May 4, 2007 - 0 Comment
  • Role of Data Modeling within Enterprise Management

    May 3, 2007 - 0 Comment
  • Tips for Mastering Data Modeling

    April 24, 2007 - 0 Comment
  • Physical Data Models

    April 23, 2007 - 0 Comment
  • Data Warehouse Glossary

    March 3, 2007 - 0 Comment
  • Data Modeling Explained

    January 31, 2007 - 0 Comment
  • The History of Data Modeling

    January 11, 2007 - 0 Comment
  • What is a Data Model

    January 11, 2007 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • Connection between Data Model and Data Warehouse
  • Data Modeling Introduction
  • Data Modeling Overview
  • Role of Data Modeling within Enterprise Management
  • Tips for Mastering Data Modeling

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2023. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptReject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT