Structure Programming – Advice from IT.Toolbox

The only point I disagree with in this article is about replicating code for readability! DO NOT REPLICATE code ’cause it also replicates Maintenance Costs! Other than that – Bravo to the author: Craig Borysovitch! http://it.toolbox.com/blogs/enterprise-solutions/systems-development-structured-programming-guidelines-48980   bgbg

Orthogonal Views…

A current definition provides us this: or·thog·o·nal   [awr-thog-uh-nl] adjective 1.  Mathematics . a. Also, orthographic. pertaining to or involving right angles or perpendiculars: an                 orthogonal projection. b. (of a system of real functions) defined so that the integral of the product of any           Continue reading “Orthogonal Views…”

Remember Codd and Date?

These were two technology authors who were quoted on the subject of Relational Integrity and a Normalized Data Model.  Their ideas of reducing redundancy in the physical data schema and protecting the mandatory relationships between entities took a whole lot of attention about how to create, define, and manage data so that it was safeContinue reading “Remember Codd and Date?”

Input – Process – Output

What exactly should a computer program do?  How will you know if the program you have written or requested to be written for you does what you need it to do? It’s really a whole lot simpler than you might think. If you, as a business user, can define what information is available to accomplishContinue reading “Input – Process – Output”

Syntax of an ERD – Entity Relationship Diagram

Syntax Rules for an Entity Relationship Diagram: An Entity Relationship Diagram Sample: Use this link: https://docs.google.com/drawings/d/1keA4BzVCJXcUoNWDw7-0pIrQ7AsB5CgavjWR7P5Wyrg/edit?hl=en_US (may have to paste into a browser) Business Rules derived from this sample are: It is also interesting to note that since there is no relationship between Customer and Product there are no Business Rules that can be derived betweenContinue reading “Syntax of an ERD – Entity Relationship Diagram”