database demo
The example below shows some fictitious wines, but the same principle could be applied to whatever you are selling or listing, for example, cars, houses, antiques etc etc. The purpose of this demo is to show how a database driven site works, the benefits of a database driven site and to show how it might be applied to your business.
Obviously, this is a demo only, so I haven't created all the fields that would be expected in a wine database! If you want to see one of the sites designed by us, have a look at Wales Cottages.
| Wines (in price order) | ||||||
 |
Wine: | Splot | Vintage: | 2002
|
Price: | 1.99
|
| Good in a stew, but don't drink it! |
||||||
 |
Wine: | Gasper | Vintage: | 2003
|
Price: | 1.99
|
| This will take your breath away - permanently! |
||||||
 |
Wine: | The Old Sizzler | Vintage: | 2002
|
Price: | 1.99
|
| Sharp as a razor, good for cleaning drains. |
||||||
 |
Wine: | Glug | Vintage: | 1995
|
Price: | 2.99
|
| Rich and fruity, suitable for everyday drinking. Nice with cheese |
||||||
 |
Wine: | Smoothy | Vintage: | 2001
|
Price: | 5.99
|
| As its name suggests, beautifully smooth |
||||||
 |
Wine: | Gloop | Vintage: | 1996
|
Price: | 7.99
|
| A full bodied red, drink now or over the next 2 years |
||||||
 |
Wine: | Swagmans | Vintage: | 1996
|
Price: | 7.99
|
| A fresh, crisp white that's a delight. |
||||||
 |
Wine: | Red Cow | Vintage: | 1998
|
Price: | 7.99
|
| This is much better than an udder one we could mention |
||||||
why?
The advantage of a database driven site is that the same information can be displayed on several pages, without the need to rewrite each page whenever a detail changes - for example, the price. Also, when you have many similar products -each with the same type of infrormation, then only one page design is needed - displaying the products individually is all done through the database.
In the wine example, the following pages might be wanted;
Reds, Whites, Country specific e.g. French, Italian, cost specific e.g. 'under £5', under £10, Special Offers
So, a French red normally retailing at £6.99 is dropped in price to £4.99 and with a small change in the database, it automatically moves onto the 'Special Offers' page and appears on the 'Under a Fiver' page. When many changes are needed, the time savings are significant.
When you've finished looking at the various 'more details' pages, note the price of 'Smoothy' now, then you can go to the update page and alter the price.
