Skip to main content

How to draw ER models

r-onlineinformation.blogspot.com 

How to draw ER models


ER Models can be drawn using any of several tools.   Among these Dia is a very convenient open source tool which runs on multiple platforms including Linux, Windows and MacOS.
Dia has a number of "sheets" each of which includes diagram objects for different modeling tools, such as UML, ER diagrams, flowcharts, etc.
The ER tool has objects for entities, relationships, attributes (using the oval notation), edges, and so on.  The properties boxes for each of these elements allows you to specify cardinality constraints, total participation, identifying relationship, etc.
To create the ER notation used in the Database System Concepts 6th Ed book, we use the UML class objects instead of ER entity objects in Dia.  Open the properties of the class object and give it a name (entity set name), and add attributes.  Select Visibility  Implementation to remove the + before the attribute name, and select Class Scope to underline an attribute.
Diagrams drawn using Dia can be embedded in other documents by exporting to other formats such as .eps (for Latex) or .jpg (for Word or Open/Libre Office), and including the exported format in the document.

reference: http://www.it.iitb.ac.in/moodle 

Comments

Post a Comment

Popular posts from this blog

Mobile Terms & Acronyms

"Wireless technology continues to evolve at a rapid pace and along with it so too does the language used by the wireless industry - which at times can leave even the most accomplished wireless practitioner confused or bemused" 1G The first generation of analogue mobile phone technologies including AMPS, TACS and NMT 2G The second generation of digital mobile phone technologies including GSM, CDMA IS-95 and D-AMPS IS-136 2.5G The enhancement of GSM which includes technologies such as GPRS 3G The third generation of mobile phone technologies covered by the ITU IMT-2000 family 3GPP The 3rd Generation Partnership Project, a grouping of international standards bodies, operators and vendors with the responsibility of standardising the WCDMA based members of the IMT-2000 family 3GPP2 The counterpart of 3GPP with responsibility for standardising the CDMA2000-based members of the IMT-2000 family. 3GPP2 is spearheaded by ANSI 8PSKOctantal Phase Shift Keying A5/1/2/3/8X Encryption algor...
2 comments
Read more

Create Custom ScreenTips for Shapes (MSOffice-word-2007)

r-onlineinformation.blogspot.com Create Custom ScreenTips for Shapes Shape ScreenTips in Microsoft Office Visio are the boxed text that appears when you point to a shape. Some Visio shapes have built-in ScreenTips—usually the name of the shape (such as the name of a workflow step). However, you can edit existing ScreenTip text or create new ScreenTip text for shapes that don’t have a built-in ScreenTip. To create or edit a ScreenTip: 1. Select the shape. 2. On the Insert menu, click either Shape ScreenTip or Edit Shape ScreenTip, as applicable. 3. In the Shape ScreenTip dialog box, type or edit the ScreenTip text. 4. Click OK.
1 comment
Read more