Quantcast

Maximum PC

It is currently Mon Dec 22, 2014 1:31 am

All times are UTC - 8 hours




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: modeling app to plan out databases
PostPosted: Mon Jan 24, 2011 9:00 pm 
Willamette
Willamette

Joined: Tue Feb 01, 2005 12:17 pm
Posts: 1495
Does anyone know of a software program that you can use to visually plan out relational databases?

What I want to be able to do is visually draw out the tables and show the relationships between the tables and fields in various tables (ie. primary keys, foreign keys, etc).

The program DOES NOT have to write an code, just let me visually design the database (so I don't have to waste paper doing it by hand, for if I make mistakes or changes). The database I'm designing is pretty small (maybe 15-20 tables or less, and each table has an average number of fields of around maybe 5 to 10 fields per each table). By no means is this project an Enterprise-level design.

Suggestions? I would prefer free (or as close to it as possible--no more than $50 cost). Just simply because I don't want to drop a lot of money into a program that I may only use once or twice, and never use again (or not that often).


Top
  Profile  
 
 Post subject: Re: modeling app to plan out databases
PostPosted: Mon Jan 24, 2011 9:41 pm 
Million Club - 5 Plus*
Million Club - 5 Plus*
User avatar

Joined: Sun Sep 12, 2004 6:37 pm
Posts: 4745
Location: In the monkey's litterbox
I've used MySQL workbench a few times.


Top
  Profile  
 
 Post subject: Re: modeling app to plan out databases
PostPosted: Tue Jan 25, 2011 4:46 am 
SON OF A GUN
SON OF A GUN
User avatar

Joined: Mon Nov 01, 2004 5:41 am
Posts: 11605
I use Visio a lot.

I think the Architect / Pro versions have a way to "reverse" engineer a database, so you can use that as a starting point. Then when you are done making changes you can suck them in. I am sure there are other tools but I haven't used them. I usually just use paper actually.


Top
  Profile  
 
 Post subject: Re: modeling app to plan out databases
PostPosted: Wed Jan 26, 2011 9:24 am 
Bitchin' Fast 3D Z8000
Bitchin' Fast 3D Z8000
User avatar

Joined: Mon Jun 14, 2004 4:04 pm
Posts: 987
Location: Earth
CrashTECH wrote:
I usually just use paper actually.


My favorite tool: available anywhere, usually free or you can bum off of someone and is subject to multiple revisions.


Top
  Profile  
 
 Post subject: Re: modeling app to plan out databases
PostPosted: Wed Jan 26, 2011 3:05 pm 
SON OF A GUN
SON OF A GUN
User avatar

Joined: Mon Nov 01, 2004 5:41 am
Posts: 11605
I re-use print outs. I have a stash under my monitor that I whip out and draw on the other side, then drop in the recycle bin at my desk.


Top
  Profile  
 
 Post subject: Re: modeling app to plan out databases
PostPosted: Thu Jan 27, 2011 9:14 am 
Bitchin' Fast 3D Z8000
Bitchin' Fast 3D Z8000
User avatar

Joined: Mon Jun 14, 2004 4:04 pm
Posts: 987
Location: Earth
CrashTECH wrote:
I re-use print outs. I have a stash under my monitor that I whip out and draw on the other side, then drop in the recycle bin at my desk.


I'm obsessed with notebooks and pens. I'd love to use recycled paper but when I jot something down, I like to refer to it in later time. Also, a lot of our "scrap" paper at work contain some kind of info on it - and considering HIPAA, I'd like to stay away from either a large fine or jail time, so I use new paper.


Top
  Profile  
 
 Post subject: Re: modeling app to plan out databases
PostPosted: Sun Jan 30, 2011 12:21 am 
Northwood
Northwood
User avatar

Joined: Sun Jul 15, 2007 6:37 pm
Posts: 2261
Location: No. 1 Thread Killer
Old dot matrix printers. Best paper ever for this kind of thing.


Top
  Profile  
 
 Post subject: Re: modeling app to plan out databases
PostPosted: Mon Jan 31, 2011 5:14 am 
SON OF A GUN
SON OF A GUN
User avatar

Joined: Mon Nov 01, 2004 5:41 am
Posts: 11605
Dwood15 wrote:
Old dot matrix printers. Best paper ever for this kind of thing.
How so? I see that being a colossal pain in the dick...


Top
  Profile  
 
 Post subject: Re: modeling app to plan out databases
PostPosted: Mon Jan 31, 2011 5:41 am 
7yrs+11,000 Posts
7yrs+11,000 Posts
User avatar

Joined: Tue Jul 27, 2004 5:44 pm
Posts: 11242
Location: The kitten above is not on fire.
CrashTECH wrote:
Dwood15 wrote:
Old dot matrix printers. Best paper ever for this kind of thing.
How so? I see that being a colossal pain in the dick...

I'm assuming the rational is that its all connected in one long ribbon. But I also see it being a colossal pain in the dick. That's what whiteboards are for.


Top
  Profile  
 
 Post subject: Re: modeling app to plan out databases
PostPosted: Mon Jan 31, 2011 6:20 am 
Bitchin' Fast 3D Z8000
Bitchin' Fast 3D Z8000
User avatar

Joined: Mon Jun 14, 2004 4:04 pm
Posts: 987
Location: Earth
gamerfreak wrote:
I'm assuming the rational is that its all connected in one long ribbon. But I also see it being a colossal pain in the dick. That's what whiteboards are for.


I like the fact that it was connected via perforation. Made it easy to have one, long sheet instead of having to tape multiple sheets together. White boards are great, but I find myself constantly erasing stuff. Whiteboards generally don't suit my progression of thinking, so I find myself turning to paper.


Top
  Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

© 2014 Future US, Inc. All rights reserved.