Need very experience database developer to design a multi attribute product database to be use in an intranet/internet in asp. This is an example: Manufacturer: Kodak Department: Camera Category: Film>Consumer Film>Color Film Brand: Royal Gold Item code: xxxx Alias code: An individual item may have multiple lookup numbers. For example, your assigned number, your vendor's number(s), UPC codes and various other price lookups (PLU's). multiple alias code per items, can have same alias code with another items too. The look up will display multiple items for selection. Model no: Inventoried, Non Inventoried, Mfg Serial No, Auto Serial No New item: Newly on market items where the New Items status will expire in 60 days. Item Desc: Royal Gold Color Film 2nd Desc: Product Features: Product Details: Weight: Measure: By buy case, may sell by piece or any promotion combination, items with multiple case sizes. As you do not always sell items in the same case sizes as they are purchased you can define which case sizes are purchased and which are sold. Of course ability to assign the correct cost and price to each size Over size item: T/F Up Sale Information: Upgrade Item: Accessories: related items Warranty: Custom fields: character, numeric, T/F, Date add as needed up to 10 each type. Returnable: % stocking fee, non-returnable, days, exchange only, store credit Resource links: In stock: Product photo: Pick up: At store, Warehouse Attribute name Description ASA 100 ASA 200 ASA 400 ASA 1000 Format 35mm Format 110 Format 126 Format Disc Format 120 Format 220 Format 4X5 Format 5X7 Format 8X10 Exposure 24 Exposure 36 Exposure 10 Exposure 25 Exposure 100 Exposure 100 Ft Exposure 250 Ft Unit of measure package Weight 1 roll/pack 5 oz. 5-rolls/pack 25 oz. Other product like T-shirt has many attributes: Size, Pattern, Color, Material, Style, How to handle Price group by Color Group, Light color, Dark color, Natural color Rest of the description in Word format.
Complete and fully-functional working program(s) in executable form as well as complete source code and comments of all work done. Complete copyrights to all work purchased.