Post reply

How to create ER diagram?

  • June 9, 2009 at 7:12 am

    #201249

    How to create ER diagram? Thank you

  • June 9, 2009 at 7:39 am

    #1006680

    Hello,

    Can you be a bit specific?

    Thanks

  • June 9, 2009 at 7:42 am

    #1006681

    Well, I was ask if I ever worked with ER diagrams, I am trying to find out more info about it

  • June 9, 2009 at 8:07 am

    #1006706

    Hello,

    Still your requirement is not clear.

    ER Diagrams can be created using different tools (either native clients, third party components) so kindly elaborate what you are trying to ask.

    Use private message pole (PM) underneath if you require any information more in detail.

    Thanks

  • June 9, 2009 at 8:12 am

    #1006710

    I want to know everything, what is ER diagram, can you create it in SQL Server?

  • June 9, 2009 at 8:18 am

    #1006716

    A simple google search may get you the information you want or at least the information to form a specific question.

    http://www.google.ca/search?q=er+diagram&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • June 9, 2009 at 8:21 am

    #1006719

    Krasavita (6/9/2009)

    I want to know everything, what is ER diagram, can you create it in SQL Server?

    An ER Diagram is a Entity-Relationship Diagram. There is no way we can tell you every there is on this in this forum. There are many books written on the subject.

    Let me help you with Google.

    From there, you may want to check out a book store or even a public library.

  • June 9, 2009 at 8:33 am

    #1006731

    What tools can I use?

  • June 9, 2009 at 8:38 am

    #1006735

    Krasavita (6/9/2009)

    What tools can I use?

    Really? Here, let me Google that for you also.

  • June 9, 2009 at 9:06 am

    #1006762

    You're not getting any simple answers because "ER Diagram" is a vague term. For some people, the Database Diagram feature in Management Studio meets their requirements for ER diagrams. Other places require more detailed diagramming and modelling capabilities. Visio is probably the next step up, its widely available since it was made part of Microsoft Office. Then there are very expensive tools such as ERwin.

    SSMS Database Diagrams are easy to use but have limited features and only produce one style of diagram. The more powerful tools have more features, but have so many options you won't know where to start.

    Questions like "What ER modelling tools support doing ____?", or "How do I do ____ in tool ____?" would get answers here, but "Tell me everything about ER Diagrams" requires a book-length answer. That's why everyone is telling you to learn something from Google or Wikipedia or some other resource first, then feel free to come back here with more specific questions.

  • June 9, 2009 at 9:11 am

    #1006768

    Thank you

  • June 9, 2009 at 10:51 am

    #1006874

    Here are a few books recommended on database design. The diagrams will be listed in there: http://thomaslarock.com/book-reviews/

    A few tools I have used:

    - Management Studio/Enterprise Manager with Database Diagrams

    - ER/Studio (Embarcadero)

    - ER/Win (CA)

    - Visio

  • June 9, 2009 at 10:57 am

    #1006884

    Steve Jones - Editor (6/9/2009)

    Here are a few books recommended on database design. The diagrams will be listed in there: http://thomaslarock.com/book-reviews/

    A few tools I have used:

    - Management Studio/Enterprise Manager with Database Diagrams

    - ER/Studio (Embarcadero)

    - ER/Win (CA)

    - Visio

    I have used both ER/win and Visio and I found Visio a bit buggy: you may find yourself with a corrupt file when working with big er schemas.

    I would suggest ER/win, because in my experience is more stable.

    -- Gianluca Sartori

  • June 9, 2009 at 11:05 am

    #1006893

    Gianluca Sartori (6/9/2009)

    Steve Jones - Editor (6/9/2009)

    Here are a few books recommended on database design. The diagrams will be listed in there: http://thomaslarock.com/book-reviews/

    A few tools I have used:

    - Management Studio/Enterprise Manager with Database Diagrams

    - ER/Studio (Embarcadero)

    - ER/Win (CA)

    - Visio

    I have used both ER/win and Visio and I found Visio a bit buggy: you may find yourself with a corrupt file when working with big er schemas.

    I would suggest ER/win, because in my experience is more stable.

    Another issue with Visio is that you cannot create/modify a/the database from the diagram. It is strictly a one way tool.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • June 9, 2009 at 11:05 pm

    #1007189

    Hello,

    There are plenty of tools and Books which can support your broad question.

    The Tools that I am experienced was.

    ER Win

    Power Designer (Sybase)

    Visio

    On top of all of this, ERWIN is costly but the perfect match for Database Diagram based on the necessity/requirement.

    I will provide you the link were in I posted some questions and found some interesting answers earlier.

    http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&gid=1435647&discussionID=765395&sik=1244610159076&trk=ug_qa_q&goback=%2Eana_1435647_1244610159076_3_1

    Disadvantages:

    No Metadata script

    No Data Structure validation

    No Data type validation check

    Lot of Effort or Rework required

    SQL SERVER 2005 dependent

    Manual typinng of Data types

    I am looking at a tool which can help me in these:

    Automatic Metadata Generation or DDL script creation

    Validating Data structures when creating FK for PK

    Data type validation when creating FK for PK

    Check Connstrints creation

    Business Rules can be created and outputed as a document

    Quality Rules can be created and outputed as a document.

    I don't know if you have access to this link or not, do let me know if you require any more information.

    Thanks

    Chandu

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply