Database Answers customer Service Logo
Printer Printer-friendly version

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

There might also be 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.

Conceptual Data Model

Conceptual Data Model
ERD Data Model

ERD Data Model
Here we discuss how to build a Proof-of-Concept using Oracle's Cloud-based Apex ...

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
February 14th. 2013

© DataBase Answers Ltd. 2010
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map