A description of the organization of a database. It is often created as an entity relationship diagram. Today's modeling tools allow the attributes and tables (fields and records) to be graphically created. The SQL code that defines the data structure (schema) in the database is automatically created from the visual representation. See entity relationship model.
Building an Entity Relationship Model
The Erwin modeling program from Logic Works, Princeton, NJ, stands for Entity Relationship for Windows. In this order processing example, the tables for customers and orders are drawn graphically, and Erwin turns the graph into the appropriate SQL code for the target database. (Example courtesy of Logic Works, Inc.)
Building an Entity Relationship Model
The Erwin modeling program from Logic Works, Princeton, NJ, stands for Entity Relationship for Windows. In this order processing example, the tables for customers and orders are drawn graphically, and Erwin turns the graph into the appropriate SQL code for the target database. (Example courtesy of Logic Works, Inc.)
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Empirical evidence: Arctic ice sheets thinner and softer
- I see the counter-offensive ("Anglia" anyone?) is in full swing.And.. yeah sure Harry, we're going to 'believe' your scientists.Like in the Apple ad: "Trust me, this time is different".:)Indeed. It's just pre-Copenhagen PR.And Copenhagen is about:- blaming the west- wealth distribution from the west to lazy and corrupt countries.Fair questionsAs...
- Discussion threads 2009-11-28
- SSPX 2.9 (Mac)
- SSPX is a program to calculate strain/strain rate from displacement/velocity data in two and three dimensions. SSPX is a full fledged inverse modeling program to calculate best fitting deformation tensors given displacement or velocity vectors at a minimum of three points in two dimensions, or four points in three dimensions....
- Software downloads 2009-11-27
- Garmin Nuvi 1690
- Garmin made a pretty big splash last year when it debuted the Nuvi 880, its first-ever Internet-connected portable navigation device PND featuring MSN Direct data service. With MSN Direct scheduled to go offline in the very near future, Garmin had to create something to fill this void, so it partnered...
- Product reviews 2009-11-24
- GoPro Motorsports HD Hero
- GoPro had a hit on its hands with the first-generation GoPro Hero. The small camera combined decent video quality and rugged reliability in a small package that was easy to use in action-based scenarios. However, the Hero wasn't without its flaws. Finicky battery choices that often cut recording sessions short...
- Product reviews 2009-11-24
- Sony VAIO VGN-NW270F/S
- Editors' note: This review is part of our 2009 Retail Laptop and Desktop Holiday Roundup, which covers specific fixed configurations of popular systems found in retail stores.The Sony Vaio VGN-NW270F/S is a stylish, spacious laptop for high-definition fans with low budgets. For a reasonable $699 at Best Buy, the Vaio...
- Product reviews 2009-11-24
- Is Google the Center of the Universe?
- It's not even a year since the triumphalism of Jeff Jarvis's Google 'reverse engineering' book 'What Would Google Do?' hit the book shelves, but it seems an age ago now. Jarvis's publisher Harper Collins claims this book is 'all about you' in their promo blurb - how you...
- Blog posts 2009-11-24
- What open source can teach medical practice
- Great article, Dana.You did in such a short piece what CNN, MSNBC, FOX and other media journalists failed to do: tell the story as it really is. You didn't take what was news worthy and sensationalized it, nor played up a negative reading of it to frighten those possibly affected,...
- Discussion threads 2009-11-24
- Apple to Verizon: 'Can your phone and your network do that?'
- The REAL way the commercials should go...caller: Did you get the email I sent you?iPhone user: Well, it was downloading, then the phone dropped to EDGE speed again and I'm still waiting for it to finish.caller: Well, why don't I ju...iPhone user: Hello? Hello? caller calls back: I guess your...
- Discussion threads 2009-11-23
- Google goes all-in with an open source cloud
- RE: Google goes all-in with an open source cloudGoogle is redifing the marketplace each day with calculated innovation to set the table for their advancement and domination in the future. I can't for the fight that is coming with MS Office next year and Google docs.another nail in M$...
- Discussion threads 2009-11-23
- 2010 Nissan Altima Coupe 2.5 S
- Photo gallery:2010 Nissan Altima Coupe 2.5 SWhen the 2010 Nissan Altima Coupe showed up in our garage, we registered some disappointment as we first looked around the car. The cool coupe style suggested days spent straightening the curves along winding mountain roads, but the continuously variable automatic transmission and four-cylinder...
- Product reviews 2009-11-20
- Asus K60IJ-RBLX05
- Editors' note: This review is part of our 2009 Retail Laptop and Desktop Holiday Roundup, which covers specific fixed configurations of popular systems found in retail stores. Buying a budget laptop often means cutting corners, so let's take a look at the Asus K60IJ-RBLX05. With a 16-inch screen and a...
- Product reviews 2009-11-19
- Dreamforce post#2: Chatter, Events, REA and the Future of Management
- REA stands for Resources, Events, AgentsHi,I really enjoy your blog posts very much. I wanted to provide one correction to your post. REA actually stands for Resources, Events, and Agents: http://en.wikipedia.org/wiki/Resources,_Events,_Agents . It was first suggested by William E. McCarthy in his 1982 paper "The REA Accounting...
- Discussion threads 2009-11-19
- HP Envy 15-1050nr
- A big brother to HP's 13-inch Envy 13, this upscale 15-inch model crams more computing power into a midsize laptop than anyone outside of Alienware's m15x. And while that system is a 10-pound monster, the Envy 15 manages to be both slim and reasonably lightweight, partially by ditching the internal...
- Product reviews 2009-11-19
- Inside the Google Chrome OS security model
- The proof will be in implementationAll of these lofty goals are one thing. Making it happen in code is quite another. It sounds like they are just giving a laundry list of what people want them to say. I'm in the "believe it when I see it" camp. Good intentions...
- Discussion threads 2009-11-19
- Google makes Chrome OS open source today
- Contrary to rumors, Google did not release a beta version of its much anticipated Chrome operating system today. And nothing is coming anytime soon: the final version is at least a year away, the mega giant web company said. But there was some significant news for the...
- Blog posts 2009-11-19
- ChromeOS says tear down this network regulation wall
- Costs"What is holding back network capacity is politics."What's holding back network capacity is huge costs.Yep, very important to push the ISPs to free up the bits. They would love to continue selling bandwidth through an eyedropper at very high prices. They need a push.Oh, and Microsoft will not like this...
- Discussion threads 2009-11-19
- Amazon slashes price of Palm Pre to $79.99, Pixi to $24.99
- I don't want ......ANY misleading bargain with a two or three year contract. Sell me the HW at a fair price and let me select the carrier and package of my choice.I am not an idiot. RE: Amazon slashes price of Palm Pre to $79.99, Pixi to $24.99When you limit...
- Discussion threads 2009-11-19
- 2010 Honda Fit Sport
- Photo gallery:2010 Honda Fit SportSince its introduction to the U.S. market in 2007, the Honda Fit has endeared itself to small car lovers with its economical engine and flexible interior. The car received an update for 2009, gaining size and an optional navigation system. Those updates came just in time,...
- Product reviews 2009-11-19
- Mini Inventory 6.1 (Mobile)
- A powerful, easy, and portable way to enter inventory and insurance data. Great for keeping personal property insurance records as well as inventory in a business. Records name, brand, date, time, quantity, value per item and total, model#, serial #, note, warranty period, seller/vendor, insured or note, location, and an...
- Software downloads 2009-11-19
- Salesforce Chatter: Social operating systems emerge on the IT stage
- The next big shift: Intranets, portals, and software suites that are the integrating force of the social fabric for our organizations. This morning's announcement here at Dreamforce today from Salesforce of Chatter, an enterprise-class realization of Facebook and Twitter, is further evidence of the industry's push for social Web capabilities...
- Blog posts 2009-11-18
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- New Online Dashboard for IT Leaders
-
Read about top issues IT decision-makers face every day, plus get cost-effective solutions to real-life IT problems.
- Learn more >>
- Reduce risk. Reduce complexity. Increase reliability.
-
A simplified IT environment isn't just less complex. It's also more reliable. Standardize on a single Linux platform with SUSE Linux Enterprise from Novell, and get the world's most interoperable Linux
- Learn more >>
- Save time with automated shipping solutions
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Visit the UPS Business Essentials Guide
- Microsoft Dynamics CRM Online - Free Six-Month Trial for Eligible Organizations
-
Microsoft Dynamics CRM Online provides fast online access, simple contact management and better sales performance for a low monthly cost - the best value on the market today.
- Learn more about the free, six-month trial offer>>
SmartPlanet
- Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
- More from IBM
-
- How to Drive Better Business Outcomes with Exceptional Web Experiences Download the eBook
- Driving Business Agility through SOA Connectivity & Integration Read the White Paper from IBM
- Linking Decisions and Information for Organizational Performance Read the Tom Davenport study
