Omnigraffle database modelling software#
I just did a - to make my table names Bold.įreeMind-and mind-mapping software in general-provides its biggest benefit by staying out of the way of the creative process. You can go crazy with different fonts, background colors, and even HTML formatting. The circles at the ends of the Departments, Employees, and Hours tables indicate that there are more nodes that are folded up. You can add as many or as few details as you like and can always fold up the details to de-clutter your view. It is very easy to navigate the interface without using the mouse within about five minutes. It's similar to designing with pencil and paper in that there's not a lot of surface complexity to interrupt the design process.īut it has two huge advantages over paper/pencil: I like to use the open-source mind-mapping program Freemind. However, if you really feel more comfortable with extremely detailed graphics than with text files and overview graphics, you might want to try Just sketch the table names and the most important relationships (foreign keys).Īny further details will decrease the value of this overview. Here, however, pencil and paper are faster than any drawing software.Īlso note that there is no need to clutter an overview with unimportant details. It becomes necessary to support the brain by creating an overview. In the same way it creates fantasy pictures while reading a book. Instead, let your brain build a picture of the schema Using a drawing tool in that early stage is just distracting,īecause it encourages to waste your time with moving reactangles. So the text file gradually transforms into valid SQL code. Later I add types and CHECK() constraints, It just needs to be clearly arranged and easy to change. I prefer to develop a database schema in a simple text file.Īt first it contains just the table names, attributes and foreign keys:
0 kommentar(er)
