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-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Does IT really need to fear multicore?
- While multicore chips hold great promise for applications and computing power they could wreak havoc on technology departments. That's the message from Gartner analyst Carl Claunch, who argued Thursday that IT types should fear--yes fear--multicore technology. Multicore chips carry multiple brains on them and companies like Intel...
- Blog posts 2008-10-15
- 80 ways to mix open source and business
- Open source and business do mix. In fact, according to Matthew Aslett at the 451 Group, you can mix open source into more than 80 combinations of development model, licensing model, and revenue schemes. Usually, people talk about three licensing combos: Proprietary, mixed, and "pure" open source...
- Blog posts 2008-10-15
- Gartner Top 10 embraces the Cloud
- As in previous years, the analysts at Gartner have unveiled their 'Top 10 Strategic Technologies,' and Jason Hiner provides details elsewhere on ZDNet. The press release is here. One of the analysts involved David Cearley discusses the Top 10 over on YouTube, and posts the information from...
- Blog posts 2008-10-15
- ManageFusion 2008
- I'm sitting in the media workroom preparing for today's sessions at Symantec's ManageFusion 2008. The event is being held at the JW Marriott resort and conference center in the land of the Mouse, that is Orlando, FL. I'll be adding things to this post throughout the day as interesting things...
- Blog posts 2008-10-15
- Photos: A look at HP's portable data center
- One of the more busy areas of the expo floor at the Gartner Symposium ITxpo this week was a walkthrough of HP's "Performance-Optimized Data Center." These portable data centers, also known as PODs, went on sale a little less than a month ago, according to HP representatives....
- Blog posts 2008-10-15
- Surviving the recession with Free Enterprise OSes (Part 2)
- In Part 1, I discussed the four Free Linux distributions that are best position to provide extended support and ample functionality to an end user through a protracted recession, as well as having the characteristic "safeness" or "stability" factor in terms of being able to weather...
- Blog posts 2008-10-14
- OLPC and Intel trumped by small-scale virtualization
- I had planned for my next post to be a followup to my interview with Sun's Joe Hartley, but it's going to have to take a back seat to a story about small-scale virtualization in the 1:1 computing market. Maybe, though, this particular story suggests that Sun is headed...
- Blog posts 2008-10-14
- New Wi-Fi chipsets promise up to 2x throughput of current 802.11n devices
- A couple of weeks ago I did a post on the Home Theater blog about Celeno Communications' wireless chip that the company claims can support four different HD streams simultaneously. Now another company has announced its own Wi-Fi technology that promises significant performance improvement over the 802.11n spec. Quantenna's QHS...
- Blog posts 2008-10-14
- Secunia: popular security suites failing to block exploits
- In a recently conducted comparative review, Danish security company Secunia, tested the detection rate of 12 different Internet Security Suites against 300 exploits (144 malicious files and 156 malicious web pages) affecting popular end user applications, to find that even the top performer in the test is in fact performing...
- Blog posts 2008-10-14
- Thoughts on Apple's new products
- Thoughts on Apple's new productsExcept the rest of the market didn't hold an event......announcing new products.The reasons to not buy anything always outweighthe reasons to buy.When you switch to a MacBook Air, you can't believe how you just don't care about what connectivity you don't have. With wi-fi everywhere...
- Discussion threads 2008-10-14
- New notebooks: What Apple didn't announce
- New notebooks: What Apple didn't announceWhile I don't completely disagree...[i]...Now why they couldn't keep the last-gen white MacBook and put an $800 price tag on it...[/i]They did keep the last-gen white MacBook... but only dropped the price $100, not $300.I admit to being confused about the 17" model myself, but...
- Discussion threads 2008-10-14
- More on Apple's new Mini DisplayPort
- More on Apple's new Mini DisplayPortDisplayPort is fine...but include the VGA port too so we don't have to carry around an extra cord....duh. It doesn't take up much space and EVERY windows laptop has a VGA port.30"!It's nice that it finally works with 30" even on MacBook (non-Pro).I just...
- Discussion threads 2008-10-14
- 'I'm a PC. A $999 MacBook still doesn't tempt me' (or does it?)
- 'I'm a PC. A $999 MacBook still doesn't tempt me' (or does it?)MS will have nothing exciting on the OS front for Christmas this year.If you want to do something exciting, you will have to buy a Mac. And, it only gets worse for MS on the MID/NetBook front. That...
- Discussion threads 2008-10-14
- New notebooks: What Apple didn't announce
- While Apple delivered a lot of new features in the new MacBooks today (glass trackpads, unibody contruction) and they also removed one – Firewire from the MacBook. There are some other key features that that were rumored to arrive in Apple's new notebooks that just didn't pan out. ...
- Blog posts 2008-10-14
- Details on Apple's MacBook and MacBook Pro updates
- After weeks of news leaks, there weren't many surprises left for Apple's event today, but the company gave its entire notebook line a badly-needed update. Major changes across the line included a stiffer, "unibody" aluminum case similar to the one used in the MacBook Air; LED-backlit displays; Nvidia graphics; faster...
- Blog posts 2008-10-14
- Apple's new MacBook line: Affordable enough?
- Apple's new MacBook line: Affordable enough?What are the specsI haven't seen the specs yet (are they published?) but I don't think it's going to be enough. They either need to compete with Windows PC's or not. Don't half ass it. My guess is the lower price will still not match...
- Discussion threads 2008-10-14
- Apple gadget lust for me, but anything for Ed Tech?
- Apple gadget lust for me, but anything for Ed Tech?Your Mac Lust borders on Creepy....Geez... that article is just a little bit scary. The kid on the eTrade commercials is in my head..."I seriously underestimated the creepiness factor"... he says this about a clown and I am applying it...
- Discussion threads 2008-10-14
- Apple gadget lust for me, but anything for Ed Tech?
- I have to get a new MacBook Pro. I need to find a way to convince my wife that one of my kids needs my MacBook and I must therefore have one of the latest MBPs introduced today. Because seriously, folks, if you haven't checked out coverage of...
- Blog posts 2008-10-14
- What OpenOffice site crash means
- What OpenOffice site crash meansSo, I should pay for free software so I don't pay Microsoft?It's not for everyone. However, the reason Microsoft has more robust features is because they spend more money on it. That money is funded by higher prices for their software. If you or your company...
- Discussion threads 2008-10-14
- Poll: Best personal finance software?
- Poll: Best personal finance software?MoneydanceMoneydance - moneydance.comSplashMoneyGreat little app originating for the Palm OS. Has been ported to Windows and iPhone worlds. I can keep track of my expenses on my iPhone and sync it via wireless connection with my desktop. Good tool set and it is a darn sight...
- Discussion threads 2008-10-14
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- See how Intel Xeon processors provide data traffic optimization
-
With key platform innovations built-in, the Intel Xeon processor 7400 series offers more headroom, reliability, and the highest expandability for large-scale server consolidation.
- Watch the Flash demo to learn about the Intel® Xeon® processor 7400 series >>
- Printers
- 'Green' Font Cuts Costs and Saves Trees (BNET)
- Three Ways to Save Paper (BNET)
- CNET Reviews printer buying guide (CNET)
- View all printers-tagged content on ZDNet
- Plan B from Brother
- It's the smarter way to work in color Our professional color ink-jet all-in-ones give you more choices, more features, and more value. Make the Smarter Choice. Learn More »
