If you work with distributed teams, including offshore developers and testers, you know that the more distant the development team, the greater the need for precision. Precise doesn’t mean bigger documents in more abstruse notations. In this course you will learn a simple and compact system for collaborative modeling that enables you to capture the most information in the smallest space with the least work in a way that’s easily testable and highly adaptable. By doing this precise analysis you will deliver more value in less time with higher quality.

Objectives:

• Learn how to organize a problem domain's concepts into a formal and accurate relational data model.
• Create tables, columns, relations, and constraints that accurately reflect data requirements.
• Use basic principles of normalization to ensure consistency. Understand when "de-normalization" is and is not appropriate.
• Create non-relational data models (such as XML schemas) and learn how to convert between relational and nonrelational models.