Data Management Reference

Concepts and Techniques

There are many concepts and theories surrounding data management, from exactly how to capture business requirements surrounding data to how to physically store information about the business historically. For many of these ideas, there is no single right answer. The solution will depend heavily on precisely what the problem is and in what context. There are, however, a number of techniques to help the practitioner to sift through the chaff and get the job done.

• Rules of Normalization
• Cardinality Explained
• Cardinality with Mandatory Parent

White Papers

For some of the ideas and topics, it may help to have a short narrative written to explain and provide context.

• About Surrogate and Natural Keys
• What are Look-up Tables?