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

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

Tips for running queries on Oracle

r-onlineinformation.blogspot.com Tips for running queries on Oracle We encourage the use of PostgreSQL for the labs, to expose students to an excellent open source database.  However, if your syllabus forces you to use Oracle (and all participants at your remote centre are also from universities where they are forced to use Oracle), you can do assignments on Oracle.  Our model solutions will often give syntax errors on Oracle due to non-support for some SQL features in Oracle.  Below are some tips on how you can rewrite the queries to work on Oracle. Oracle SQL Tips: non-standard features, and limitations The following issues are for Oracle 10, and may or may not apply to later versions of Oracle. Oracle does not support the  as  clause, except as part of the "with" statement. In all other cases, just use the same syntax without the "as" keyword, and things should work. To use a single quote in a string, use two consecutive single qu...
Post a Comment
Read more

Some tips in creating a strong password

r-onlineinformation.blogspot.com * Avoid using any words that you can look up in a dictionary. These include common misspellings of words. * If you follow good security practices and try to change your password every say 6 months, do not just increment a digit or the digit in your current password * Avoid creating a password that begins or ends with a number because they can be easily guessed that passwords which have a number in the middle. * Avoid creating a password which someone can easily guess by knowing a little bit about you. This includes names of pets or family members or sports teams. * Avoid creating a password which includes words for popular culture. * Always create a password that requires the usage of both hands on the keyboard. Why is this important? So someone who may be looking over your shoulder don't need to worry about just looking on one side of the keyboard. Again much easier to guess. * Always have a password that uses uppercase and lowercase letters, has n...
Post a Comment
Read more