Limitation exists on MySQL information storage.

There have few limitations exist on MySQL. As the database storage engine cannot have more than 64 indexes per MyISAM table. In this project, the limitation on index is not affects on application development. Cause less than 5 indexes has been created in each tale, so it doesn’t breach the limitation. In term of the key length limitation, in this project the key length under 50 bytes, this length doesn’t breach the MySQL limitation on “Maximum 1000 bytes on key length”. Even the combination key index length also under the MySQL limitation on “Maximum 16 columns pre index”, in this project the combination key index created by less than 3 columns that also not deal on that limitation.

For the table relationship, MySQL have few limitations on create table relationship. The limitations on InnoDB storage engine have this limitation:

• Maximum 1000 columns per table
• Maximum 64 TB table space per table
• Total of row length is 4GB

In this project, there are less than 50 columns in all the tables. No deal with the first limitation. In term of table space limitation, table space increasing will not over 64 TB per table at next 3 years because of data type majority used “tinyint”, “bit”, “datetime” and “char” on 8 letters fixed size or “varchar” on 100 letters, few in “double”. Roughly, the lengths will less than 3 Kbytes information space per record. The amount space requires on table will not over 64 TB at next three years. Therefore, there is no deal with the second limitation. At the last limitation, the total of row length in this project less than 3 Kbytes. I believe this length also no deal with the third limitation on InnoDB storage engine’s limitation.

Result input page is designed for Cricket Club matching result management.

Each player has their own result when they attend the match. For the next game plan preparation, the caption needs to analyze the matching result for each player and than find out the possible way to improve the result on next time. This page is provided to the administrator input the grades for each player at each match. Result can be browse for user interest on cricket match. Thus the result, the cricket caption understand what player should play attention more. Player could review the result any time they like as well as discuses the result with other players. This result will be showed at the player’s profile page as well.

A problem on keeping the matching result, Batting and Bowling result can not place in same table because of the table fields are different. Therefore, information needs categorized in two tables. The “CSUID” field will be the table relation key. The key index will be the “CSUID” plus the row number “Rowno”. Batting table design sees as Screenshot-1. Bowling table design sees as Screenshot-2.

Screenshot-1

Screenshot-2

Browse a cricket club player profile’s information.

For the player’s profile browsing, user can chose the initial letter for the name of player, than select and click the correct name of the player. The content will be showing. The page layout showed as screenshot-1. There have two parts in content page; first part is the common information about the player, including the name of the player, age, personal photo and the play role of the player in matching. Second part is the current grades that player who got at last matching. The page layout sees as the screenshot-2 showed.

Screenshot-1

Screenshot-2

A portable web application development environment been used in this project.

In term of system implementation in this project, the tools have been used on application development with uniform server suite, the core elements in development issues as the following:

1. programming langue with HTML4.0 and PHP5
2. information store based on MySQL5.0.67
3. programs will run at Apache Core 2.2.9 web server

Uniform server is a lightweight server; it included the current versions of Apache2, Perl5, PHP5, MySQL5. This uniform server suite is NO INSTALLATION REQUIRED and NO REGISTRY at all. For development purpose, it is costless because of an open source. Uniform server suit can run under Windows XP Operating System and just needs less than 10MB spaces. In addition, it can be run on simple USB driver; that mean all the development materials are portable. It is quite convenient. The final web application can be uploaded to some of the free ISP and place it there and used it.

Can administrator have a backup for the job?

In term of the job transformation or job agency, administrator can create a user for the backup. Even though just have a few days break that should have a backup take care the information management, either a temporary or the other official administrator. A limitation for adding other administrator, all the fields need to be fills in and the password also provide at the same time. The details in the request form on creating other administrator sees as the screenshot-1. The password will be encrypted keeping in database; nobody can retrieve it back if the password was forgotten. In the password rest process, the current password needs to be presented during the password change or rest. If the current password doesn’t match, the new password cannot be updated or changed. The alternative on password was forgotten is creating other account by other administrator. May be this method would be change if the sponsor disagree this solution.

Screenshot-1

Player’s state control page has designed for the administrator.

In this management page, there provided the function like add, modify and remove on player’s profile management. Browsing the players’ details just press the “edit” link than system will display all the information been saved. Create a new player profile just click the “I want add a new player” link, system will redirect to the details page. Players want to update their information that must inform the club administrator, otherwise, the information will incorrect when admin analyze the player’s playing information or contact information. In default, all club players’ account state will be inactive. Administrator can active those accounts later when it has been required. Those functions only the Administrator have it. However, others are restricted. Again all the management page accessing, administrator must login first than have it. The layout of this page sees as following Screenshot-1.

Screenshot-1

Page layout has been designed for News publishing.

For the news publishing, administrator can posts news via this function in page. News listed order by the date and time while it been posted. In term of the news management, a little bit different design compare to the comments management page, administrator can remove the news any time. The idea for this operation is some news may be out of time or the information is changed by some factors. Therefore, the news needs to be update; thus the news remove function should be in place. The page layout sees as the Screenshot-1. All news information only the administrator has the rights on news publishing. However, others are restricted.

Screenshot-1