F
frank
Hi there. Before anyone gripes about cross posting, Ill say upfront
that I just posted this message to am SQL server newsgroup because I
want feedback from database developers as well as asp coders...
I want to create a web based software rating database. I have a
number of objectives that I would need to achieve to make this a
useable tool and some are not easy figure out considering my
begginning level of db and asp knowledge. I am hoping that with an
asp code generator and some occasional feedback from the talent that
roams this newsgroup, I may be able to accomplish my goal.
Here are the objectives of this tool:
1. Authenticated visitors must to be able to create Sub-Categories
under a drop down list of pre-defined Categories. The drop down list
also needs to be dynamically updated as new Categories are added to
it.
2. Authenticated visitors must be able to add software titles (and
other attributes) under the Sub-Categories.
3. Non authenticated visitors (public) need to be able to search and
browse the list of titles and add a rating to them.
4. The ratings will be on a number of criterion and the actual rating
figures need to be averaged and then displayed as a graphic on the end
of each search result line item etc.
There are tens of thousands of software titles and this tool would be
available to the Internet so this has the potential of becoming a
large database. This makes poorly scaleable MSAccess out of the
question. My next two realistic database choices are MSSQL 2000 or
MySQL. I have a preference for MSSQL 2000 because I am pretty
familiar with it and I already have a environment where I can build my
project.
What I am hoping for out of this post is some feedback as to how
difficult a project this really is. Feedback appreciated.
-Frank Wells
that I just posted this message to am SQL server newsgroup because I
want feedback from database developers as well as asp coders...
I want to create a web based software rating database. I have a
number of objectives that I would need to achieve to make this a
useable tool and some are not easy figure out considering my
begginning level of db and asp knowledge. I am hoping that with an
asp code generator and some occasional feedback from the talent that
roams this newsgroup, I may be able to accomplish my goal.
Here are the objectives of this tool:
1. Authenticated visitors must to be able to create Sub-Categories
under a drop down list of pre-defined Categories. The drop down list
also needs to be dynamically updated as new Categories are added to
it.
2. Authenticated visitors must be able to add software titles (and
other attributes) under the Sub-Categories.
3. Non authenticated visitors (public) need to be able to search and
browse the list of titles and add a rating to them.
4. The ratings will be on a number of criterion and the actual rating
figures need to be averaged and then displayed as a graphic on the end
of each search result line item etc.
There are tens of thousands of software titles and this tool would be
available to the Internet so this has the potential of becoming a
large database. This makes poorly scaleable MSAccess out of the
question. My next two realistic database choices are MSSQL 2000 or
MySQL. I have a preference for MSSQL 2000 because I am pretty
familiar with it and I already have a environment where I can build my
project.
What I am hoping for out of this post is some feedback as to how
difficult a project this really is. Feedback appreciated.
-Frank Wells