Database Answers Westfield London at Christmas (Click for Web Site)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map 
Data Model for Customers and Products (Generic) 
An Access Database is available on demand. This Model is based on our Canonical Data Model.

There is also a design for a Data Mart which is an excellent start for Enquiries and producing Reports.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.

This is an 'Easy to understand' version showing only the Entity names.
There is also a Data Model showing Attributes, and one showing Reference Data and one showing the exact details of tables in the SQL Scripts.

There is also a design for a Data Mart, which is very useful for providng data for Reports and Business Intelligence.

Data Model for Strawberry Exports A) Produce the Database using the Data Model with Attributes
  1. Create and load Data into the Reference Data Tables (beginning with 'REF_').
  2. Create the Stores Table.
  3. Create the Customers Table.
  4. Create the Products Table.
  5. Create the Customer_Orders Table.
  6. Create the Order_Items Table.
  7. Create the Invoices Table.
  8. Create the Invoice_Items Table.
B) Use Oracle Apex to generate Data Entry Pages and load data for all the Tables listed above.
C) Generate Apex Pages for the following functions :-
  1. Add Standard Reports - Total Sales by Customer, Product (Drill-down by Product) , Store and Time-Period.
  2. Add Invoice Printing
  3. Add multiple Currencies
  4. Add Export handling
  5. Add One-off Payments (incoming or outgoing, such as Insurance Payments for Claims)
  6. Add Recurring Payments (eg regular Orders or Insurance Payments)
  7. Add Document management


Barry Williams
Principal Consultant
Database Answers Ltd.
London,England
November 15th. 2013


© DataBase Answers Ltd. 2013(By/By)
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map