Help Designing and Implementing Database & Website

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

ASP Engineering MySQL PHP Software Architecture Software Testing SQL User Interface / IA

Project ID: #2930327

About the project