Data Model for a Basic Data Mart
Back to the Data Model

Logical ERD Data Model for the Basic Data Mart Sample Performance Report
Fact Date Customer Area Product Amount Volume Details
1 Feb 1/07 Joseph Smith London Black Shoes $50 1 pair On Sale
2 Feb 1/07 Josephine Smith London Red Dress $100 1 dress  
3 Feb 1/07 Ray charles London Fishing Line $75 1  
4 Feb 1/07 Aretha Franklin London Dress $75 1  
5 Feb 1/07 Al Jareau London Men's Suit $500 1 Alterations
6 Feb 1/07 James Brown London Dinner for 25 $1000 1 Waiter Svc


© Database Answers Ltd. 2017