A Database is required to help run a business which offers Products for Hire.

Mervin, the User, has defined his Requirements in the following terms :-

I'm so excited about being part of the Database Answers community,
I only started looking at databases about a week ago & finding it fascinating.
There's such a lot to take into account & define to make provision for all the different queries,
questions and answers that might be required now & in the future.

Three years ago I started a small function hire operation from home,
It�s still small but gaining market share constantly.
I�m now looking for a database to replace my excel spreadsheet documents to better track
the performance of my business.
My basic needs are a database for products (dinner plates, fish plates, dessert bowls, cups &
saucers, cutlery, glasses, jugs also tablecloths & different coloured overlayers etc�) customers,
bookings, availability on a specific date, returns, returns due, damages/missing items, late returns, refund of damage deposits.

I also have a discount coupon issued to second time customers and customers who refer others as well
as caterers and function co-ordinators who refer their customers to me, that I would like to track & account.

I would also like to get customer month to date & year to date figures as well as damages month & year to date.

I am very excited about this and would like to do as much as possible myself, but I don�t know much for now.

I�d like a nice GUI that I can modify to reflect a picture or two and the colours I prefer.

Hope I�m not asking toooooo much.

B. The Things of Interest, ('THINGS'), which will become Tables in the Database, include :-
B.1 Bookings
B.2 Customers
B.3 Discount Coupons
B.4 Products
B.5 Refunds
B.6 Etc.

C. These THINGS are Related as follows :-
C.1 A Customer can hire zero, one or many Products.
C.2 A Product can be hired by zero,onr or many Customers.

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