Q1. Distinguish between the terms Data Warehouse and Data Mart.
Q2. Describe the term Data granularity in the Data Warehouse.
Q3. Describe the demerits of snowflake schema.
Q4. Describe the given with reference to the Date Warehouse: “Data inconsistencies are eliminated; data from diverse operational applications is integrated”.
Q5. Describe the refreshing of data warehouse.
Q6. What do you mean by the term referential integrity?
Q7. Describe the demerits of the term granularity.