First Database attempt _ Price Design Flow

[KenozGG]

Hello all,
I am creating a database consisting of Nursery Plants, clients, and attributes (size of plant, color, etc). I already have the product(plants), clients, client address, and attributes tables set at the moment. What I am stuck in designing is a efficient way in creating a price list. Each client has its own Wholesale price list AND Retail price list, plus I have to deal with size variables with each plant product. So, would it be efficient to design a wholesale and retail table for each client? Should I design by each product and size, and have my clients added to by fields (column)? Hopefully one of you members can help me out with any pointers, Thank you.



What I have at the moment is:

Tables:
Category //Specifies a plant
Product //Botanical names of plant (idCatagory, name)
Attributes //(Size, Discontinued)
Clients
Client Address //(idClient)
Price //How would I add this to to my database? I have a client who has wholesale and retail prices. Each Product has 6 different sizes, (1 product * 6 sizes = 6 product sizes).

[Geo21]

Since the price is not standard, you will need to create a query and collect all the needed fields from the tables. You will then add "Wholesale Price" and "Retail Price" columns.

[A S MANN]

in my opinion the design of table should be
Tables:
Category //Specifies a plant Botanical names of plant
Product // (idProduct, Product name ,Size Of Plants , Discontinued, Price, Discount)
Product_Order_Detail//id Product, Order Id,
Order // Order ID,idCustomer, Order Details,Date , Payment Details
Customer //(idCustomer), Customer Details


Refer Microsoft NorthWind sample DB Table Design
You can Edit the design as per your need and fill it with your data and use it straight way.