Database of list of Pakistan international cricket stadiums

A Full project on Database of list of Pakistan international cricket stadiums with conceptual and logical modeling (entities, ERD diagrams, schema diagrams and coding). Algebra as well and coding of Algebra

1. Pakistan International Cricket Stadiums Group No. 3

2. Presented By Name Sarmad Ali Muhammad Abdullah Hashaam Altaf Syed Muhammad Hanif Noman Rasool Usama Yousaf Hamza Hanif Imran Khan Roll No. 01 02 38 45 25 48 6 46

3. Preliminary Study In Preliminary Study: We are going to discuss about the cricket stadiums that are internationally declared for cricket matches in Pakistan. We collected the data from the internet that how many cricket stadiums are in Pakistan that are declared internationally for cricket matches. We came to know that there are 11 Cricket Stadiums for international matches. These cricket stadiums are located in many different cities of Pakistan but there is only one international cricket stadium in one city and a city can have only and only one cricket stadium in it.

4. Stadium’s data are as follows: National cricket stadium of Karachi that was built in 1995 and has the crowd capacity of 34,228. Gaddafi cricket Stadium of Lahore that was built in 1959 and has the crowd capacity of 27,000. Iqbal Stadium of Faisalabad that was built in 1978 and has the crowd capacity of 18,000. Jinnah Stadium of Sialkot that was built in 1920 and has a crowd capacity of 20,000. Niaz Stadium of Hyderabad that was built in 1959 and has a crowd capacity of 15,000.

5. Continued… Jinnah Stadium of Gujranwala that was built in 1989 and has the crowd capacity of 20,000. Arbab Stadium of Peshawar that was built in 1995 and has the crowd capacity of 20,000. Rawalpindi Cricket Stadium of Rawalpindi that was built in 1993 and has a crowd capacity of 25,000. Sheikhupura Cricket Stadium of Sheikhupura that was built in 1996 and has the crowd capacity of 27,000. Ayyub Cricket Stadium of Peshawar that was built in 1978 and has the crowd capacity of 32,000.

6. Continued… Multan Cricket Stadium of Multan that was built in 2001 and has the crowd capacity of 30,000 . So , After getting this we completed our Requirements about our Project Related Data.

7. ERD Diagram

8. Sql Code

9. Continued…

10. Continued…

11. Schema Diagram

12. Output of Database