Database design/integration

attached nondisclosure agreement must be completed prior to any access to files or work being started. (.doc attached) See [login to view URL] This is what the site will need to do. : Registration: Before anyone can purchase our product they must register with our site, we are going to need them to create a username, password, leave their full name first/middle/last, full mailing address and e-mail address with a confirm e-mail address. - After registration they should reach a thank you page, that confirms their registration and then has a 10-second timer to redirect their new "my Account page" also during the registration process we would like to integrate this into an e-mail campaign manager like [login to view URL], so that when they hit submit, it not only opens their account for them, but also enters their data into our email campaign here is a link to a site that is simliar to our idea [login to view URL] My Account Page/Affiliate page The My account page should reveal several things to the account holder, 1)how many referrals they have made, 2)how much money they have made & how much money their referrals have made them 3)where they are on the list (if they purchased our product) 4)an admin area where they can update their profile, change their password or cancel their account 5)an area where they can get creatives Links to our website with their special tracking code, which should be automatically generated for them, so all they have to do is copy and paste. 6)a reseller area. some people may not want to take part in our program and we will offer those people a place to purchase our product at a discount for their own personal use or to resell on the internet. Affiliate Tracking: We want a two tiered affiliate program. We want to be able to manipulate the percentages down to the 2nd decimal point ie. 35.47% . 2 2 tiers mean that if one affiliate refers another affiliate that referring affiliate will earn a comission on the referred affiliate ie. bob gets pam to sign up bob gets $[login to view URL] for pam signing up / pam gets tim to sign up pam gets $[login to view URL] for tim signing up and bob get $[login to view URL] for tim signing up through pam The Database: The database will have the function of queueing people once they have made a purchase and decided which category of gift they want to receive. There are currently 6 categories (possible expansion to more in the future) The database will need to track 2 seperate functions. 1) the purchase of our product automatically places that person into the queue of their choice. each database will have a predetermined amount of purchase of our product for each gift we give out. in this example it takes their purchase plus 4 people to purchase after them per free gift This is an example without "Queue Jumping" MIKE Buys our product MIKE is waiting for 4 new members KERRY Buys our product MIKE is waiting for 3 new members ANDY Buys our product MIKE is waiting for 2 new members CLAIRE Buys our product MIKE is waiting for 1 new member JOHN Buys our product MIKE receives his free gift MATT Buys our product KERRY is waiting for 3 new members SUE Buys our product KERRY is waiting for 2 new members PAUL Buys our product KERRY is waiting for 1 new member MARY Buys our product KERRY receives her free gift JANE Buys our product ANDY is waiting for 3 new members MARTIN Buys our product ANDY is waiting for 2 new members 2) function 2 is an interactive feature that benefits anyone taking advantage of the affiliate program. Anyone whom has purchased our product, and is waiting in queue, and is actively referring people to our site will not only get the commission for the sale but in every queue they are waiting in, their name will jump up one in the list ie. This is an example with "Queue Jumping" Andy has referred 2 people and instead of it taking 11 sales for him to get his gift, it only took 4 sales plus he would have received a commission as well ANDYis 1st thanks to 2 referrals ANDY is waiting for 4 new members MIKE is skipped by ANDY ANDY is waiting for 3 new members KERRY is skipped by ANDY ANDY is waiting for 2 new members CLAIRE Buys our product ANDY is waiting for 1 new member JOHN Buys our product ANDY receives his free gift MATT Buys our product MIKE is waiting for 3 new members SUE Buys our product MIKE is waiting for 2 new members PAUL Buys our product MIKE is waiting for 1 new member MARY Buys our product MIKE receives her free gift JANE Buys our product KERRY is waiting for 3 new members MARTIN Buys our product KERRY is waiting for 2 new members E-Commerce: We will be using the Google Checkout/Merchant system. they offer their own API coding and also offer two levels of integration. We would like to receive a custom quote for both levels of integration. We will offer one product to receive the free gift, however, with each persons account, they will also have the Reseller account mentioned in the "my account" section the main product will be broken up into 7 individual products. Also there should be a dropship option on these checkout pages as an additional charge So we will need the cart to be compatible with 9 purchaseable products 1) the main product 2-8) the main product broken up into individual products for them to resell 9) the main product at a discount price for them to resell here is the link to googles api integration page [login to view URL] Home Page: We have fixed the earlier error with the flash not loading and have re-designed what we want the home page to look like. check it out [login to view URL] Summary: For the most part, anything that includes pricing or percentages we will need easy access to be able to change the numbers around. We are also looking to have the pages built with search engine optimization in mind.