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