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
- 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
- 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
- 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
- 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
- Salesforce Chatter: Facebook for the Enterprise
- Salesforce is announcing today a Salesforce Chatter, an enteprise collaboration application akin to Facebook. The move puts SalesForce in competition with offerings from other providers, including IBM Lotus. Here's what's being delivered. Features: Profiles: Just like profiles on popular consumer-oriented social networking sites, Salesforce Chatter profiles include...
- Blog posts 2009-11-18
- MySQL Workbench OSS 5.2.8b1 (Mac)
- MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation...
- Software downloads 2009-11-18
- ORM Designer 1.1.10.243 (Windows)
- ORM Designer is a visual database designing tool with full support of ORM frameworks. ORM Designer was created to replace kilobytes of text definitions with easy-to-use graphical interface. Thanks to a very flexible design almost any ORM framework with definitions stored in a markup language can be fully supported. Enjoy...
- Software downloads 2009-11-18
- Next year is THE year for cloud computing
- Not if SunGard is involvedIf the "cloud" runs out of SunGard data centers, I wouldn't rely on it for much...Next year is THE year cloud computing diesNext year might be the year that companies realize cloud computing is a step backward to the dinosaur days of computing. Next year might...
- Discussion threads 2009-11-17
- HP Pavilion Elite owner resorts to lawsuit over 'inherently defective' PC
- My HP Pavilion Elite... / HP quality controlMy HP Pavilion Elite came with an obviously defective, and defectively designed, video card. After about eight months, the video card model was finally recalled.My previous HP desktop computer went for about five years without a problem.HP's quality control is clearly going down...
- Discussion threads 2009-11-17
- FindGraph 2.13 (Windows)
- FindGraph is a graphing, curve fitting, and digitizing tool. The program offers 10 generic fits, including linear regression, logistic functions, rationals, Fourier approximation, neural networks, plus a library of over 300 industry-specific 2D formulas. Built-in Wizard helps applying different curve fits to discover the model that describes data the best....
- Software downloads 2009-11-17
- AidScans 4.3 (Windows)
- Volume estimation application. The program takes set of object slices provided by a scanner. The software is used for medical imaging purposes, especially for brain tumors obtained from MRI and CT scanners volume calculations. The program is usable for breast, chest, liver and another organs tumor calculations as well as...
- Software downloads 2009-11-17
- Altova StyleVision Professional Edition 2010 (Windows)
- Altova StyleVision 2010 Professional Edition is a powerful visual XSLT stylesheet designer for graphically designing templates that render eye-catching HTML and RTF output from XML or database data and create intuitive Authentic electronic forms. StyleVision is fully standards-compliant and supports XSLT 1.0, XSLT 2.0, CSS, JavaScript, and all major databases....
- Software downloads 2009-11-17
- Altova MissionKit for Professional XML Developers 2010 (Windows)
- The Altova MissionKit for Professional XML Developers is an integrated suite of XML development and data integration tools from the makers of XMLSpy. Get three leading XML products for less than the price of two! The MissionKit for Professional XML Developers includes Professional Editions of Altova XMLSpy, MapForce, and StyleVision...
- Software downloads 2009-11-17
- Altova XMLSpy Professional Edition 2010 (Windows)
- Altova XMLSpy 2010 Professional Edition is the industry-leading XML editor and XML development environment, with intuitive editing views and powerful XML utilities to model, edit, transform, and debug XML-related technologies quickly and easily. In addition to the world's most popular XML editor, XMLSpy Professional includes a graphical XML Schema editor...
- Software downloads 2009-11-16
- Altova StyleVision Enterprise Edition 2010 (Windows)
- Altova StyleVision 2010 Enterprise Edition is a powerful visual stylesheet designer for transforming XML, XBRL, and database data into HTML, RTF, PDF, and OOXML/Word 2007 output, and creating e-Forms. It is standards-compliant and supports XSLT 1.0, XSLT 2.0, XSL:FO, CSS, JavaScript, and all major databases. StyleVision is optimized for single...
- Software downloads 2009-11-16
- Alienware M15x (Intel Core i7 720QM, 250GB HDD, 3GB)
- Keeping the same revised look and feel as the recent 17-inch M17x version, the Alienware M15x is an imposing black slab of computing power that's thicker and heavier than most 17-inch laptops. We love having high-end options such as Intel's uberpowerful Core i7-920XM CPU, and it's a plus that...
- Product reviews 2009-11-13
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- The more you simplify, the more you save
-
When you transition from your existing Red Hat environment to SUSE Linux Enterprise from Novell, you can recognize dramatic cost savings, perhaps as much 50%
- 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
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
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
