This article is rated C-class on Wikipedia's
content assessment scale. It is of interest to the following WikiProjects: | ||||||||||||||||||||||||
|
" what is the meaning of 428 BC near his name?" [1] 46.114.104.43 ( talk) 13:01, 3 April 2020 (UTC)
References
"...for instance, your entry in the database could point to several entries for each of the phone numbers that are yours" I can't understand what this is trying to say. First off, what does it mean "your entry". -- 206.87.81.34 ( talk) 08:08, 2 November 2012 (UTC)
In 13 years doing database work in the United States, I've Foot notation everywhere. This part needs a citation: "Usage of Chen notation is more prevalent in the United States, while Crow's Foot notation is used primarily in the UK."
205.173.24.4 ( talk) 18:58, 17 November 2010 (UTC)
This part needs a citation: "Usage of Chen notation is more prevalent in the United States, while Crow's Foot notation is used primarily in the UK and Australasia." â Preceding unsigned comment added by Kdf9andtd1a ( talk ⢠contribs) 02:32, 15 July 2011 (UTC)
I must say that I agree at least on the lack of clarity of the first sentence. Either its meaning is wrong or it is poorly written. Whichever it is, the first sentence of the introduction is misleading to the least. 194.221.74.7 08:54, 8 June 2006 (UTC)
I'm not sure about a relationship having an attribute. How can this convert into a logical model?-- Nick 18:11, 4 March 2006 (UTC)
Another issue is the (universal) confusion between entities and entity sets, relationships and relationship sets. This article dutifully explains the "correct" use of the terms, but before it does so has already used them "incorrectly" (i.e. how everybody uses them in practice) quite a few times. So either the terms e. set and r. set should be omitted or a more thorough clarification is in order. Rp 12:17, 10 July 2006 (UTC)
Any chance someone could mock up a set of images showing what these symbols are supposed to look like? Describing them is all well and good, but a picture can be worth a thousand words. Â :) Thanks, Eirikr 03:45, 8 Apr 2005 (UTC)
Agreed. Just for fun: Can we get an ERD of the wiki that wikipedia et al. use?
As far as I know there are multiple ways of drawing ER diagrams. I use arrows. Yet the article implies that''''Bold text' there's only this one way.
Where's the explanation/links about ER 2004? -- Khokkanen 12:53, 10 June 2006 (UTC)
This diagram is not remotely similar to the methods used by nearly all of the major ER tools in use today. IDEF1X is far and away a more common mechanism, as are derivatives of that method that vary primarily in the symbols used to indicate n-ary relationships.
I suggest we replace this article with one that is similar to the article referenced by the IDEF1X link (US Navy, I think). This article is absolutely useless for practitioners and students of ER models. User:nickmalik 11:47 15 Oct 2006 {PDT)
What about the cardinalities of relationships? I thought these were annotated by numbers on the arcs of the relationships? Jam2001 12:50, 18 October 2006 (UTC)
I have added a section entitled
Alternative diagramming conventions with a diagram and explanation for Crow's Feet notation. I encourage you all to post up similar descriptions of the notations you prefer.
If I have the support of other Wikipedians here, I'd be happy to refactor the Common symbols section, putting the "Crow's Feet" notation at the top until such time as we have a more appropriate notation available. Please let me know. Matthew 1130 12:37, 19 December 2006 (UTC)
The problem is that there are at least half-a-dozen different diagrammatic notations, which people call "ERDs". Proponents of IDEF(1X), Crow's Foot, Chen-style, and at least two others that I can draw but can't name, will insist that their style is the "one true ERD". The Chen style (which *is* the original) is distinguished from the others by representing relationship types explicitly as "first class objects" (nodes) rather than as lines (edges). AFAICT, every diagram in any of the other (non-Chen) styles of "ERD" is isomorphic to a relational schema and, therefore, to a diagram in any of the other styles. In other words, any non-Chen "ERD" can be converted to a non-Chen "ERD" in one of the other styles by a simple relabeling and no "mapping procedure" is needed to obtain a relational schema; they are, therefore, merely alternative representations of relational schemata. There is information loss in mapping from a Chen-style ERD to a relational schema (e.g. compound attributes are flattened), so it *is* different and, IMHO, operates at a somewhat higher level of abstraction. The assertion that the Chen-style diagram "is not standard" is simply false: it may not be your favourite style (e.g. IDEF(1X)), but it is a perfectly standard Chen-style (i.e. "original") ERD and these are used for pedagogic purposes in textbooks (c.f. Elmasri & Navathe) and university courses (at least two that I know of in two different countries) all over the world. --
EmmetCaulfield 11:43, 6 November 2007 (UTC)
I'm almost positive that the character should run into the creep instantiation and not the creep? Could someone verify this? Epachamo 23:02, 3 November 2006 (UTC)
I think there was some misunderstanding here. A character would indeed run into an instance of a creep during the game - but that's not what this database is storing. This database is storing each type of creep which the character has encountered. -- Matthew Tardiff ( 12.199.176.12 ( talk) 21:47, 20 August 2009 (UTC))
I doubt that an Entity-relationship model can be called a data model. It is a method to design data models. -- Udo Altmann 13:42, 18 Oct 2004 (UTC)
I was consulting this entry in order to learn about how the terms relation vs. relationship are used.
Unfortunately, after reading the entry I was even more confused, because the "Common symbols" section seems to use both words interchangeably:
"Relationships im single can be thought of as verbs. Examples: an owns relation between a company and a computer ..."
Is this uncertainty inherent in those words? Or is there any consensus on how to distinguish these three levels:
87.162.24.12 16:15, 21 January 2007 (UTC)
You are correct ... the Common symbols section needs a fair bit of work. I've made the correction, but it still needs more work another day.
To put it into common language, if your brother is a "relation" (aka "entity"), then you have a "relationship" with him, keeping in mind that this is a rather rough analogy.
A tuple is the correct term, and probably should be mentioned on the article somewhere, although I usually prefer the term row or record because it reaches a wider audience.
Thanks,
Matthew 1130 12:47, 22 January 2007 (UTC)
The software currently listed is mostly shareware. Can this list cleaned up?? Most of the software doesn't even draw real (E)ER! They are *DATABASE* design tools, (E)ER is a particular modeling language. -- ThG 14:22, 13 January 2007 (UTC)
I removed all the external links. It was becoming quite a linkfarm, violating WP:EL and WP:NOT#REPOSITORY . -- Ronz 02:50, 17 February 2007 (UTC)
The "ER diagramming tools" section is becoming a linkfarm, with the inappropriate external links. The section may be large enough to become a separate article as well. For now, I'm removing the external links per WP:NOT#REPOSITORY. -- Ronz 15:49, 19 March 2007 (UTC)
Here are the (refactored per WP:TALK) latest deleted links, calling volunteers to create wikipedia pages for these products:
-- Matthew 1130 15:41, 8 August 2007 (UTC)
I've cleaned up the links yet again, removing linkspam and entries that don't have their own articles. --
Ronz (
talk) 23:05, 19 November 2007 (UTC)
I have put the folowing text in Ronz talk page:
Hello Ronz,
I undid your removal of the non-notable softwares in Entity-Relationshiup Diagram page, because it has already helped me and I belive other users in finding a solution that can be adequate for creating this diagram with an open-source solution. I was the initial person who divided the list in proprietary and open source software as I was trying to find a software that fullfill my need, and as I expected, many other people contributed with solutions and finally I dicovered Power*Architect which has recently became open-source. I am a System Analyst of a major brazilian governament company and my division has adopted this software for it´s use after these events. So I think is really helpful, and ask you to leave it. As you may already know, there isn´t any open-source solution in this area with the recent exception I told you. Our best hope is Power*Architect and brModelo. Please don´t remove this list. Other softwares may appear and this page is my (and others) first source of information.
You me reach me on nt777@hotmail.com
Nelson Teixeira âPreceding unsigned comment added by 201.70.139.207 (talk) 02:02, 6 December 2007 (UTC)
To which Ronz responded:
Please discuss this on the article talk page. There are a couple of ways where something like this could be made to work, but it's going to take more than this I'm afraid. --Ronz (talk) 02:14, 6 December 2007 (UTC)
Ok Ronz, I´m kinda new on Wikipedia editing. What would be the right way to do it ?
Nelson -- Nt777 ( talk) 17:06, 11 December 2007 (UTC)
Ronz, I´ll try to find a realiable source in the next couple of days. Would you please leave the list online in the meantime ? And thank you for your information.
Nelson -- Nt777 ( talk) 17:06, 11 December 2007 (UTC)
Ronz, you cleaned up the links once again. Can we please have a written statement on the criteria for including links here? Otherwise we'll keep going back and forth on this without any real progress. Rp ( talk) 10:02, 1 November 2011 (UTC)
The link to Dr. Chen's paper in the references section is broken.
The link to Richard Barker references a page about a Hartlepool FC player Richie Barker User:NigelThomas âPreceding unsigned comment added by 212.58.233.129 ( talk) 14:31, 7 January 2008 (UTC)
I fixed the image of the crow feet, with the vertical line and the O being the wrong way round and uploaded the new version. Bencoder 17:16, 13 May 2007 (UTC)
The beginning of the article doesn't look encyclopedic. May I suggest: "ERM is a technique for the structure design of data on databases" or something like that? It would say the same it does now, but in a different order... Magdalena B. 12:28, 9 July 2007 (UTC)
It might also be helpful to provide a bit more context to somebody very new to the subject. For example, you might add something very basic such as, "Data models can become complicated quickly. An ERM is a tool that helps the designer to visualize and improve the design"... Bizerk44 ( talk) 14:32, 23 November 2007 (UTC)
The beginning of the article is misleading. ERM's history begins with Charlie Bachman's database diagrams and from there to Barrie Leigh's data modelling at IBM in 1971 and on to at least three threads: Tony Carter and Ian Palmer at CACI, London, Clive Finkelstein in Australia and Peter Chen in the USA. The ERM deliverable was both a verbal model and diagrammatic representation of the terms describing a domain. Clive may have known of Barry Leigh's work through working within IBM. Software engineering emerged from a NATO conference and while it probably now embraces ERM's these days, it had a different focus back then? â Preceding unsigned comment added by Kdf9andtd1a ( talk ⢠contribs) 04:04, 15 July 2011 (UTC)
Visio is mentioned as a free tool to create diagramms, but the Link directs to Microsoft Visio. Is there a free tool with the same name? (I can't find one) âPreceding unsigned comment added by 138.232.248.27 ( talk) 02:56, 16 December 2007 (UTC)
gliffy.com ? â Preceding
unsigned comment added by
137.195.15.10 (
talk) 15:18, 27 February 2014 (UTC)
According to the Information Engineering article, "Information Engineering ... is an approach to designing and developing information systems". It's not therefore an example of a notation "more typically employed in logical and physical database design". The IE methodology does use entity-relationship diagrams, and I've added a wikilink to it in the Crow's Foot section to replace the wikilink in the introduction. -- Northernhenge ( talk) 09:50, 11 April 2008 (UTC)
Some wereks ago I trimmed a long list of software programs supporting supporting Entity-relationship models, see here, to the following normal size text:
Now I resored it again, but I don't understand, why it was removed here in the first place? There shouldn't be a list of over 50 tools, half of it not even notable enough to have a Wikipedia article of it's own. Lists like that are an invitation to keep spamming this article, with every new unknown tools. This is not acceptable in Wikipedia. -- Marcel Douwe Dekker ( talk) 15:49, 7 November 2008 (UTC)
Can anyone justify the Bachmann diagram? I definitely recall that in Bachmann diagrams, the arrow-head goes from "owner" to "member", that is from the "1" end of a relationship to the "many" end: I remember people criticising it for that. And I don't know what these open and solid circles are doing on the line. Arguably it doesn't really have a place here anyway, because the Codasyl model was never presented to the world as an ER model or as a data modelling technique (as destinct from a database model).
Mhkay ( talk) 07:39, 8 April 2009 (UTC)
I made another diagram and put it here: commons:File:Mea.png
Wooptoo ( talk) 17:55, 30 May 2009 (UTC)
According to http://rapidapplicationdevelopment.blogspot.com/2007/06/entity-relationship-diagram-example.html (not a reliable source, I know)
the crow's foot notation for person - location should be the other way around.
LOCATION has zero-to-many PERSONS born there.
PERSON has one and only one birthplace.
Now I've confused myself to the extent that I can't decipher the artist-performs-song pic.
So confused. Enlightened ones, take corrective measures if you please. No need to reply to this, I probably won't read the reply. Primary key ( talk) 17:49, 12 June 2009 (UTC)
I was stunned to see such a strange example of an ERD! I came to Wikipedia for some clarity and went away dumbfounded. There is so much detailed, and sometimes erroneous, disagreement that, if this discourse is held to be a serious source for producing ERDs, then Heaven help data modelling! âPreceding unsigned comment added by Vortigern one ( talk ⢠contribs) 17:19, 18 November 2009 (UTC)
The fact that StarUML, a UML modeling tool, was listed in this article as a ER modelling tool for two years suggests that either I'm unaware of StarUML's true capabilities or it would be worthwhile to add a section explaining the differences between ER models and UML class models in detail. Mind if I add such a section? Rp ( talk) 08:53, 26 March 2010 (UTC)
I'm guessing "ERA model" is just a more uncommon name for "ER model"? The reason I ask is that a newsgroup I read had a post with someone asking for an "ERA modeler", which I looked up and found this entry on Encyclopedia.com. But I was unable to find an entry for ERA model or Entity-Relationship-Attribute on Wikipedia. I've created both those pages and redirected them to here. But I just wanted to make sure there wasn't some hidden distinction between an ER model and an ERA model. Otherwise, I guess ERA diagram should probably redirect here as well.-- Subversive Sound ( talk) 17:44, 13 May 2010 (UTC)
yeah, Entity-Relationship-Attribute model is pretty much the same. Entities and relationships have attributes - that's where the data's stored. When it comes time to make a real database, all the relationships are described with attributes too. Often, every entity has an integer ID - 1, 2, .... like the Person table could have an id field (attribute) named id. And another entity that has a relationship with that entity just points to the entity by storing the integer ID, like a phone record might have a field named person_id that points to the person who owns it. OsamaBinLogin ( talk) 20:40, 25 July 2012 (UTC)
The overview has recently been updated so the following comments are no longer significant! April 2012 â Preceding unsigned comment added by 208.44.95.13 ( talk) 18:41, 9 April 2012 (UTC)
Everything in the overview is wrong. There is no "first stage" of IS design. Different teams start different ways. ER diagrams are primarily intended for representing existing databases, not for conceptual modeling and requirements analysis. ER is a modeling grammar, not a technique. You can only describe one ontology with an ER diagram, that is, one in which the world is composed of entities and relationships. The discussion of mapping conceptual to logical data models is deeply misleading - there is no evidence that most teams bother with such an abstract process. The classical notation is not for conceptual modeling - people didn't even realize that ER could be bastardized into a conceptual modeling grammar until well after this notation was developed.
I will make a note to return and try to fix this in a few weeks, depending on reaction to this entry.
Paul Ralph (Lancaster University) ( talk) 23:24, 12 January 2011 (UTC)
"ER is a modeling grammar, not a technique. You can only describe one ontology with an ER diagram, ..." Sounds to me like a lot of big words. You should confine all these higher abstractions to another section, where I and most programmers can conveniently skip over them. Because, although they are concepts involved with ER diagrams, knowing them will rarely help one understand what they are - more likely, one is learning the meaning of 'modeling grammar' and 'ontology'.
My experience as a professional programmer tells me that most databases are designed like one of the following:
That's the way it seems to work. A programmer says to herself, "OK for each Foo, are there many Bars? For each Bar, are there many Foos?" Then the answer is obvious and fields are added to tables as the software evolves. No ER diagram is even visualized, although sometimes in sticky cases, entities are drawn like single database rows with individual fields, with relationship arrows coming out of the specific field that they inhabit, scribbled quickly on a piece of scrap paper in red ink. The relationships are always many-to-one. â Preceding unsigned comment added by OsamaBinLogin ( talk ⢠contribs) 21:04, 25 July 2012 (UTC)
The article starts from the wrong premise. It is based on Peter Chen's view of this topic. Much original thinking had already taken place within IBM and some London based consultancies, to my knowledge and probably elsewhere too. In the interests of clarity it would help to recognise the history of the topic, which the article has failed to do.
The history below is much better than nothing:
History ER Diagrams were first introduced by Charles Bachman. "Bachman Diagrams" described data structures, however, he did however go further and recognised the need to model at a higher level of abstraction.
â⌠entity to mean a particular object being considered; the term entity class will mean an entire group of entities which are sufficiently similar, in terms of attributes that describe them, to be considered collectively ⌠entity set ⌠associates a group of entities in one entity class with one entity of a different entity class in a subordinate relationshipâ page 4 of "Bachman, C. W. (1969) Data Structure Diagrams. DATA BASE 1(2): 4-10"
See a fuller discussion of the whole topic of Bachman and Chen diagramming in "The Entity Relationship Model And Practical Data Modelling By Steve Hitchman 2004, Journal of Conceptual Modeling, April 2004".
ER diagrams were popularised by Dr. Pin-Shan (Peter) Chen in 1976, but he drew on the previous work of his colleagues, one of whom was Charles Bachman.
Mention should also be made of J. Barrie Leigh "Mr. Leigh began his interest in E-R modeling techniques as a systems engineer for IBM in the UK, developing his first E-R diagram in 1971 for an annuity system of Royal Insurance. He was a recognized leader of transactional and database systems design for IBM, in the insurance industry. He evangelized the use of distributed intelligence and distributed database architectures throughout the 1970âs." See meeting notice for DAMA Philadelphi/Delaware Valley 10th January, 2007. While at CACI, London he worked with a number of key professionals including Ian Palmer, Rosemary Rock-Evans, Richard Barker and Keith Short all of whom made significant contributions to this field. â Preceding unsigned comment added by Kdf9andtd1a ( talk ⢠contribs) 22:39, 14 August 2011 (UTC)
The sub-section on 'Cardinalities' assumes much information not provided within the article, and uses the following terms without explanation or motivation:
And the two asides in parentheses only compound the jargon problem ...
The whole section 'Relationships, roles and cardinalities' smacks of either original research or personal opinion. At the very least, it needs some citations to support its contentions.
If the whole article is seen as an intelligent layman's overview of E-R modelling, the material presented throughout (but not in this sub-section) is quite hard enough. This sub-section on 'Cardinalities' is pitched at completely the wrong level.
As a seasoned ADP | EDP | DP | Computing | IT | ICT professional, I ask myself: What problem is the sub-section on 'Cardinalities' trying to solve? I can only conclude it's driving towards the quote from Feinerer, referencing Hartmann:
'Problems arise if we operate under the look-across semantics as used for UML associations ... different transformations fail.'
This surely is, at once, both too abstract and too low-level a consideration for the "intelligent layman" who has read the previous material?
If all the sub-section manages to say is that "look-across semantics don't work", or "... don't properly represent the meanings of the relations between entities", shouldn't the article then say what we DO about it?
For the present, I suggest scrapping all the text under the sub-heading "Cardinalities" and replacing it with an explanation of:
yoyo ( talk) 17:38, 8 April 2012 (UTC)
I started using Entity Modeling in approximately 1974 at the City of Westminster in London. This was based on work at ICL by Harry Ellis and David Gradwell et al. David Gradwell may well be able to provide even earlier history. A lot of the pioneers were related to the Data Dictionary Working Group within the British Computer Society at the time. This predated the Chen paper but Chen was usually considered the academic father of ER modeling simply because he published one of the first papers on the subject and it was very influential. His use of Relationships as first class objects was generally rejected at the time, as it didn't prove very useful for the practicioners. It supports n-ary relationships and the databases of the time didn't have much use for such relationships.
The techniques and notation used in ER modeling were developed by the database practicioners of the time. The problem that was being addressed was the inflexibility of CODASYL databases, such as DMS1100 (Univac) and IDMS which I think was used by ICL, hence their interest in ER modeling. You had to get the schema right as it was very difficult to alter it once the database was in production. This lead to the use of ER modeling as a basis for database design so that the schema would be well designed initially.
After Westminster, I joined CACI in the Netherlands and participated in the development of ER modeling with Ian Palmer, David Gradwell, Bernie Benetto and others. We introduced concepts and notation for entity subtypes and supertypes, time based data (ways to model dynamic data), relationship optionality and inclusive/exclusive relationships. At the time, CACI had two database cunsultancy offices in Europe, one in the UK and one in the Netherlands and they worked closely together on ER modeling. After that came Richard Barker, Rosemary Rock-Evans and others at CACI who documented the approach. From there it moved to James Martin Associates and then to Oracle.
Bachman's early work may have had some influence on ER modeling but it would have had to have been very early and relatively limited as we considered his approach more of a different and rival approach at the time. â Preceding unsigned comment added by Djwdjw123 ( talk ⢠contribs) 23:47, 7 November 2012 (UTC)
For many systems, the possible changes to the information contained are nontrivial and important enough to warrant explicit specification. - Could you elaborate more? Sumdumboot ( talk) 05:15, 28 March 2013 (UTC)
While this section is called Limitations, its bulleted list includes a wider range of content. See for example the items that simply highlight various extensions (or outright alternatives, like Anchor Modeling and EER). I'd expect the points to directly state the limitation of ER modeling and then identify the extension or alternative as a solution to the described limitation. As is it looks more like a random list of additional information than a list of limitations. The alternative would be to simply rename this section. Rszrama ( talk) 20:16, 8 May 2013 (UTC)
In addition, the last bullet in the list ("For modelling temporal databases ...") is just flat out wrong - Especially the part that ER would be unsuitable for multidimensional databases. What the refered paper (ref 25) does is to highlight needs of the platform specific model (a DBMS) and then conclude that the plaform independent model (i.e. ER-diagram) is unsuitable. To cite ref 25: "First, a logical representation is conceived to describe, at the appropriate level of abstraction, how data is stored in a specific DBMS, ..." This is absolutely NOT the reason for the logical model. The logical model describes what entities consist of and how they relate (i.e. business rules). Those ruels can't be broken. It has nothing to do with "... how data is stored ...". The business rules and info structure have a right of existance of their own - completely decoupled from implementation. The ER-model is the specification, the (R)DBMS is the implementation that must obey the ER-model. This is, however, not the same as saying how an entity type shall be implemented. It can be tables, multidimensional cubes or whatever form that is suitable for the implementation.
Ref 25 continues: "... but it is usually not expressive enough to capture in an effective way the essential, multidimensional aspects of a data warehousing application." The ER model is as expressive as the modeller can ever make it. ER-models can be expressive enough to be directly compiled to running applications (see xtUML). Correctness is the realm of the ER-modell. Efficienvy is the realm of the platform specific model (i.e. the specific implementation of the ER-model). â Preceding unsigned comment added by 136.163.203.3 ( talk) 13:29, 21 September 2022 (UTC)
Does anyone else feel like the resource linked to from the external links section is poor quality? The information is helpful but the formatting and readability issues seem to detract from the ability for a normal user to find the page useful. Any suggestions for a better resource? Bhanks ( talk) 20:49, 9 July 2013 (UTC)
I left in the poorly formatted resource but deleted a page that had a bunch of affiliate links at the bottom and also a resource that 404ed. I also added a diagramming tool that is free that I like to use. Bhanks ( talk) 21:11, 9 July 2013 (UTC)
Which is preferable for the lead sentence?
A. In software engineering, an entityârelationship model (ER model) is a data model for describing the data or information aspects of a business domain or its process requirements, in an abstract way that lends itself to ultimately being implemented in a database such as a relational database.
or some thing like:
B. An entityârelationship model (ER model) is a data model used in software engineering for describing the data or information aspects of a business domain or its process requirements, in an abstract way that lends itself to ultimately being implemented in a database such as a relational database.
Joja lozzo 18:01, 11 March 2014 (UTC)
The introduction still doesn't make much sense:
Rp ( talk) 12:23, 24 June 2015 (UTC)
Entity class redirects to this article, but the term isn't mentioned, and I have no idea what it means. Can anyone explain? Rp ( talk) 18:55, 12 July 2015 (UTC)
Hello fellow Wikipedians,
I have just added archive links to one external link on
Entityârelationship model. Please take a moment to review
my edit. If necessary, add {{
cbignore}}
after the link to keep me from modifying it. Alternatively, you can add {{
nobots|deny=InternetArchiveBot}}
to keep me off the page altogether. I made the following changes:
When you have finished reviewing my changes, please set the checked parameter below to true to let others know.
This message was posted before February 2018.
After February 2018, "External links modified" talk page sections are no longer generated or monitored by InternetArchiveBot. No special action is required regarding these talk page notices, other than
regular verification using the archive tool instructions below. Editors
have permission to delete these "External links modified" talk page sections if they want to de-clutter talk pages, but see the
RfC before doing mass systematic removals. This message is updated dynamically through the template {{
source check}}
(last update: 5 June 2024).
Cheers.â cyberbot II Talk to my owner:Online 05:02, 10 February 2016 (UTC)
I like the newly added section Modelling issues, but it needs further improvement:
Both the "fan-trap" issue and the 'chasm-trap' are a clear indications that the model is missing critical pieces. The sane path forward is to update the ER-model. In the 'fan-trap' case, the model is missing an assignment relation (e.g. staff-department in ref 24). In the 'chasm-trap' a relation between a computer and e.g. an owner. This is not an issue with ER. It's an issue with the modeller's limited understanding of the problem at hand.
Is the page Crow's Foot Notation truly authoritive (yes I know I spell "authoritive" differently than most)? It looks like someones' college notes. What qualifies bernatja at the University of Regina as an authority? Or can I just create a page somewhere about something and cite it as an authority? Sam Tomato ( talk) 05:50, 12 November 2016 (UTC)
Hello fellow Wikipedians,
I have just modified one external link on Entityârelationship model. Please take a moment to review my edit. If you have any questions, or need the bot to ignore the links, or the page altogether, please visit this simple FaQ for additional information. I made the following changes:
When you have finished reviewing my changes, you may follow the instructions on the template below to fix any issues with the URLs.
This message was posted before February 2018.
After February 2018, "External links modified" talk page sections are no longer generated or monitored by InternetArchiveBot. No special action is required regarding these talk page notices, other than
regular verification using the archive tool instructions below. Editors
have permission to delete these "External links modified" talk page sections if they want to de-clutter talk pages, but see the
RfC before doing mass systematic removals. This message is updated dynamically through the template {{
source check}}
(last update: 5 June 2024).
Cheers.â InternetArchiveBot ( Report bug) 16:52, 8 September 2017 (UTC)
Some experts maintain that the ERD is a graphical tool to visualize a conceptual model (which is by the way a different thing from the conceptual schema). A conceptual model is supposed to represent the business world (the universe of discourse or domain of interest that the model is supposed to represent) and such constructs like "keys" or "indices" or "privileges", etc. which are the peculiarities of the database model do not belong in the conceptual model and by extension in the ERD which merely visualizes the conceptual model. Primary keys are relevant to the Logical Model (which broadly translates the conceptual model in terms of a given database model (often relational). Simply put, real world entities do not have a "key". Tables do. Ehsanamini ( talk) 07:42, 27 September 2019 (UTC)
To be your lover foreverâ¤ď¸ 41.116.177.176 ( talk) 10:41, 17 April 2022 (UTC)
This article mixes model and diagram in a very confusing way. Confusing for both readers as authors. It starts off rather well in the introduction defining three different levels of model or the three-schema_approach and than leaves that and jumps right into different diagramms and loses track about which is what pretty quickly. For me diagrams are tools to describe a model.
I realize that there are quite some opinions floating around here but this article as it is now is not very useful for students or experts alike.
On thing that could help is to call it Entity Relationship Diagram that describe a set of possible, practical notations and tools to describe a relational database schema and leave the conceptual model description out and move it a more high level articale comparing hierarchical, network and relation databases models.
This article is rated C-class on Wikipedia's
content assessment scale. It is of interest to the following WikiProjects: | ||||||||||||||||||||||||
|
" what is the meaning of 428 BC near his name?" [1] 46.114.104.43 ( talk) 13:01, 3 April 2020 (UTC)
References
"...for instance, your entry in the database could point to several entries for each of the phone numbers that are yours" I can't understand what this is trying to say. First off, what does it mean "your entry". -- 206.87.81.34 ( talk) 08:08, 2 November 2012 (UTC)
In 13 years doing database work in the United States, I've Foot notation everywhere. This part needs a citation: "Usage of Chen notation is more prevalent in the United States, while Crow's Foot notation is used primarily in the UK."
205.173.24.4 ( talk) 18:58, 17 November 2010 (UTC)
This part needs a citation: "Usage of Chen notation is more prevalent in the United States, while Crow's Foot notation is used primarily in the UK and Australasia." â Preceding unsigned comment added by Kdf9andtd1a ( talk ⢠contribs) 02:32, 15 July 2011 (UTC)
I must say that I agree at least on the lack of clarity of the first sentence. Either its meaning is wrong or it is poorly written. Whichever it is, the first sentence of the introduction is misleading to the least. 194.221.74.7 08:54, 8 June 2006 (UTC)
I'm not sure about a relationship having an attribute. How can this convert into a logical model?-- Nick 18:11, 4 March 2006 (UTC)
Another issue is the (universal) confusion between entities and entity sets, relationships and relationship sets. This article dutifully explains the "correct" use of the terms, but before it does so has already used them "incorrectly" (i.e. how everybody uses them in practice) quite a few times. So either the terms e. set and r. set should be omitted or a more thorough clarification is in order. Rp 12:17, 10 July 2006 (UTC)
Any chance someone could mock up a set of images showing what these symbols are supposed to look like? Describing them is all well and good, but a picture can be worth a thousand words. Â :) Thanks, Eirikr 03:45, 8 Apr 2005 (UTC)
Agreed. Just for fun: Can we get an ERD of the wiki that wikipedia et al. use?
As far as I know there are multiple ways of drawing ER diagrams. I use arrows. Yet the article implies that''''Bold text' there's only this one way.
Where's the explanation/links about ER 2004? -- Khokkanen 12:53, 10 June 2006 (UTC)
This diagram is not remotely similar to the methods used by nearly all of the major ER tools in use today. IDEF1X is far and away a more common mechanism, as are derivatives of that method that vary primarily in the symbols used to indicate n-ary relationships.
I suggest we replace this article with one that is similar to the article referenced by the IDEF1X link (US Navy, I think). This article is absolutely useless for practitioners and students of ER models. User:nickmalik 11:47 15 Oct 2006 {PDT)
What about the cardinalities of relationships? I thought these were annotated by numbers on the arcs of the relationships? Jam2001 12:50, 18 October 2006 (UTC)
I have added a section entitled
Alternative diagramming conventions with a diagram and explanation for Crow's Feet notation. I encourage you all to post up similar descriptions of the notations you prefer.
If I have the support of other Wikipedians here, I'd be happy to refactor the Common symbols section, putting the "Crow's Feet" notation at the top until such time as we have a more appropriate notation available. Please let me know. Matthew 1130 12:37, 19 December 2006 (UTC)
The problem is that there are at least half-a-dozen different diagrammatic notations, which people call "ERDs". Proponents of IDEF(1X), Crow's Foot, Chen-style, and at least two others that I can draw but can't name, will insist that their style is the "one true ERD". The Chen style (which *is* the original) is distinguished from the others by representing relationship types explicitly as "first class objects" (nodes) rather than as lines (edges). AFAICT, every diagram in any of the other (non-Chen) styles of "ERD" is isomorphic to a relational schema and, therefore, to a diagram in any of the other styles. In other words, any non-Chen "ERD" can be converted to a non-Chen "ERD" in one of the other styles by a simple relabeling and no "mapping procedure" is needed to obtain a relational schema; they are, therefore, merely alternative representations of relational schemata. There is information loss in mapping from a Chen-style ERD to a relational schema (e.g. compound attributes are flattened), so it *is* different and, IMHO, operates at a somewhat higher level of abstraction. The assertion that the Chen-style diagram "is not standard" is simply false: it may not be your favourite style (e.g. IDEF(1X)), but it is a perfectly standard Chen-style (i.e. "original") ERD and these are used for pedagogic purposes in textbooks (c.f. Elmasri & Navathe) and university courses (at least two that I know of in two different countries) all over the world. --
EmmetCaulfield 11:43, 6 November 2007 (UTC)
I'm almost positive that the character should run into the creep instantiation and not the creep? Could someone verify this? Epachamo 23:02, 3 November 2006 (UTC)
I think there was some misunderstanding here. A character would indeed run into an instance of a creep during the game - but that's not what this database is storing. This database is storing each type of creep which the character has encountered. -- Matthew Tardiff ( 12.199.176.12 ( talk) 21:47, 20 August 2009 (UTC))
I doubt that an Entity-relationship model can be called a data model. It is a method to design data models. -- Udo Altmann 13:42, 18 Oct 2004 (UTC)
I was consulting this entry in order to learn about how the terms relation vs. relationship are used.
Unfortunately, after reading the entry I was even more confused, because the "Common symbols" section seems to use both words interchangeably:
"Relationships im single can be thought of as verbs. Examples: an owns relation between a company and a computer ..."
Is this uncertainty inherent in those words? Or is there any consensus on how to distinguish these three levels:
87.162.24.12 16:15, 21 January 2007 (UTC)
You are correct ... the Common symbols section needs a fair bit of work. I've made the correction, but it still needs more work another day.
To put it into common language, if your brother is a "relation" (aka "entity"), then you have a "relationship" with him, keeping in mind that this is a rather rough analogy.
A tuple is the correct term, and probably should be mentioned on the article somewhere, although I usually prefer the term row or record because it reaches a wider audience.
Thanks,
Matthew 1130 12:47, 22 January 2007 (UTC)
The software currently listed is mostly shareware. Can this list cleaned up?? Most of the software doesn't even draw real (E)ER! They are *DATABASE* design tools, (E)ER is a particular modeling language. -- ThG 14:22, 13 January 2007 (UTC)
I removed all the external links. It was becoming quite a linkfarm, violating WP:EL and WP:NOT#REPOSITORY . -- Ronz 02:50, 17 February 2007 (UTC)
The "ER diagramming tools" section is becoming a linkfarm, with the inappropriate external links. The section may be large enough to become a separate article as well. For now, I'm removing the external links per WP:NOT#REPOSITORY. -- Ronz 15:49, 19 March 2007 (UTC)
Here are the (refactored per WP:TALK) latest deleted links, calling volunteers to create wikipedia pages for these products:
-- Matthew 1130 15:41, 8 August 2007 (UTC)
I've cleaned up the links yet again, removing linkspam and entries that don't have their own articles. --
Ronz (
talk) 23:05, 19 November 2007 (UTC)
I have put the folowing text in Ronz talk page:
Hello Ronz,
I undid your removal of the non-notable softwares in Entity-Relationshiup Diagram page, because it has already helped me and I belive other users in finding a solution that can be adequate for creating this diagram with an open-source solution. I was the initial person who divided the list in proprietary and open source software as I was trying to find a software that fullfill my need, and as I expected, many other people contributed with solutions and finally I dicovered Power*Architect which has recently became open-source. I am a System Analyst of a major brazilian governament company and my division has adopted this software for it´s use after these events. So I think is really helpful, and ask you to leave it. As you may already know, there isn´t any open-source solution in this area with the recent exception I told you. Our best hope is Power*Architect and brModelo. Please don´t remove this list. Other softwares may appear and this page is my (and others) first source of information.
You me reach me on nt777@hotmail.com
Nelson Teixeira âPreceding unsigned comment added by 201.70.139.207 (talk) 02:02, 6 December 2007 (UTC)
To which Ronz responded:
Please discuss this on the article talk page. There are a couple of ways where something like this could be made to work, but it's going to take more than this I'm afraid. --Ronz (talk) 02:14, 6 December 2007 (UTC)
Ok Ronz, I´m kinda new on Wikipedia editing. What would be the right way to do it ?
Nelson -- Nt777 ( talk) 17:06, 11 December 2007 (UTC)
Ronz, I´ll try to find a realiable source in the next couple of days. Would you please leave the list online in the meantime ? And thank you for your information.
Nelson -- Nt777 ( talk) 17:06, 11 December 2007 (UTC)
Ronz, you cleaned up the links once again. Can we please have a written statement on the criteria for including links here? Otherwise we'll keep going back and forth on this without any real progress. Rp ( talk) 10:02, 1 November 2011 (UTC)
The link to Dr. Chen's paper in the references section is broken.
The link to Richard Barker references a page about a Hartlepool FC player Richie Barker User:NigelThomas âPreceding unsigned comment added by 212.58.233.129 ( talk) 14:31, 7 January 2008 (UTC)
I fixed the image of the crow feet, with the vertical line and the O being the wrong way round and uploaded the new version. Bencoder 17:16, 13 May 2007 (UTC)
The beginning of the article doesn't look encyclopedic. May I suggest: "ERM is a technique for the structure design of data on databases" or something like that? It would say the same it does now, but in a different order... Magdalena B. 12:28, 9 July 2007 (UTC)
It might also be helpful to provide a bit more context to somebody very new to the subject. For example, you might add something very basic such as, "Data models can become complicated quickly. An ERM is a tool that helps the designer to visualize and improve the design"... Bizerk44 ( talk) 14:32, 23 November 2007 (UTC)
The beginning of the article is misleading. ERM's history begins with Charlie Bachman's database diagrams and from there to Barrie Leigh's data modelling at IBM in 1971 and on to at least three threads: Tony Carter and Ian Palmer at CACI, London, Clive Finkelstein in Australia and Peter Chen in the USA. The ERM deliverable was both a verbal model and diagrammatic representation of the terms describing a domain. Clive may have known of Barry Leigh's work through working within IBM. Software engineering emerged from a NATO conference and while it probably now embraces ERM's these days, it had a different focus back then? â Preceding unsigned comment added by Kdf9andtd1a ( talk ⢠contribs) 04:04, 15 July 2011 (UTC)
Visio is mentioned as a free tool to create diagramms, but the Link directs to Microsoft Visio. Is there a free tool with the same name? (I can't find one) âPreceding unsigned comment added by 138.232.248.27 ( talk) 02:56, 16 December 2007 (UTC)
gliffy.com ? â Preceding
unsigned comment added by
137.195.15.10 (
talk) 15:18, 27 February 2014 (UTC)
According to the Information Engineering article, "Information Engineering ... is an approach to designing and developing information systems". It's not therefore an example of a notation "more typically employed in logical and physical database design". The IE methodology does use entity-relationship diagrams, and I've added a wikilink to it in the Crow's Foot section to replace the wikilink in the introduction. -- Northernhenge ( talk) 09:50, 11 April 2008 (UTC)
Some wereks ago I trimmed a long list of software programs supporting supporting Entity-relationship models, see here, to the following normal size text:
Now I resored it again, but I don't understand, why it was removed here in the first place? There shouldn't be a list of over 50 tools, half of it not even notable enough to have a Wikipedia article of it's own. Lists like that are an invitation to keep spamming this article, with every new unknown tools. This is not acceptable in Wikipedia. -- Marcel Douwe Dekker ( talk) 15:49, 7 November 2008 (UTC)
Can anyone justify the Bachmann diagram? I definitely recall that in Bachmann diagrams, the arrow-head goes from "owner" to "member", that is from the "1" end of a relationship to the "many" end: I remember people criticising it for that. And I don't know what these open and solid circles are doing on the line. Arguably it doesn't really have a place here anyway, because the Codasyl model was never presented to the world as an ER model or as a data modelling technique (as destinct from a database model).
Mhkay ( talk) 07:39, 8 April 2009 (UTC)
I made another diagram and put it here: commons:File:Mea.png
Wooptoo ( talk) 17:55, 30 May 2009 (UTC)
According to http://rapidapplicationdevelopment.blogspot.com/2007/06/entity-relationship-diagram-example.html (not a reliable source, I know)
the crow's foot notation for person - location should be the other way around.
LOCATION has zero-to-many PERSONS born there.
PERSON has one and only one birthplace.
Now I've confused myself to the extent that I can't decipher the artist-performs-song pic.
So confused. Enlightened ones, take corrective measures if you please. No need to reply to this, I probably won't read the reply. Primary key ( talk) 17:49, 12 June 2009 (UTC)
I was stunned to see such a strange example of an ERD! I came to Wikipedia for some clarity and went away dumbfounded. There is so much detailed, and sometimes erroneous, disagreement that, if this discourse is held to be a serious source for producing ERDs, then Heaven help data modelling! âPreceding unsigned comment added by Vortigern one ( talk ⢠contribs) 17:19, 18 November 2009 (UTC)
The fact that StarUML, a UML modeling tool, was listed in this article as a ER modelling tool for two years suggests that either I'm unaware of StarUML's true capabilities or it would be worthwhile to add a section explaining the differences between ER models and UML class models in detail. Mind if I add such a section? Rp ( talk) 08:53, 26 March 2010 (UTC)
I'm guessing "ERA model" is just a more uncommon name for "ER model"? The reason I ask is that a newsgroup I read had a post with someone asking for an "ERA modeler", which I looked up and found this entry on Encyclopedia.com. But I was unable to find an entry for ERA model or Entity-Relationship-Attribute on Wikipedia. I've created both those pages and redirected them to here. But I just wanted to make sure there wasn't some hidden distinction between an ER model and an ERA model. Otherwise, I guess ERA diagram should probably redirect here as well.-- Subversive Sound ( talk) 17:44, 13 May 2010 (UTC)
yeah, Entity-Relationship-Attribute model is pretty much the same. Entities and relationships have attributes - that's where the data's stored. When it comes time to make a real database, all the relationships are described with attributes too. Often, every entity has an integer ID - 1, 2, .... like the Person table could have an id field (attribute) named id. And another entity that has a relationship with that entity just points to the entity by storing the integer ID, like a phone record might have a field named person_id that points to the person who owns it. OsamaBinLogin ( talk) 20:40, 25 July 2012 (UTC)
The overview has recently been updated so the following comments are no longer significant! April 2012 â Preceding unsigned comment added by 208.44.95.13 ( talk) 18:41, 9 April 2012 (UTC)
Everything in the overview is wrong. There is no "first stage" of IS design. Different teams start different ways. ER diagrams are primarily intended for representing existing databases, not for conceptual modeling and requirements analysis. ER is a modeling grammar, not a technique. You can only describe one ontology with an ER diagram, that is, one in which the world is composed of entities and relationships. The discussion of mapping conceptual to logical data models is deeply misleading - there is no evidence that most teams bother with such an abstract process. The classical notation is not for conceptual modeling - people didn't even realize that ER could be bastardized into a conceptual modeling grammar until well after this notation was developed.
I will make a note to return and try to fix this in a few weeks, depending on reaction to this entry.
Paul Ralph (Lancaster University) ( talk) 23:24, 12 January 2011 (UTC)
"ER is a modeling grammar, not a technique. You can only describe one ontology with an ER diagram, ..." Sounds to me like a lot of big words. You should confine all these higher abstractions to another section, where I and most programmers can conveniently skip over them. Because, although they are concepts involved with ER diagrams, knowing them will rarely help one understand what they are - more likely, one is learning the meaning of 'modeling grammar' and 'ontology'.
My experience as a professional programmer tells me that most databases are designed like one of the following:
That's the way it seems to work. A programmer says to herself, "OK for each Foo, are there many Bars? For each Bar, are there many Foos?" Then the answer is obvious and fields are added to tables as the software evolves. No ER diagram is even visualized, although sometimes in sticky cases, entities are drawn like single database rows with individual fields, with relationship arrows coming out of the specific field that they inhabit, scribbled quickly on a piece of scrap paper in red ink. The relationships are always many-to-one. â Preceding unsigned comment added by OsamaBinLogin ( talk ⢠contribs) 21:04, 25 July 2012 (UTC)
The article starts from the wrong premise. It is based on Peter Chen's view of this topic. Much original thinking had already taken place within IBM and some London based consultancies, to my knowledge and probably elsewhere too. In the interests of clarity it would help to recognise the history of the topic, which the article has failed to do.
The history below is much better than nothing:
History ER Diagrams were first introduced by Charles Bachman. "Bachman Diagrams" described data structures, however, he did however go further and recognised the need to model at a higher level of abstraction.
â⌠entity to mean a particular object being considered; the term entity class will mean an entire group of entities which are sufficiently similar, in terms of attributes that describe them, to be considered collectively ⌠entity set ⌠associates a group of entities in one entity class with one entity of a different entity class in a subordinate relationshipâ page 4 of "Bachman, C. W. (1969) Data Structure Diagrams. DATA BASE 1(2): 4-10"
See a fuller discussion of the whole topic of Bachman and Chen diagramming in "The Entity Relationship Model And Practical Data Modelling By Steve Hitchman 2004, Journal of Conceptual Modeling, April 2004".
ER diagrams were popularised by Dr. Pin-Shan (Peter) Chen in 1976, but he drew on the previous work of his colleagues, one of whom was Charles Bachman.
Mention should also be made of J. Barrie Leigh "Mr. Leigh began his interest in E-R modeling techniques as a systems engineer for IBM in the UK, developing his first E-R diagram in 1971 for an annuity system of Royal Insurance. He was a recognized leader of transactional and database systems design for IBM, in the insurance industry. He evangelized the use of distributed intelligence and distributed database architectures throughout the 1970âs." See meeting notice for DAMA Philadelphi/Delaware Valley 10th January, 2007. While at CACI, London he worked with a number of key professionals including Ian Palmer, Rosemary Rock-Evans, Richard Barker and Keith Short all of whom made significant contributions to this field. â Preceding unsigned comment added by Kdf9andtd1a ( talk ⢠contribs) 22:39, 14 August 2011 (UTC)
The sub-section on 'Cardinalities' assumes much information not provided within the article, and uses the following terms without explanation or motivation:
And the two asides in parentheses only compound the jargon problem ...
The whole section 'Relationships, roles and cardinalities' smacks of either original research or personal opinion. At the very least, it needs some citations to support its contentions.
If the whole article is seen as an intelligent layman's overview of E-R modelling, the material presented throughout (but not in this sub-section) is quite hard enough. This sub-section on 'Cardinalities' is pitched at completely the wrong level.
As a seasoned ADP | EDP | DP | Computing | IT | ICT professional, I ask myself: What problem is the sub-section on 'Cardinalities' trying to solve? I can only conclude it's driving towards the quote from Feinerer, referencing Hartmann:
'Problems arise if we operate under the look-across semantics as used for UML associations ... different transformations fail.'
This surely is, at once, both too abstract and too low-level a consideration for the "intelligent layman" who has read the previous material?
If all the sub-section manages to say is that "look-across semantics don't work", or "... don't properly represent the meanings of the relations between entities", shouldn't the article then say what we DO about it?
For the present, I suggest scrapping all the text under the sub-heading "Cardinalities" and replacing it with an explanation of:
yoyo ( talk) 17:38, 8 April 2012 (UTC)
I started using Entity Modeling in approximately 1974 at the City of Westminster in London. This was based on work at ICL by Harry Ellis and David Gradwell et al. David Gradwell may well be able to provide even earlier history. A lot of the pioneers were related to the Data Dictionary Working Group within the British Computer Society at the time. This predated the Chen paper but Chen was usually considered the academic father of ER modeling simply because he published one of the first papers on the subject and it was very influential. His use of Relationships as first class objects was generally rejected at the time, as it didn't prove very useful for the practicioners. It supports n-ary relationships and the databases of the time didn't have much use for such relationships.
The techniques and notation used in ER modeling were developed by the database practicioners of the time. The problem that was being addressed was the inflexibility of CODASYL databases, such as DMS1100 (Univac) and IDMS which I think was used by ICL, hence their interest in ER modeling. You had to get the schema right as it was very difficult to alter it once the database was in production. This lead to the use of ER modeling as a basis for database design so that the schema would be well designed initially.
After Westminster, I joined CACI in the Netherlands and participated in the development of ER modeling with Ian Palmer, David Gradwell, Bernie Benetto and others. We introduced concepts and notation for entity subtypes and supertypes, time based data (ways to model dynamic data), relationship optionality and inclusive/exclusive relationships. At the time, CACI had two database cunsultancy offices in Europe, one in the UK and one in the Netherlands and they worked closely together on ER modeling. After that came Richard Barker, Rosemary Rock-Evans and others at CACI who documented the approach. From there it moved to James Martin Associates and then to Oracle.
Bachman's early work may have had some influence on ER modeling but it would have had to have been very early and relatively limited as we considered his approach more of a different and rival approach at the time. â Preceding unsigned comment added by Djwdjw123 ( talk ⢠contribs) 23:47, 7 November 2012 (UTC)
For many systems, the possible changes to the information contained are nontrivial and important enough to warrant explicit specification. - Could you elaborate more? Sumdumboot ( talk) 05:15, 28 March 2013 (UTC)
While this section is called Limitations, its bulleted list includes a wider range of content. See for example the items that simply highlight various extensions (or outright alternatives, like Anchor Modeling and EER). I'd expect the points to directly state the limitation of ER modeling and then identify the extension or alternative as a solution to the described limitation. As is it looks more like a random list of additional information than a list of limitations. The alternative would be to simply rename this section. Rszrama ( talk) 20:16, 8 May 2013 (UTC)
In addition, the last bullet in the list ("For modelling temporal databases ...") is just flat out wrong - Especially the part that ER would be unsuitable for multidimensional databases. What the refered paper (ref 25) does is to highlight needs of the platform specific model (a DBMS) and then conclude that the plaform independent model (i.e. ER-diagram) is unsuitable. To cite ref 25: "First, a logical representation is conceived to describe, at the appropriate level of abstraction, how data is stored in a specific DBMS, ..." This is absolutely NOT the reason for the logical model. The logical model describes what entities consist of and how they relate (i.e. business rules). Those ruels can't be broken. It has nothing to do with "... how data is stored ...". The business rules and info structure have a right of existance of their own - completely decoupled from implementation. The ER-model is the specification, the (R)DBMS is the implementation that must obey the ER-model. This is, however, not the same as saying how an entity type shall be implemented. It can be tables, multidimensional cubes or whatever form that is suitable for the implementation.
Ref 25 continues: "... but it is usually not expressive enough to capture in an effective way the essential, multidimensional aspects of a data warehousing application." The ER model is as expressive as the modeller can ever make it. ER-models can be expressive enough to be directly compiled to running applications (see xtUML). Correctness is the realm of the ER-modell. Efficienvy is the realm of the platform specific model (i.e. the specific implementation of the ER-model). â Preceding unsigned comment added by 136.163.203.3 ( talk) 13:29, 21 September 2022 (UTC)
Does anyone else feel like the resource linked to from the external links section is poor quality? The information is helpful but the formatting and readability issues seem to detract from the ability for a normal user to find the page useful. Any suggestions for a better resource? Bhanks ( talk) 20:49, 9 July 2013 (UTC)
I left in the poorly formatted resource but deleted a page that had a bunch of affiliate links at the bottom and also a resource that 404ed. I also added a diagramming tool that is free that I like to use. Bhanks ( talk) 21:11, 9 July 2013 (UTC)
Which is preferable for the lead sentence?
A. In software engineering, an entityârelationship model (ER model) is a data model for describing the data or information aspects of a business domain or its process requirements, in an abstract way that lends itself to ultimately being implemented in a database such as a relational database.
or some thing like:
B. An entityârelationship model (ER model) is a data model used in software engineering for describing the data or information aspects of a business domain or its process requirements, in an abstract way that lends itself to ultimately being implemented in a database such as a relational database.
Joja lozzo 18:01, 11 March 2014 (UTC)
The introduction still doesn't make much sense:
Rp ( talk) 12:23, 24 June 2015 (UTC)
Entity class redirects to this article, but the term isn't mentioned, and I have no idea what it means. Can anyone explain? Rp ( talk) 18:55, 12 July 2015 (UTC)
Hello fellow Wikipedians,
I have just added archive links to one external link on
Entityârelationship model. Please take a moment to review
my edit. If necessary, add {{
cbignore}}
after the link to keep me from modifying it. Alternatively, you can add {{
nobots|deny=InternetArchiveBot}}
to keep me off the page altogether. I made the following changes:
When you have finished reviewing my changes, please set the checked parameter below to true to let others know.
This message was posted before February 2018.
After February 2018, "External links modified" talk page sections are no longer generated or monitored by InternetArchiveBot. No special action is required regarding these talk page notices, other than
regular verification using the archive tool instructions below. Editors
have permission to delete these "External links modified" talk page sections if they want to de-clutter talk pages, but see the
RfC before doing mass systematic removals. This message is updated dynamically through the template {{
source check}}
(last update: 5 June 2024).
Cheers.â cyberbot II Talk to my owner:Online 05:02, 10 February 2016 (UTC)
I like the newly added section Modelling issues, but it needs further improvement:
Both the "fan-trap" issue and the 'chasm-trap' are a clear indications that the model is missing critical pieces. The sane path forward is to update the ER-model. In the 'fan-trap' case, the model is missing an assignment relation (e.g. staff-department in ref 24). In the 'chasm-trap' a relation between a computer and e.g. an owner. This is not an issue with ER. It's an issue with the modeller's limited understanding of the problem at hand.
Is the page Crow's Foot Notation truly authoritive (yes I know I spell "authoritive" differently than most)? It looks like someones' college notes. What qualifies bernatja at the University of Regina as an authority? Or can I just create a page somewhere about something and cite it as an authority? Sam Tomato ( talk) 05:50, 12 November 2016 (UTC)
Hello fellow Wikipedians,
I have just modified one external link on Entityârelationship model. Please take a moment to review my edit. If you have any questions, or need the bot to ignore the links, or the page altogether, please visit this simple FaQ for additional information. I made the following changes:
When you have finished reviewing my changes, you may follow the instructions on the template below to fix any issues with the URLs.
This message was posted before February 2018.
After February 2018, "External links modified" talk page sections are no longer generated or monitored by InternetArchiveBot. No special action is required regarding these talk page notices, other than
regular verification using the archive tool instructions below. Editors
have permission to delete these "External links modified" talk page sections if they want to de-clutter talk pages, but see the
RfC before doing mass systematic removals. This message is updated dynamically through the template {{
source check}}
(last update: 5 June 2024).
Cheers.â InternetArchiveBot ( Report bug) 16:52, 8 September 2017 (UTC)
Some experts maintain that the ERD is a graphical tool to visualize a conceptual model (which is by the way a different thing from the conceptual schema). A conceptual model is supposed to represent the business world (the universe of discourse or domain of interest that the model is supposed to represent) and such constructs like "keys" or "indices" or "privileges", etc. which are the peculiarities of the database model do not belong in the conceptual model and by extension in the ERD which merely visualizes the conceptual model. Primary keys are relevant to the Logical Model (which broadly translates the conceptual model in terms of a given database model (often relational). Simply put, real world entities do not have a "key". Tables do. Ehsanamini ( talk) 07:42, 27 September 2019 (UTC)
To be your lover foreverâ¤ď¸ 41.116.177.176 ( talk) 10:41, 17 April 2022 (UTC)
This article mixes model and diagram in a very confusing way. Confusing for both readers as authors. It starts off rather well in the introduction defining three different levels of model or the three-schema_approach and than leaves that and jumps right into different diagramms and loses track about which is what pretty quickly. For me diagrams are tools to describe a model.
I realize that there are quite some opinions floating around here but this article as it is now is not very useful for students or experts alike.
On thing that could help is to call it Entity Relationship Diagram that describe a set of possible, practical notations and tools to describe a relational database schema and leave the conceptual model description out and move it a more high level articale comparing hierarchical, network and relation databases models.