Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4
This is the forum to discuss the Wrox book Beginning Database Design Solutions by Rod Stephens; ISBN: 9780470385494
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old June 3rd, 2012, 12:25 PM
Registered User
Points: 12, Level: 1
Points: 12, Level: 1 Points: 12, Level: 1 Points: 12, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default Drawing Tool

Database Design Solutions uses drawing of semantic object models to design databases. It is very effective but you need a drawing tool to make it really good.
Does anyone know of a simple one that I can use. I have tried MS word starter, Google doc, MS excel starter but they all suffer from the same defect. If you have and object which contains another object as an attribute, when you move the “parent” or containing object to somewhere else on the page the child object stays behind and does not move.
I would like to use a tool instead of pencil and paper as it’s neater and much easier to clean up and alter the drawing.
Reply With Quote
  #2 (permalink)  
Old June 3rd, 2012, 01:21 PM
Rod Stephens's Avatar
Wrox Author
Points: 3,145, Level: 23
Points: 3,145, Level: 23 Points: 3,145, Level: 23 Points: 3,145, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2006
Location: , , .
Posts: 641
Thanks: 2
Thanked 96 Times in 95 Posts
Default

I agree that a good tool would help a lot. Unfortunately I haven't used any tools that I really like. Visual Studio and SQL Server have tools that show database designs and they're not too bad. Every tool will impose its particular symbology on you, though. For example, they may use heavy lines, dashed lines, double lines, etc. to represent different relationships.

For the book, I drew rough drafts on paper and then used Word's drawing tools to make the final drawing. (You could use other drawing tools such as CorelDRAW!) The drawing is just a picture with no real semantic meaning but at least I get a lot of control over the result.

I'd be interested to hear what other people like to use.
__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

(Please post reviews at Amazon or wherever you shop!)
Reply With Quote
The Following User Says Thank You to Rod Stephens For This Useful Post:
Jimpat (June 3rd, 2012)
  #3 (permalink)  
Old June 3rd, 2012, 02:01 PM
Registered User
Points: 12, Level: 1
Points: 12, Level: 1 Points: 12, Level: 1 Points: 12, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default Drawing Tool

Thank you for your reply. I will look at both Visual Studio and SQL Server and any other suggestions that may be made. At this stage it looks like being quite literally "back to the drawing board".
Reply With Quote
  #4 (permalink)  
Old July 14th, 2012, 09:35 AM
Registered User
Points: 22, Level: 1
Points: 22, Level: 1 Points: 22, Level: 1 Points: 22, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default errata

Dear Mr.Stephens
I just finished your fantastic book (database design solutions) . I found some simple errors but I'm not sure in order send it to errata page , such as the first line -page 230

error : You let Charlie and Alicia brainstorm
correct : You let Charlie and Sveta brainstorm
Reply With Quote
  #5 (permalink)  
Old July 21st, 2012, 09:51 AM
Authorized User
Points: 143, Level: 2
Points: 143, Level: 2 Points: 143, Level: 2 Points: 143, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2012
Posts: 32
Thanks: 9
Thanked 0 Times in 0 Posts
Default Not sure if it helps... but I can let you know what I am using

I think the best tool to draw diagrams is a pen and paper.

This being said, I tried a few tools an I was not satisfied with any of them. In the end I found a software called 'DiagramDesigner' (if you Google it like this you will find it) that is free and allowed me to create my own set of diagram objects maintaining the functionality of the program. On a separate note, I like to use it to draw the functionality of an application using IA Visual vocabulary for which I've made a set of diagrams (it is very easy).

If you only need it to draw/design/create a chart/diagram the above software I found it easy to use, easy to customize and it is free.

If you need to visualize (or design) a database model (and many other things to do with it), for this I use Navicat. I use this tool a lot as it allows me to do many things with ease. I use it locally and remotely as it allows SSH tunneling (and on server I skip-networking, so the 3306 is closed and SSH port is moved). But I guess this is not as interesting, it is probably the first part of the answer that presents interest.

Last edited by masterlayouts; July 21st, 2012 at 09:55 AM.
Reply With Quote
  #6 (permalink)  
Old July 21st, 2012, 10:35 AM
Rod Stephens's Avatar
Wrox Author
Points: 3,145, Level: 23
Points: 3,145, Level: 23 Points: 3,145, Level: 23 Points: 3,145, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2006
Location: , , .
Posts: 641
Thanks: 2
Thanked 96 Times in 95 Posts
Default

Looks like a pretty good tool. Thanks for the recommendation!
__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

(Please post reviews at Amazon or wherever you shop!)
Reply With Quote
  #7 (permalink)  
Old July 22nd, 2012, 11:42 AM
Registered User
Points: 12, Level: 1
Points: 12, Level: 1 Points: 12, Level: 1 Points: 12, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Not sure if it helps... but I can let you know what I am using

It helps. I scoured the web looking for something like this and it looks very good. Also, I am a self-taught amateur who works entirely alone, so seeing at first-hand how others work is very instructive and useful. Many thanks.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Drawing Shapes cbulutlar Javascript 2 March 6th, 2006 02:25 PM
drawing fergo Access VBA 0 June 6th, 2005 01:35 PM
drawing fergo BOOK: Access 2003 VBA Programmer's Reference 1 June 5th, 2005 10:32 AM
Drawing in C# stripytiger VS.NET 2002/2003 4 August 25th, 2004 11:01 AM



All times are GMT -4. The time now is 01:08 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.