GRADE 12 : PRACTICAL 21

 GRADE 12 : PRACTICAL 21

'''WAP using Python-MySQL connectivity to connect to the Database DB21 that contains Table ACTIVITY as shown below : 

PS. - THE BELOW SHOULD BE CREATED BY YOU IN MYSQL & CAN TABLE CAN BE STUCK ALONGSIDE OR BELOW , INSTEAD OF WRITING IT OUT

TABLE : ACTIVITY

ACODE| ANAME         | STADIUM     | NO | PRIZE | SCHEDULE_DATE  

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

1001  | RELAY 100M    | STAR ANNEX  | 16 | 10000 | 2004-01-23

1002  | HIGH JUMP     | STAR ANNEX  | 10 | 12000 | 2003-12-12

1003  | SHOTPUT       | SUPER POWER | 12 | 8000  | 2004-02-14

1005  | LONG JUMP     | STAR ANNEX  | 12 | 9000  | 2004-01-01

1008  | DISCUS THROW  | SUPER POWER | 10 | 15000 | 2004-03-19

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

Your task is to : 

1.DISPLAY THE ACTIVITIES THAT ARE SCHEDULED AT A STADIUM ACCEPTED BY THE USER. ALSO DISPLAY TOTAL NUMBER OF ACTIVITIES AT THIS STADIUM

2.INSERT A RECORD INTO THE TABLE

3.UPDATE NO. OF PARTICIPANTS AFTER ACCEPTING THE ACTIVITY NAME

4.DELETE DATA AFTER ACCEPTING ACTIVITY CODE FROM USER

- '''