And why can't we use Duplicate table instead of an Alias table.
Well the difference here are,
| Alias Table | Duplicate Table |
| Its a mirror image of the Parent Table | Its a Copy of the Parent Table |
| We can't edit or modify Alias Table | We can edit/modify/delete columns in Duplicate table |
| Changes made in Parent Table is automatically reflected in Alias table | Changes made in Parent table are not reflected in Duplicate table |
| Used : When there is a need to avoid self-join or circular join | Used when there is a need to use few columns of Parent table. |
Its always good to use an Alias table, as it is more convenient in maintaining the RPD .
No comments:
Post a Comment