Data Modeling Made Simple: A Practical Guide for Business and Information Technology Professionals

Overview

Ever have a bad data day?

If you're a business user, architect, analyst, designer or developer, then you've probably had some bad data days. It comes with the territory. Overcoming these problems is much easier if you have an in-depth understanding of the actual data. That's where a data model comes in handy. It's a diagram that uses text and symbols to represent groupings of data, giving you a clear picture of your business and application environment. Data Modeling Made Simple provides the tools you need to read, create and validate models of your business and applications.

This book contains everything about modeling you need to know but were too afraid to ask, such as:

• What are the traditional and nontraditional uses of a data model?
• How do subject area, logical, and physical data models differ?
• When do I build a BSAM, ASAM, or CSAM?
• What is the easiest way to apply normalization?
• Where can I best leverage abstraction?
• How do I decide whether to use denormalization or dimensionality?
• What are primary, foreign, alternate, virtual, and surrogate keys?
• What is the best approach to building the models?
• How can I use the Scorecard system to validate a data model?

Plus over 30 exercises to reinforce concepts and sharpen your skills!

Read More