ROBOT.LK


https://robot.lk/

Sports MIS System

https://robot.lk/viewtopic.php?f=100&t=3377

Page 1 of 1

Sports MIS System

Posted: Wed May 30, 2012 10:33 pm
by DasunPrasanga
I want to create a application for Annual Sports meets of School to manage all data & final reports for houses.

For that I want to know.
What are the database tables and attributes ??

This application must include....
1) Student Name
2) House Name
3) Events
4) Age Category ex: Under 19, Under 17....
5) Score Point for Each Event
6) Score Point for winners Ex: 1st - 10 points , 2nd - 8 points..........

Please help me, Because this is my first application for school project!!!

??????? ???????? ?? ?? ????? ??? ??????? ???? manage ????? ?????? application ???? ?????? Database/ Tables ??? ????? ????? ??????? ????? ??....
???? ?? ??? ????? ??????? ???? ?? ???

??? ??????? ?????? ?????? ??? ?? ???? ??? ???????? ???????? ????? ?????? database tables- attibutes ????....


ex:- Student Table

Student_ID | Student_Name | Student_Gender | Student_House

Re: Sports MIS System

Posted: Thu May 31, 2012 5:55 am
by Saman
?????,
Database ???? subject ?? ?????? ???????? ????? ???? ????. ??? ????? ?????????? ????????? ??????? ???? subject ????? ??????. ?????? ?? Subject ?? ?????? ????. Database application ???? ????? ???????? ER diagrams ????? ??????? 1st, 2nd, 3rd order normalisation ???? ?? ????? table structure ?? ??????? ???.

??? application ???? ??? ?? ????? ????? ????? ????? ??????? ???????. ????? ??? ?? ???? application ?? ??? ??? purpose ???? ?????? ???? ?? ??????? ???.
  1. ??? ???? ????? ???? ?????? ????? ?????????? ????????? ????????
    1. ?????? ??? ???, ???? ?????????? ?????? ???????????? ?????????
    2. ?????? ??? ???, ?? ??????? ???????
  2. ???? ??????? ????? ?????? ??? ???? ??????
  3. ????? ??????? ???? ????? ?????? ????????
?? ?????? ??? ??????? ????, ?? ??? ???? ?????? ???????.

Re: Sports MIS System

Posted: Thu May 31, 2012 5:56 am
by SevenZero
ROBOT.LK ???? ????? ???????? ????? ??????? ??? ???? ???????. ??? ??? ??? project ???? ???? ???? ???? ????? ??????????? ??????? ????? ???????. ? ????? ???????? ????? ?? ??????. ????? ?? ??? design ???? ???????? ??????? ?????????? ????? ??????? ?????? ??? ?????.

Re: Sports MIS System

Posted: Thu May 31, 2012 9:01 am
by DasunPrasanga
Saman wrote:?????,
Database ???? subject ?? ?????? ???????? ????? ???? ????. ??? ????? ?????????? ????????? ??????? ???? subject ????? ??????. ?????? ?? Subject ?? ?????? ????. Database application ???? ????? ???????? ER diagrams ????? ??????? 1st, 2nd, 3rd order normalisation ???? ?? ????? table structure ?? ??????? ???.

??? application ???? ??? ?? ????? ????? ????? ????? ??????? ???????. ????? ??? ?? ???? application ?? ??? ??? purpose ???? ?????? ???? ?? ??????? ???.
  1. ??? ???? ????? ???? ?????? ????? ?????????? ????????? ????????
    1. ?????? ??? ???, ???? ?????????? ?????? ???????????? ?????????
    2. ?????? ??? ???, ?? ??????? ???????
  2. ???? ??????? ????? ?????? ??? ???? ??????
  3. ????? ??????? ???? ????? ?????? ????????
?? ?????? ??? ??????? ????, ?? ??? ???? ?????? ???????.
??? application ?? ?? ????? ?? ????? ?????? ??? ?? ??? ????? ???? ?? ????.
??? ????? ???????? ????? ?????? ???????????? ?????? !
????? ???? ???? ????? ?????? !
????? ??? ?????? ???????????? ?????? !

Re: Sports MIS System

Posted: Thu May 31, 2012 9:06 am
by DasunPrasanga
SevenZero wrote:ROBOT.LK ???? ????? ???????? ????? ??????? ??? ???? ???????. ??? ??? ??? project ???? ???? ???? ???? ????? ??????????? ??????? ????? ???????. ? ????? ???????? ????? ?? ??????. ????? ?? ??? design ???? ???????? ??????? ?????????? ????? ??????? ?????? ??? ?????.
??? ???? ?????? ??????????? ?????????? ??? ??? ??? ?? ??????? !!!

?? ?????? ????? ???? database tables ??? ????? ???? ?? ????? !

??? ??? ????? ???? tables Design ???????? ????? ???????? !

Re: Sports MIS System

Posted: Thu May 31, 2012 8:15 pm
by Saman
House

Code: Select all

|  House_ID(PK) |  House_Name  |

Student

Code: Select all

|  Student_ID(PK)  | Student_Name |  Date_of_Birth |  House_ID  |
Group

Code: Select all

|  Group_ID(PK)   |   Description  |
Ex:

Code: Select all

|     0001        |   100x4 relay  |
Student_Group

