Attribute Name Data Type Field Length Description Review_ID Integer 10 Primary key for the fact table Clothing_ID Integer 10 Foreign key connecting to the Product Dimension, enabling product-level analysis. Age Integer 3 Age of the customer who submitted the review is useful for demographic, segmentation and analysis. Rating Integer 1 The customer's rating of the product on the scale of 1 being the worst to 5 (best), representing satisfaction level. Recommended_IND Integer 1 Binary indicator to show whether the customer recommends the product (1 = yes, 0 = no). Positive_Feedback_Count Integer 4 A number of other customers who found the review helpful, indicating the reviews credibility and influence. Location_ID Varchar 16 Foreign key to the Location Dimension, created by combining State and City. Review Length Integer 5 Number of characters in the customers review text. Used to measure engagement Customer_ID Integer 10 Foreign key to the Customer Dimension for demographic analysis