question

pearlzil86 avatar image
pearlzil86 asked

Create the following data base in MySQL

Create database in MySQL that can accomplish the following:

1] Provide the commission tabulations due each month to associates

2] Along with the commissions for each associate provide the actual number of active memberships that were credited

3] List the names of inactive memberships that monthly payments were declined

4] Have boxes that can be checked for memberships

that are active or inactive in accordance with their monthly payment status and have this function automated

5] Be able to provide monthly report of active and in active associates

6] Allow each associate to build a network of at least 30 business partners

Attributes:

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

The following reports to extract from the database.

Report 1:

  • Name of client:
  • Phone Number:
  • Address:
  • membership active or inactive
  • Total monthly revenue for each Associate

Report 2:

  • Name of client:
  • Amount Paid so far:
  • Balance outstanding :
  • Total monthly and yearly recruits:

mysqlsql querysql databasepython
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.