SEO

#1 (**permalink**) 02-28-2008, 05:00 PM

There is not a sophisticated free solution available on the web (I've
searched tons). The basic model is the Northwind. But, for a real life
sophisticated model, there is one book out there that has become to be known
the authority on database modeling of all sorts - check out this book:

http://www.amazon.com/exec/obidos/AS...owertechcanada

This book saves tons of time when developing any database project as you can
combine it into your project very easily.

It has sample models for Party's (relationships), Contacts, Orders,
Shipments, Invoices, Accounting, Employees, Human Resources, etc. The models
in this book are complex models that are implementable by all sorts of
business - even Fortune 500 businesses. Volume 2 of the same book has models
for specific industries such as Financial Services, Professional Services,
E-commerce, Manufacturing, Health Care, Insurance, Travel,
Telecommunications.

"Sarah" <sarah02@canada.com> wrote in message
news:ttYma.54608$7L.3553786@news0.telusplanet.net. ..
> Hi,
>
> Where can i find sample database to adapt to my own system I'm designing
to
> handle invoices, returns, customers, payments, and other accounting
> functions?
>
> Thanks.
>
>

#2 (**permalink**) 02-28-2008, 05:00 PM

Centuries ago, Nostradamus foresaw when "MS" <Mithu.april.2003.nntp@powertechcanada.com> would write:
> There is not a sophisticated free solution available on the web (I've
> searched tons). The basic model is the Northwind. But, for a real life
> sophisticated model, there is one book out there that has become to be known
> the authority on database modeling of all sorts - check out this book:
>
> http://www.amazon.com/exec/obidos/AS...owertechcanada
>
> This book saves tons of time when developing any database project as you can
> combine it into your project very easily.
>
> It has sample models for Party's (relationships), Contacts, Orders,
> Shipments, Invoices, Accounting, Employees, Human Resources, etc. The models
> in this book are complex models that are implementable by all sorts of
> business - even Fortune 500 businesses. Volume 2 of the same book has models
> for specific industries such as Financial Services, Professional Services,
> E-commerce, Manufacturing, Health Care, Insurance, Travel,
> Telecommunications.

Seems an interesting book, along with the "other Volume."

What is totally non-evident in looking at either the Wiley web site or
the author's own site is what the licensing arrangements are for using
the data models.

Is there a clear license communicated in the documentation? Or does
use indicate that some combination of Wiley/Silverston/Universal Data
Models LLC wind up holding title to a portion of your resulting
project?

If paying ~$55 for the book, or ~$400 for downloads leads to
permission for royalty-free usage, then that may be quite reasonable,
if it leads to time savings. But if UDM-LLC wind up owning part of
the resulting work, that may not be nearly so acceptable...
--
output = ("cbbrowne" "@acm.org")
http://cbbrowne.com/info/lsf.html
"Microsoft OS's are good because they encourage Intel to produce
faster CPUs for the rest of us to run Unix on." -- George Dau

#3 (**permalink**) 02-28-2008, 05:00 PM

> What is totally non-evident in looking at either the Wiley web site or
> the author's own site is what the licensing arrangements are for using
> the data models.
>
> Is there a clear license communicated in the documentation? Or does
> use indicate that some combination of Wiley/Silverston/Universal Data
> Models LLC wind up holding title to a portion of your resulting
> project?
>

The models can be used free of charge - the book goes through the decisions
in to why you create the models as devised in the book and how to make
possible modifications if necessary. The CD-ROM for book is licensed
seperately and only contains the SQL scripts and diagrams for casing tools
for the models. They are not required in any way to implement the model. It
is definitely well worth the money ~$55.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: Sample Database for Creating an Invoice Application