Code: Select all

|  Group_ID(PK) | Student_ID(PK) |
Ex: 4 students are running on the relay

Code: Select all

|     0001      |    00001       |
|     0001      |    00002       |
|     0001      |    00003       |
|     0001      |    00004       |
Event

Code: Select all

| Event_ID(PK) | Event_Name         | Individual_or_Group | Age_Limit |
Ex:

Code: Select all

| 00001        | Under 17 100m race |         0           |    17     |

Participant

Code: Select all

|  Participant_ID  |  Event_ID  |  Student_or_Group_ID  |
Position

Code: Select all

|  Position_ID(PK)  |   Description |   Score  |
Ex:

Code: Select all

|      00001        |       1st     |    30    |
|      00002        |       2st     |    20    |
|      00003        |       3st     |    10    |
|      00004        |     Winner    |    50    |
Event_Position

Code: Select all

| Event_Position_ID | Event_ID(PK) | Position_ID(PK) |
Ex:

Code: Select all

|   0001            |    00001     |     00001       |
|   0002            |    00001     |     00002       |
|   0003            |    00001     |     00003       |
|   0004            |    00002     |     00001       |
|   0005            |    00002     |     00002       |
|   0006            |    00002     |     00003       |
|   0007            |    00003     |     00004       |

Record

Code: Select all

|   Date   |  Event_Position_ID  | Participant_ID  |
I guess all the tables are now 3rd order normalised and you can generate reports using SELECT queries/views.

Re: Sports MIS System

Posted: Thu May 31, 2012 9:13 pm
by DasunPrasanga
Saman wrote:House

Code: Select all

|  House_ID(PK) |  House_Name  |

Student

Code: Select all

|  Student_ID(PK)  | Student_Name |  Date_of_Birth |  House_ID  |
Group

Code: Select all

|  Group_ID(PK)   |   Description  |
Ex:

Code: Select all

|     0001        |   100x4 relay  |
Student_Group

Code: Select all

|  Group_ID(PK) | Student_ID(PK) |
Ex: 4 students are running on the relay

Code: Select all

|     0001      |    00001       |
|     0001      |    00002       |
|     0001      |    00003       |
|     0001      |    00004       |
Event

Code: Select all

| Event_ID(PK) | Event_Name         | Individual_or_Group | Age_Limit |
Ex:

Code: Select all

| 00001        | Under 17 100m race |         0           |    17     |

Participant

Code: Select all

|  Participant_ID  |  Event_ID  |  Student_or_Group_ID  |
Position

Code: Select all

|  Position_ID(PK)  |   Description |   Score  |
Ex:

Code: Select all

|      00001        |       1st     |    30    |
|      00002        |       2st     |    20    |
|      00003        |       3st     |    10    |
|      00004        |     Winner    |    50    |
Event_Position

Code: Select all

| Event_Position_ID | Event_ID(PK) | Position_ID(PK) |
Ex:

Code: Select all

|   0001            |    00001     |     00001       |
|   0002            |    00001     |     00002       |
|   0003            |    00001     |     00003       |
|   0004            |    00002     |     00001       |
|   0005            |    00002     |     00002       |
|   0006            |    00002     |     00003       |
|   0007            |    00003     |     00004       |

Record

Code: Select all

|   Date   |  Event_Position_ID  | Participant_ID  |
I guess all the tables are now 3rd order normalised and you can generate reports using SELECT queries/views.
?? ?? ????? ???????? ??? ????????? ?????... :P ?? ?????? ????? ??? ???? !!!


?? ??? ???? ???? ?????? ?

?????
1) 13 ?? ??? , 15 ?? ??? , 17 ?? ??? , 19 ?? ??? , 21 ?? ??? ??? ??? ??? tables ?? ???? ??? ?

2) 1st Place – 10 points , 2nd Place – 8 points , 3rd Place – 6 points , 4th Place – 4 points, 5th Place -2 Points, 6th Place – 1 Point ???? ??? events ????? ? ? ????p?? ?? ????? ????? ??? ????? ??.
?? ? ? ????????? ????? ????????? ?? points ???????? ???? …
….. ????? ??? 1, 2,3 ????? ???????? !!

???? ??? !

3) ?? ????? ?? application ??? ?????a Tables ?

4) Student_Group ??????? relay ??? ????? ???? ??? ??? ?
5) Event Table ??? Individual_or_Group ??? ???? records ?? ?????? ?????? ?

?????? ???? ???? ?????? ???? ???????..

Re: Sports MIS System

Posted: Thu May 31, 2012 9:41 pm
by Saman
1. ????. ??? ?? Event table ?????? ?????. ??? ???? ????? ?????? ????? ??????.

2. ???. meet ?? ??? ???? total ?? ??????? ???????

3. ??? application ?? ?????? ????? ?? ??? ??? add ??????

4. ???. ?????? ??? ?? team ??, ?? ???? team ??, cricket/football ??? teams ???? ???? ???????

5. 0 - Individual. 1 - Group
?????? ???? ???? ?????? ???? ???????..
ROBOT.LK.org ???????? ???? ??? ??? ???? ;)
??? ????? ????? try ???? ?????? ???? ???? ?????? ??? ??? ??? support ?????? ????.
All times are UTC+05:30
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited