« Successful ProjectsFunny Pictures »

ERD - Basic Constructs

06/19/05 | by Clarise | Categories: Modeling

Looking at the stats of Yackity Blog Blog, I noticed that First 3 Rules of Data Normalization for Newbies gets a lot of hits. So, I thought today I would write about a very basic concept - the Basic Constructs of Entity Relationship Diagrams (ERD).

The three basic constructs are:

  1. Entity: A significant thing (place, person, concept, event) which information needs to be known or held
  2. Attribute: A characteristic that serves to identify, quantify, classify or qualify an entity
  3. Relationship: The way in which two entities are related

In ERD,
Entity is mapped to Table

Attribute is mapped to Column

Relationship is mapped to Foreign Key

Click to view original size

Send feedback »
 

No feedback yet

July 2019
Mon Tue Wed Thu Fri Sat Sun
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31        
 << <   > >>
This blog contains thoughts that range from non-technical to technical. Its name is derived from "Yakity Blah Blah" a column I once had that discussed a cornucopia of ideas. Who am I? I'm Clarise Z. Doval Santos, providing Project Management and Technical Leadership for data management and analytic, data science, IoT and sensor analytics ecosystems 37.652951177164 -122.490877706959

Search

  XML Feeds

powered by open-source CMS software