Refer to the northwind database. That has some good data as well as relationships predefined .
even though this is not a suggested approach to look into another database for modelling our data model. :) On Wed, May 6, 2009 at 4:36 PM, rishabh <[email protected]> wrote: > > Hi All, > I am trying to develop an 'Account Management System'. Initially, the > requirements of this system are having recodes for purchases and > sells, Calculation of profit or loss per Day/Week/Month/Quarter-Year/ > Year. > > The user will make entry in the system whenever he/she purchase/sell > any product. > There should also be interface to create new entries for Customer, > Product and Owner before we purchase the product etc. > > Can anyone suggest me what tables are necessary to build the system? >
