© George Tillmann 2017

George Tillmann, Usage-Driven Database Design, 10.1007/978-1-4842-2722-0_5

5. LDM Best Practices

George Tillmann

(1)Ship Bottom, New Jersey, USA

Do not let what you cannot do interfere with what you can do.

—John Wooden

Do well and right, and let the world sink.

—George Herbert (Welsh poet)

Did you ever add a column of figures and the total did not agree with someone else’s total? Accountants have a quick test for such an accounting error. Subtract one column total from the other column total. If the difference between them is evenly divisible by nine, then two digits were probably reversed (129 instead of 192) or a zero is left off the end of one of the numbers.

Little tricks like this can easily catch simple mistakes before ...

Get Usage-Driven Database Design: From Logical Data Modeling through Physical Schema Definition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.