In Progress

ER diagram for a web-based game

I am endeavoring to develop a CMS-based (joomla, drupal, etc) customized web-based betting system. I need help developing the ER diagram for the database (SQL or XML, open), you (the awardee) can use my previous works (ERD in MS access, and other specifications) for reference. I need a recommendation on the appropriate CMS for this app as well (if ERD is necessary or not, or a different approach is better as long as it's scalable and reliable). Suggestions on any design is OPEN.

I) RULES

0) All accounts have a load and points wallet, except the Game and Account Managers

1) each Subadmin is assigned to a GP (Game Places), location where to conduct the game

2) each Subadmin can create their own pool of anonymous bettor accounts for sale/distribution, anonymous bettor has the same privileges and functionalities as an identified bettor (bettor with a true name)

3) each Game Manager can create their own games in their respective GP

4) each Finance Manager can create their own number of points for distribution to their respective bettors, and use the load bought from the Super Finance Manager for sale/distribution

5) Bettors can transfer load (money) and points from one account to another, Subadmin can set a charge/fee for every transfer of load and/or points from one Bettor to another

6) every game has plenty of points but zero load, when a Bettor (with enough load) bets on a game, he earns the equivalent points and losses equivalent load in his account. the game, in turn, transfers the points to the Bettor acct and gains the Bettor's load in return

7) when the game expires, the Finance Manager transfers back the game account load and points to his account.

8) the game may be reused by the Finance Manager by setting the points, and enabling the game again

9) One or more Bettors will use a single mobile sim number/s to bet

10) Use of email, Facebook and other social networking ID is encouraged (for uniqueness of identity)

II) A Gaming Place (GP) has one or more gaming locations, such as one or more ...

1) towns/cities

2) provinces/states

3) countries

4) continents/regions [asia, southeast asia, america, north america, central america, south africa, middle east, europe, etc.]

or a combination of the four (4) [perhaps; 1 country, 3 states combination etc.]

III) The ACL or USER GROUP / ROLE is as follows:

1) Super Admin

1.1) Super Finance Manager

2) SubAdmin

2.1) Finance Manage

2.2) Game Manager

2.3) Account Manager (call agent)

2.4) Bettor (identified)

2.5) Bettor (anonymous)

==========================================================================

- BUDGET: $ 50 max

- I need the Entity Relations Diagram for use in my CMS development in 1 week (2 wks max)

- If you are good in PHP/CMS and we are ok with the development price, i may award the project to you.

* i would need your sky.p.e account [jetlandon] for communication

==========================================================================

Skills: Database Administration, Project Management, Software Architecture, SQL, Testing / QA

See more: diagram game, games diagram, diagram game development, erd game, erd games, diagram games system, diagram app game, erd game development, erd gaming system, diagram gaming system, diagram games, erd game project, diagram gaming, diagram game database, erd web based system, diagram mobile games, web based database games, cms diagram, diagram based games, game database diagram, game diagram, diagram joomla, web relations, web development south africa, web development in south africa

About the Employer:
( 5 reviews ) quezon, Philippines

Project ID: #4379528

Awarded to:

Reza2012

Hi I have more than nine years experience in Database Administration. I have done huge project like this. Please see PM. thanks.

$50 USD in 2 days
(2 Reviews)
2.5

3 freelancers are bidding on average $150 for this job

riskypathak

Hi I have read your requirements twice but still unable to deduce concept of load and points. I need you help to clarify more about requirements. Once i get it fully then i can create an excellent ER diagram for you More

$50 USD in 3 days
(5 Reviews)
2.2
smileitsolu

"This is not genric message we have properly read your project and intrested for that " we are a Team of professionals having good experience of various projects. I will really appreciate if you can share your query More

$350 USD in 6 days
(1 Review)
1.4