Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Design A Database Using an Entity-Relationship Diagram Expand / Collapse
Author
Message
Posted Wednesday, October 15, 2003 12:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, July 14, 2013 8:09 AM
Points: 88, Visits: 66
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rgummadi/designadatabaseusinganentityrelationshipdiagram.asp


Ramesh Gummadi
Post #17324
Posted Tuesday, October 28, 2003 7:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 14, 2005 7:06 AM
Points: 1, Visits: 1
Is there a decent (and inexpensive) ER tool that produces both the database and classes?




Post #83550
Posted Tuesday, October 28, 2003 7:51 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, July 14, 2013 8:09 AM
Points: 88, Visits: 66
Sorry I do not know as of now. Will let u know if I come across anything. Rational Rose is a pretty good tools for design. I do not know how expensive it is.

Ramesh Gummadi



Ramesh Gummadi
Post #83551
Posted Tuesday, October 28, 2003 9:44 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:45 AM
Points: 4,064, Visits: 5,328
Check Visible Analyst from Visible Systems.

http://www.visible.com/



Greg
Post #83552
Posted Thursday, October 28, 2004 7:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 8:17 AM
Points: 297, Visits: 335
Nice Article.  I give it 5 stars.  It's obviously not "in-depth" - but not all articles need to be geared for experts.  I like it because it's well written and easy to follow.  I can refer my customers to this article and they will understand the basics of relational database design - many for the first time!


Student of SQL and Golf, Master of Neither
Post #143863
Posted Thursday, October 28, 2004 9:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 4, 2012 7:39 AM
Points: 20, Visits: 31

One of the best tools out there, regardless of cost, is EasyCASE from Evergreen CASE Tools

Evergreen CASE Tools:
EasyCASE (shareware); EasyCASE plus (commercial)
  • 11025 164th Ave NE; Redmond WA 98052; 206-881-5149
  • I've used many different tools in the course of my 22 years in this industry, and EasyCASE is not only simple to use and extremely powerful, it is also remarkably inexpensive.  IEW/ADW from Knowledgeware are great, too, but too pricey for the individual developer; and Texas Instruments' IEF is the pinnacle of whole-system development tools, but it is prohibitively expensive for all but the largest of corporate IT budgets.

    Overall, EasyCASE is the hands-down winner in terms of price/performance when it comes to data-modeling tools.



    Kindest Regards,

    Matt Gauch

    Post #143888
    Posted Monday, November 1, 2004 7:53 AM
    Forum Newbie

    Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

    Group: General Forum Members
    Last Login: Monday, March 19, 2007 6:27 PM
    Points: 7, Visits: 1

    This article is excellent at describing the basics of ER modelling and it only takes 10 minutes to read! 

    I'm very happy to see it because it accurately represents my view of ER modelling.  Recently I have witnessed what other developers have called ER diagrams but in my view are simply just table diagrams.  Obviously this had led to much confusion and "heated" discussions!

    True there are other methods of modelling data - but can they really be called an ER diagram?  Shouldn't the term ER be specific to the diagram notation described in this article?

    Post #144126
    Posted Thursday, August 28, 2008 2:36 PM
    Forum Newbie

    Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

    Group: General Forum Members
    Last Login: Thursday, August 28, 2008 2:34 PM
    Points: 1, Visits: 0
    CAN YOU WRITE SOME SQL QUIRIES FOR THE UNIVERSITY ER DIAGRAM
    Post #560828
    Posted Thursday, June 24, 2010 8:53 AM
    Forum Newbie

    Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

    Group: General Forum Members
    Last Login: Tuesday, June 3, 2014 2:47 PM
    Points: 1, Visits: 61
    Can you/ How do you design a database diagram in Visual Studio 2010?

    Any help with this is appreciated.

    THANKS
    cgSQL
    Post #942506
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse