question

pearlzil86 avatar image
pearlzil86 asked

Create database that can accomplish the following:

There are two phases, that being year one revenue and year two and beyond.

compensation is simply subtract 3

Phase [1] – Year [1]

To recruit Mike in the business and they recruited 200 individuals as their business affiliates the first active individual who made their $100.00 monthly membership fee would be credited to me and I would receive $80. 00 monthly from the membership payments. Mike would receive the other $80.00 monthly from his remaining 199 active business affiliates. Note: Active means their monthly membership was received.

------------------------------------------------------------

Phase [2] – Year [2] And Beyond

The beginning of year 2, business would be credited 2 additional business affiliates from Mike for a total of 3 and Mike would receive the other $80.00 monthly from his remaining 197 active business affiliates. Note: Active means their monthly membership was received.

Therefore; business compensation is Subtract 3. If Mike went on and recruited a 10000 business affiliates, only get his first three active affiliates and Mike would benefit from the remaining 999.997active affiliates he recruited.

Note: An individual does not have to purchase a membership to sell our memberships. In a case such as that the first three active memberships they sell will be deducted -- 1 in year 1 and 3 in year two and beyond. However; the membership will count as one of the membership fees to be credited to their sponsor.

There needs to be boxes to be checked for each affiliate alerting the system to recognize if a membership is active so it can be accounted for and credited properly.

Example: I recruit Mary into the business and she purchase a membership and recruited in the following order four people in the following order.

Mike 1] – 2 Bob] – 3 Jack] –4 Paul

Year 1 Scenario [1]: Mary makes her monthly membership payment and all of the individuals she recruited make their monthly payments.

System/spreadsheet should show

Mary’s payment being credited to me and Mary being credited with the $80 monthly commissions from

Mike 1] – 2 Bob] – 3 Jack] –4 Paul

Year 1 Scenario [2]: Mary does not make a make her monthly membership payment and/or does not have a membership. Her first recruit that makes their monthly payment will be credited to me and Mary will receive $80 credit for each of her remaining recruits who make their monthly payments. the individuals she recruited make their monthly payments.

Key points

Every entry should have an active or inactive status that can be selected

Every active entry produces an $80.00 monthly credit

Non active entries simply produce N/A

The sponsor and their recruits are connected by the sponsors id number which is their social security number a field needs to be created.

The data base should be able to calculate the commissions to be paid to each member in the data base each month month.

In year one the sponsor gets the first credited sale from their recruit /also known as affiliate but in year 2 the sponsor gets the first 3 credited sales from their recruits so if their can be a 12-month timer created in the system that automatically makes the change from I recruit to 3 recruits being credited.

There should be at least 30 entries for each individual and or a system in place when an entry is submitted five new fields are generated

Attributes:

  • Name of client:
  • Amount:
  • Date of transaction:
  • Phone number:
  • Address:
  • SSN


mysqlpython
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.