Database Answers Grocery Store

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Grocery Store
Back to the Data Model

The User Requirements have been defined and are listed below.
The Area being Modelled is :-
A Grocery Store that does home deliveries.

A. STATEMENT OF USER REQUIREMENTS :
Here's the Requirements of my Database :

In my database,Customers should be able to place Orders by phone and 
get the Products sent home by a qualified person who drives to people's homes 
to deliver the order,or ordering by phone and going to the store to pick up the products.

There are 2 Types of Products ; 
1. Vegetables (which can't be sent to people's homes because of sanity conditions) 
2. Normal products.

Vegetables are only available Mondays and Wednesdays.

Products can be ordered from the Suppliers and if there's lack of products,they are 
ordered from the Supplier.

Each Supplier sells different Products.
Each time a person orders something,if he isn't registered as Customer he must do so.

Payments can be done partially or fully.
If the Customer doesn't pay right away,his name is added to a book of people who still haven't paid.

There should be a register of the status of the bills,paid or not.

That is the end of my Requirements of my Database.

B. The Things of Interest, ('THINGS'), include :-
B.1 Customers.
B.2 Deliveries
B.3 Employees, which are Drivers in this Model.
B.4 Orders.
B.5 Products.
B.6 Suppliers

C. These THINGS are Related as follows :-
C.1 A Customer must be registered to place Orders.
C.2 A Delivery contains just one Order.
C.3 An Order contains a number of Products.
C.4 Products can be ordered from the Suppliers and 
    if there's lack of products,they are ordered from the Supplier.
C.5 Each Supplier sells different products.

D. Other Characteristics of these THINGS include :-
D.1 To be determined

E. Sample Data includes :-
E.1 To be determined

F. Typical Enquiries include :-
F.1 To be Determined
 
A GLOSSARY OF TERMS WOULD GO HERE AS A TABLE ...

Barry Williams
15th. June 2008
Principal Consultant
Database Answers
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map