Help Designing and Implementing Database & Website
$30-5000 USD
Zaprt
Objavljeno pred skoraj 21 leti
$30-5000 USD
Plačilo ob dostavi
I need help designing/redesigning an existing database and website. I need two things: First, someone to look over my database design and workflow from the website. Make any changes in structure to increase efficency. Database is MS SQL 2000. Second, I need help creating reports, forms, and other components on the website using ASP. I would prefer to pay hourly or by task. I have attached a database diagram and a website workflow chart.
## 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) Complete ownership and distribution copyrights to all work purchased. Task need for completion
* Adjust data entry and database for eliminating duplicate entries and normalization
* Develop a web based site wizard for Optin website creation
* Form to enter event info into event table in database
* Event name
* Event dates & times
* Event description (opponent or artists)
* Event sponsor
* Form to enter event preferences into site preferences table???
* Fonts
* Colors
* Logos
* Banner ads
* Coupons
* Form to enter survey questions and available choices into survey table
* Questions and Answers
* Script that processes info in event table, preferences table, survey table and builds a site based on templates.
* Modify site to allow for multiple sponsors
* Pages look in database to see whether there is another sponsor.
* What are the logos and colors for this sponsor?
* What survey questions go with this sponsor?
* What banner ads, coupons, etc. go with this sponsor?
* What should the email say for this sponsor?
* Build reporting module for all events.
* Customer login
* Show events for customer to choose
* Show reports for that event
* statistics (report already done - need to automate some task so that report looks to see what days photos have been taken)
* photos per day graph (report already done - need to automate some task so that report looks to see what days photos have been taken)
* Customer download data to Excel (report already done - need to automate some task so that report looks to see what days photos have been taken)
## Platform
Windows SQL server 2000 Website uses ASP / VBScript