I need someone to create a category creation and management tool for a web site.
The tool should be able to
1. Create a category
2. Apply a category to sub cagtegories
3. Allow a category to be applied to multiple sub categories
4. Return all relavent records from sp using the following inputs and outputs
4a intBeginCategory int INPUT (optional)
4b strBeginCategoryName varchar INPUT (optional)
4c intMaxLevel int INPUT (optional default all)
4d intCategoryId int OUTPUT
4e intCategoryParentId int OUTPUT
4f intLevel int OUTPUT
4g strCategoryName varchar OUTPUT
The key here is that a single parent child relationship wont work since a sub category may be a parent category or belong to other multiple parent categories.
As an example consider
Freshwater Fishing
Crankbait
Topwater Crankbait
Saltwater Fishing
Crankbait
Topwater Crankbait
With a single table this is not possible since crankbait appears as a child to both freshwater fishing and salwater fishing.
My current table design is
CATEGORIES
category_id pk
short_description
long_description
create_date
created_by
CATEGORY_XREF
category_id
child_category_id
create_date
created_by
Please contact me if you have further questions
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
## Platform
ASP
SQL Server