Those three kinds of data-model instances are conceptual schema, logical schema, and physical schema. ... It has four different sets of relations between the entities: one to one, ...

Yahoo’s data and business intelligence architect, Rohit Chatter, answers the latest debate, Star versus Snowflake schema, by breaking down the differences, one aspect at a time.