Pricing Problems

[tony6562]

Hi,
I have a problem with pricing of items. I am writing a database for a company that sells pigeon rings and not sure hoe to go about the pricing.

They are for example:

Std rings are qty 25, 50 or 100 £8, £12 and £19 respectively

ETS Rings 25, 50 or 100 £8, £12 and £19 respectively

Singles 1-15, 1-25 or 1-50 £ 5, 9 and 13 respectively



Widow Hoods 1-15, 1-25 or 1-50 £ 5, 9 and 13 respectively

Also the price may differ and the qty's may change with each order

One other query I have is that I want the customer to be able to change the main pricing structure easily.

Just unsure the best way to go about this in tables any ideas would be grateful, any questions about this please ask And I will get back to you straight away.

Thanks

Tony

[orange]

You may want to view and review these tutorials. The underlying theme is Customers,Orders, Items and involves pricing.
There are many design concepts in the material.
These free video tutorials describe the processes of data modelling, normalization and entity relationship diagramming. There are other videos, but this group is by the same presenter and covers an example situation.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2