A. The Area being Modelled is :-
Inventory Control for a Retail outlet, such as a Health Food Store.

Here is the Statement of User Requirements, provided by John.

I looked at your 200 Data Models, and I thought that the Department Store database
would be a good start but then the Cosmetics Home Sales looked good as well, also
the Inventory Control looks relevant, but then I got very mixed up and I would like
to see if you can help me.
I would like to put my inventory (I own a small health food store) in
a database, that I will be able to search by Brand, Category or Vendor etc..

Also I would like to be able to select an item and see from which Vendors
is available and at what cost.

I buy the same items from several Vendors and I would like to maintain
that information in an easy manner, also I get monthly special pricing
from my vendors that Iwould like to be able to see the cost.

All of the above I consider my Vendor Catalogs data.

At the same time I would like to have an area that I keep my store inventory
and at the same time to be able to see the Monthly Specials and if I
select an Items from my vendor a catalog to bring it into the store side of
the inventory part.

Currently, I keep my vendor catalog in an Excel Spreadsheet and I have a
drop down list, but it is very slow and not easy for every one in the store to use.

B. The Things of Interest, ('THINGS'), include :-
B.1 Items
B.2 Suppliers

C. These THINGS are Related as follows :-
C.1 An ITEM can be supplied by one or more SUPPLIER.
C.2 A SUPPLIER can supply zeor, one or many ITEMS.

D. Other Characteristics of these THINGS include :-
D.1 An ITEM has an Inventory Re-Order Quantity.

E. Sample Data includes :-
To be determined

F. Typical Enquiries include :-
F.1 How much Camomile Tea is in stock ?
F.2 How much Soya Milk do I order ?


Barry Williams
Principal Consultant
Database Answers
20th. September 2002