Bitmap indexes are useful for low cardinality column(s) for 3 primary reasons: 1. Rowid bit map value of indexed values are stored together, making faster access for group data access 2. Bitmap Indexes saves space 3. Bit mapping where 2 or more bitmap indexes can be…

Here are some of the advantages of managing data in different layers 1. Provides logical separation of data between different layers 2. For any maintenance of each layer such as backup or recovery or data model change apply, etc. are layer dependent 3. From data security…

Space requirement will be directly dependent on design considerations and data requirements. Any estimation without detailed information is bound to be faulty and should be used as reference only Here are my recommendation on how to go about it: 1. Staging Estimating…