I have an entity lets call it Response, and another entity called ResponseType, Response entity contains the ResponseType; so when I am building the physical model I confused with how to implement it; I have two option ; 1. I can create a Response table for each of ResponseType. 2. I can create a Global Response table with a ResponseType Column and create a partition for each ResponseType; Note that; Response Entity is same for each of ResponseType. Each ResponseType is equivalent.
What is your idea?