Subtyping is a powerful communication tool on the logical data model, because it allows the modeler to represent the... An organization has a sales department with four levels, as shown in the following logical data model: Zones are... Your coworker calls you in the middle of the night with a data modeling emergency. There needs to be... A star schema is designed to efficiently answer metric business questions, such as those questions that return amounts, quantities,... A logical data model represents a business solution independent of technology, including the business rules. For example, the rule,... A global manufacturing company needs a data dictionary to assist them with maintaining and publishing definitions of business concepts... An Alternate Key (AK) is a unique identifier for an entity instance that has not been selected as the... A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. A modeling scenario... To better understand the requirements for an analytics data mart, you and a business user are standing at the... One day a colleague asks you for feedback on an enterprise data model (EDM) she has been tasked with...Blogs
Getting physical with subtypes
Creative hierarchy
Definition Differences
Super Star
Rules on rules
Data Dictionary, are you out there?
Null AK?
Broken shells
Recursive fact table?
A Dimensional EDM
0
0