Database Answers Header
Home First Timers Ask a Question Careers Clients Community Data Models Tutorials Site Map
BMEWS and BI in the Clouds - Display Data for Retail Customers 

Conceptual Data Model


For this demonstration, we show the test data below.
If you click on one of the Entities on the left, the appropriate data will be displayed by our Oracle Apex application.
Back to BI for Retail Customers Data Page

Store ID Store Name
1 Windsor

Customer ID Customer Name
1 John Smith

Purchase ID Customer ID Store ID Date of Purchase Amount of Purchase
1 1 1 Jan-01-2014 100
1 1 1 Feb-01-2014 200
1 1 1 Mar-01-2014 300
1 1 1 Apr-01-2014 400
1 1 1 May-01-2014 500
1 1 1 Jun-01-2014 10,000


© DatabaseAnswers.org 2014
R>
About Us Contact Us
Stores