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?”
Category Archives: Object
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”
