Utility for Table Schemas

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Neil

    Utility for Table Schemas

    Anyone have a recommendation for a good inexpensive or free utility for
    developing table schemas.


  • Allen Browne

    #2
    Re: Utility for Table Schemas

    A utility to develop table schemas?

    If ou are looking for suggestions on how to design schemas for a variety of
    needs, this might be useful:


    In general, though, you only go go the trouble of creating a custom database
    if there is no off-the-shelf solution. Therefore the bespoke Access
    databases you create all have unique needs, and cannot be designed by a
    utility.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Neil" <nospam@nospam. netwrote in message
    news:4ju2h.1629 $l25.515@newsre ad4.news.pas.ea rthlink.net...
    Anyone have a recommendation for a good inexpensive or free utility for
    developing table schemas.

    Comment

    • susiedba@hotmail.com

      #3
      Re: Utility for Table Schemas

      what do you want to do.. print schemas?
      export schemas to word?

      I would reccomend keeping an eye on www.gliffy.com it is a free online
      visio-killer


      Neil wrote:
      Anyone have a recommendation for a good inexpensive or free utility for
      developing table schemas.

      Comment

      • David F Cox

        #4
        Re: Utility for Table Schemas

        When I have seen questions concerning complex logic on newsgroups I have
        wished for a sketchpad where I could draw a flowchart. Other times I have
        longed to be able to share a relationship diagram. This looks like a
        possible answer. I would like to hear more expert views on this.

        <susiedba@hotma il.comwrote in message
        news:1162516728 .249225.47180@i 42g2000cwa.goog legroups.com...
        what do you want to do.. print schemas?
        export schemas to word?
        >
        I would reccomend keeping an eye on www.gliffy.com it is a free online
        visio-killer
        >
        >
        Neil wrote:
        >Anyone have a recommendation for a good inexpensive or free utility for
        >developing table schemas.
        >
        >

        Comment

        • Keith Wilby

          #5
          Re: Utility for Table Schemas

          "David F Cox" <nospam@please. comwrote in message
          news:%23Xpguzy$ GHA.4212@TK2MSF TNGP02.phx.gbl. ..
          When I have seen questions concerning complex logic on newsgroups I have
          wished for a sketchpad where I could draw a flowchart. Other times I have
          longed to be able to share a relationship diagram. This looks like a
          possible answer. I would like to hear more expert views on this.
          >
          How would that be displayed in a non HTML reader like OE? I think I'd be
          tempted to upload my sketch to a web space and provide a link to it.

          Regards,
          Keith.



          Comment

          • Lyle Fairfield

            #6
            Re: Utility for Table Schemas

            Keith Wilby wrote:
            How would that be displayed in a non HTML reader like OE?
            Outlook Express is a non-HTML reader?

            Comment

            • Neil

              #7
              Re: Utility for Table Schemas

              I meant just a tool for playing with table designs and providing a graphical
              interface/printing utility, not one that would do the designing work for me.
              I want to be able to design the tables manually, set up relationships, and
              print the schemas, without creating the tables, and then create the tables
              once I'm done with all the design work. Seems that such a utility exists.


              "Allen Browne" <AllenBrowne@Se eSig.Invalidwro te in message
              news:O49hbGu$GH A.4328@TK2MSFTN GP03.phx.gbl...
              >A utility to develop table schemas?
              >
              If ou are looking for suggestions on how to design schemas for a variety
              of needs, this might be useful:

              >
              In general, though, you only go go the trouble of creating a custom
              database if there is no off-the-shelf solution. Therefore the bespoke
              Access databases you create all have unique needs, and cannot be designed
              by a utility.
              >
              --
              Allen Browne - Microsoft MVP. Perth, Western Australia.
              Tips for Access users - http://allenbrowne.com/tips.html
              Reply to group, rather than allenbrowne at mvps dot org.
              >
              "Neil" <nospam@nospam. netwrote in message
              news:4ju2h.1629 $l25.515@newsre ad4.news.pas.ea rthlink.net...
              >Anyone have a recommendation for a good inexpensive or free utility for
              >developing table schemas.
              >
              >

              Comment

              • Tim Marshall

                #8
                Re: Utility for Table Schemas

                Neil wrote:
                I meant just a tool for playing with table designs and providing a graphical
                interface/printing utility, not one that would do the designing work for me.
                I want to be able to design the tables manually, set up relationships, and
                print the schemas, without creating the tables, and then create the tables
                once I'm done with all the design work. Seems that such a utility exists.
                Might be, but I find small yellow stickies (post it notes) work great
                when conceptualizing a design. It's certainly possible I'm in the dark
                ages, though.
                --
                Tim http://www.ucs.mun.ca/~tmarshal/
                ^o<
                /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
                /^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

                Comment

                • Keith Wilby

                  #9
                  Re: Utility for Table Schemas

                  "Lyle Fairfield" <lylefairfield@ aim.comwrote in message
                  news:1162556128 .136398.114690@ b28g2000cwb.goo glegroups.com.. .
                  Keith Wilby wrote:
                  >
                  >How would that be displayed in a non HTML reader like OE?
                  >
                  Outlook Express is a non-HTML reader?
                  >
                  OK fair enough, but it's generally "accepted" practice to post in plain text
                  isn't it?


                  Comment

                  • David F Cox

                    #10
                    Re: Utility for Table Schemas

                    I believe Microsoft's Visio might do what you want.

                    "Tim Marshall" <TIMMY!@PurpleP andaChasers.Moe rtheriumwrote in message
                    news:eimp8a$tjr $1@coranto.ucs. mun.ca...
                    Neil wrote:
                    >I meant just a tool for playing with table designs and providing a
                    >graphical interface/printing utility, not one that would do the designing
                    >work for me. I want to be able to design the tables manually, set up
                    >relationship s, and print the schemas, without creating the tables, and
                    >then create the tables once I'm done with all the design work. Seems that
                    >such a utility exists.
                    >
                    Might be, but I find small yellow stickies (post it notes) work great when
                    conceptualizing a design. It's certainly possible I'm in the dark ages,
                    though.
                    --
                    Tim http://www.ucs.mun.ca/~tmarshal/
                    ^o<
                    /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
                    /^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
                    >

                    Comment

                    • Karl

                      #11
                      Re: Utility for Table Schemas

                      You can do this in Excel.

                      "Neil" <nospam@nospam. netwrote in message
                      news:MBz3h.3493 $ig4.705@newsre ad2.news.pas.ea rthlink.net...
                      >I meant just a tool for playing with table designs and providing a
                      >graphical interface/printing utility, not one that would do the designing
                      >work for me. I want to be able to design the tables manually, set up
                      >relationship s, and print the schemas, without creating the tables, and then
                      >create the tables once I'm done with all the design work. Seems that such a
                      >utility exists.
                      >
                      >
                      "Allen Browne" <AllenBrowne@Se eSig.Invalidwro te in message
                      news:O49hbGu$GH A.4328@TK2MSFTN GP03.phx.gbl...
                      >>A utility to develop table schemas?
                      >>
                      >If ou are looking for suggestions on how to design schemas for a variety
                      >of needs, this might be useful:
                      > http://www.databaseanswers.com/data_models/index.htm
                      >>
                      >In general, though, you only go go the trouble of creating a custom
                      >database if there is no off-the-shelf solution. Therefore the bespoke
                      >Access databases you create all have unique needs, and cannot be designed
                      >by a utility.
                      >>
                      >--
                      >Allen Browne - Microsoft MVP. Perth, Western Australia.
                      >Tips for Access users - http://allenbrowne.com/tips.html
                      >Reply to group, rather than allenbrowne at mvps dot org.
                      >>
                      >"Neil" <nospam@nospam. netwrote in message
                      >news:4ju2h.162 9$l25.515@newsr ead4.news.pas.e arthlink.net...
                      >>Anyone have a recommendation for a good inexpensive or free utility for
                      >>developing table schemas.
                      >>
                      >>
                      >
                      >

                      Comment

                      • Neil

                        #12
                        Re: Utility for Table Schemas

                        Yes, I can list tables and fields in Excel; but I'd like to visually
                        display table relationships and joins. Surely there must be a tool out there
                        that does this.

                        "Karl" <someone@sbcglo bal.bizwrote in message
                        news:nMJ3h.6245 $B31.5258@newss vr27.news.prodi gy.net...
                        You can do this in Excel.
                        >
                        "Neil" <nospam@nospam. netwrote in message
                        news:MBz3h.3493 $ig4.705@newsre ad2.news.pas.ea rthlink.net...
                        >>I meant just a tool for playing with table designs and providing a
                        >>graphical interface/printing utility, not one that would do the designing
                        >>work for me. I want to be able to design the tables manually, set up
                        >>relationships , and print the schemas, without creating the tables, and
                        >>then create the tables once I'm done with all the design work. Seems that
                        >>such a utility exists.
                        >>
                        >>
                        >"Allen Browne" <AllenBrowne@Se eSig.Invalidwro te in message
                        >news:O49hbGu$G HA.4328@TK2MSFT NGP03.phx.gbl.. .
                        >>>A utility to develop table schemas?
                        >>>
                        >>If ou are looking for suggestions on how to design schemas for a variety
                        >>of needs, this might be useful:
                        >> http://www.databaseanswers.com/data_models/index.htm
                        >>>
                        >>In general, though, you only go go the trouble of creating a custom
                        >>database if there is no off-the-shelf solution. Therefore the bespoke
                        >>Access databases you create all have unique needs, and cannot be
                        >>designed by a utility.
                        >>>
                        >>--
                        >>Allen Browne - Microsoft MVP. Perth, Western Australia.
                        >>Tips for Access users - http://allenbrowne.com/tips.html
                        >>Reply to group, rather than allenbrowne at mvps dot org.
                        >>>
                        >>"Neil" <nospam@nospam. netwrote in message
                        >>news:4ju2h.16 29$l25.515@news read4.news.pas. earthlink.net.. .
                        >>>Anyone have a recommendation for a good inexpensive or free utility for
                        >>>developing table schemas.
                        >>>
                        >>>
                        >>
                        >>
                        >
                        >

                        Comment

                        • Neil

                          #13
                          Re: Utility for Table Schemas

                          With me, if it's not on my PC, it gets lost. The only way I find mail is by
                          knowing which part of the floor it was left on.... My computer files, on the
                          other hand, are very organized. :-)

                          "Tim Marshall" <TIMMY!@PurpleP andaChasers.Moe rtheriumwrote in message
                          news:eimp8a$tjr $1@coranto.ucs. mun.ca...
                          Neil wrote:
                          >I meant just a tool for playing with table designs and providing a
                          >graphical interface/printing utility, not one that would do the designing
                          >work for me. I want to be able to design the tables manually, set up
                          >relationship s, and print the schemas, without creating the tables, and
                          >then create the tables once I'm done with all the design work. Seems that
                          >such a utility exists.
                          >
                          Might be, but I find small yellow stickies (post it notes) work great when
                          conceptualizing a design. It's certainly possible I'm in the dark ages,
                          though.
                          --
                          Tim http://www.ucs.mun.ca/~tmarshal/
                          ^o<
                          /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
                          /^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

                          Comment

                          • Neil

                            #14
                            Re: Utility for Table Schemas

                            Could be; but I was hoping for some free or inexpensive tool for doing
                            this -- doesn't have to be fancy.

                            You know, it's interesting: I was expecting lots of replies saying, "I use
                            this," or "I use that." But that hasn't been the case. So what do most
                            people do, just design with pencil and paper or just Word or Excel? Or just
                            go straight to table design?


                            "David F Cox" <nospam@please. comwrote in message
                            news:%23mP1AHZA HHA.4496@TK2MSF TNGP02.phx.gbl. ..
                            >I believe Microsoft's Visio might do what you want.
                            >
                            "Tim Marshall" <TIMMY!@PurpleP andaChasers.Moe rtheriumwrote in message
                            news:eimp8a$tjr $1@coranto.ucs. mun.ca...
                            >Neil wrote:
                            >>I meant just a tool for playing with table designs and providing a
                            >>graphical interface/printing utility, not one that would do the
                            >>designing work for me. I want to be able to design the tables manually,
                            >>set up relationships, and print the schemas, without creating the
                            >>tables, and then create the tables once I'm done with all the design
                            >>work. Seems that such a utility exists.
                            >>
                            >Might be, but I find small yellow stickies (post it notes) work great
                            >when conceptualizing a design. It's certainly possible I'm in the dark
                            >ages, though.
                            >--
                            >Tim http://www.ucs.mun.ca/~tmarshal/
                            >^o<
                            >/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
                            >/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
                            >>
                            >
                            >

                            Comment

                            • Michael Gramelspacher

                              #15
                              Re: Utility for Table Schemas

                              In article <xUO3h.3032$l25 .2949
                              @newsread4.news .pas.earthlink. net>, nospam@nospam.n et says...
                              Could be; but I was hoping for some free or inexpensive tool for doing
                              this -- doesn't have to be fancy.
                              >
                              You know, it's interesting: I was expecting lots of replies saying, "I use
                              this," or "I use that." But that hasn't been the case. So what do most
                              people do, just design with pencil and paper or just Word or Excel? Or just
                              go straight to table design?
                              >
                              I was also expecting to see lots of replies.
                              This is the only thing I have encountered that is free.
                              (Assuming it can still be downloaded.)

                              it is really for use with Mysql.

                              I have also seen this recommended, but the cheapest version is
                              $229. http://www.datanamic.com/

                              There are many others and most are expensive.

                              Comment

                              Working...