Anonymous

• Oct 13th, 2006

 

During the logical design phase, you defined a model for your data warehouse consisting of entities, attributes, and relationships. The entities are linked together using relationships.

During the physical design process, you translate the expected schemas into actual database structures. At this time, you have to map:

• Entities to tables
• Relationships to foreign key constraints
• Attributes to columns
• Primary unique identifiers to primary key constraints
• Unique identifiers to unique key constraints

n if u refer this diag u will understand better : -