scholarly journals Portraying the Water Crisis in Iranian Newspapers: An Approach Using Structure Query Language (SQL)

Water ◽  
2021 ◽  
Vol 13 (6) ◽  
pp. 838
Author(s):  
Farshad Amiraslani ◽  
Deirdre Dragovich
Keyword(s):  
Rural Areas ◽  
Industrial Development ◽  
Water Distribution ◽  
Query Language ◽  
Public Awareness ◽  
Local Level ◽  
Structure Query Language ◽  
Water Crisis ◽  
Dry Climates ◽  
Structure Query

Water is a valuable resource for which demand often exceeds supply in dry climates. Managing limited water resources becomes increasingly difficult in circumstances of recurring drought, rising populations, rapid urbanisation, industrial development, and financial constraints, such as occur in Iran. Newspapers both report on and influence people’s understanding of water-related issues. An analysis was undertaken of two major Iranian daily newspapers over a 7-year period. Structure Query Language (SQL) was employed to identify relationships among a total of 1275 records/fields which were extracted from 84 water-related news items. They were analysed for message, contributor, spatiality and allocated space. Of the water-related items, wetlands comprised 33% (class), public awareness 54% (message), local level 56% (spatiality), and authorities 53% (contributor). Space allocation on each page was mostly <40% (94% of items). Four examples were highlighted of ambitious engineering projects adopted in response to water distribution issues. It is concluded that the general lack of educating messages about water use efficiency in rural areas and water consumption in cities does not assist in developing positive water-saving local behaviours. Newspapers could be a useful tool in a broader strategy for addressing and managing the demand side of the water crisis in Iran.

scholarly journals Wildlife and Newspaper Reporting in Iran: A Data Analysis Approach

Animals ◽  
2021 ◽  
Vol 11 (6) ◽  
pp. 1487
Author(s):  
Farshad Amiraslani ◽  
Deirdre Dragovich
Keyword(s):  
Environmental Sustainability ◽  
Wildlife Conservation ◽  
Query Language ◽  
Public Awareness ◽  
Structure Query Language ◽  
Space Structure ◽  
Sources Of Information ◽  
Daily Press ◽  
Structure Query ◽  
Environmental News

Human response to wildlife management is widespread, encompassing both human–wildlife conflicts and wildlife conservation, in different places and at different times. As people become increasingly aware of the importance of wildlife to biological and environmental sustainability, newspapers can be important sources of information, especially in developing countries, such as Iran. Three major Iranian daily newspapers were analysed for news items related to wildlife. Over the 7-year study period, 434 articles presented environmental news, of which 61 items referred to wildlife. Each wildlife item was recorded in terms of message, contributor, spatiality, and allocated space. Structure query language (SQL) was used to analyse relationships between the 915 fields/entries. Wildlife items were characterised by public awareness (51%), columnist contributions (46%), and local spatiality (43%). Most items (82%) were allocated space of less than half a page. Of the categorised topics, those of combined endangered land (30%) and marine (5%) species exceeded items on global conservation (24%). Results highlighted the minimal number and small space devoted to wildlife news items and their concentrations (67%) in one of the three sampled newspapers. Although nature has historically been important in Iranian culture, current attitudes to wildlife, as reflected in newspaper coverage, do not seem to mirror these traditional perspectives. Given the widespread distribution of newspapers and their roles (i.e., as sources of information and opinion influencers), global wildlife conservation issues would benefit from much greater coverage in the daily press.

Distributed Geographic Structure Query Language-DGSQL

2015 ◽  
Vol 9 (2) ◽  
pp. 328-336 ◽  
Author(s):  
Liang Wu ◽  
Zhanlong Chen ◽  
Xincai Wu ◽  
Zhong Xie
Keyword(s):  
Query Language ◽  
Structure Query Language ◽  
Geographic Structure ◽  
Structure Query

Detection of structure query language injection vulnerability in web driven database application

2020 ◽  
Author(s):  
Muhammad Saidu Aliero ◽  
Kashif Naseer Qureshi ◽  
Muhammad Fermi Pasha ◽  
Awais Ahmad ◽  
Gwanggil Jeon
Keyword(s):  
Query Language ◽  
Structure Query Language ◽  
Database Application ◽  
Structure Query

Communication Strategies of Government Agencies for Mass Awareness in Rural Areas of Punjab: A study based on Health Department of District Amritsar, Punjab

2015 ◽  
Vol 9 (1and2) ◽  
Author(s):  
Arif Nazir
Keyword(s):  
New Media ◽  
Rural Areas ◽  
Industrial Development ◽  
Information Dissemination ◽  
Public Awareness ◽  
Communication Strategies ◽  
Health Department ◽  
Development Planning ◽  
Family Welfare ◽  
Media Technology

Rural development has always been a core issue for the development planners in order to take the country on the path of socio-economic development. Mahatma Gandhi rightly said that the development in true sense is not possible unless villages of the country are developed. In the initial years of development planning stress was laid on agriculture and industrial development but with the passage of time, focus shifted to other equally important areas like Healthcare, Education, Employment and Sanitation programmes. Communicating with the rural masses was always a point of discussion. Earlier, where interpersonal means and folk media were the only means of reaching people but with the advent of print and electronic media, there was a paradigm shift in communication strategies also. Presently there are number of communication strategies which are being employed by various departments in order to reach people and create awareness. The present study would try to find out the communication strategies of Department of Health and Family Welfare of District Amritsar, Punjab. The study would also try to find out the media usage of the department for public awareness. Besides, it would also be helpful to find out the role (if any) of new media technology for information dissemination in rural areas.

scholarly journals PERANCANGAN APLIKASI POINT OF SALE BERBASIS WEB PADA TOKO PROJECT SALFA TARAKAN

Sebatik ◽  
2021 ◽  
Vol 25 (2) ◽  
pp. 624-631
Author(s):  
Suprianto Suprianto ◽  
Muhammad Fadlan ◽  
Denis Prayogi
Keyword(s):  
Query Language ◽  
Structure Query Language ◽  
Point Of Sale ◽  
Structure Query

Aplikasi Point of Sale yang biasa disebut POS merupakan aplikasi yang dapat membantu proses transaksi penjualan seperti pada toko yang umumnya terjadi kegiatan jual beli. Toko Project Salfa yang bergerak di bidang penjualan dan penyedia jasa saat ini masih menggunakan pencatatan manual di setiap transaksi sehingga menyulitkan pemilik ketika akan melakukan rekapitulasi terkait laporan penjualan maupun pemasukan. Penelitian ini membuat aplikasi POS berdasarkan kebutuhan dari pemilik toko dengan menggunakan model Waterfall sebagai perancangan dan pengembangan aplikasinya. Dari penerapan model Waterfall, dapat dihasilkan aplikasi yang memiliki fitur-fitur yang sesuai dengan kebutuhan pemilik toko seperti dapat melakukan pendataan barang, member, seller, transaksi penjualan, pengeluaran serta laporan-laporan dari transaksi tersebut yang dicatat dalam bentuk kas di aplikasi POS. aplikasi dibuat berbasis web agar memudahkan pengembangan ke depannya dengan menggunakan bahasa pemrograman PHP (Hypertext Pre-processor) dan database berbasis jaringan seperti MySQL (My Structure Query Language).

Book Subscription System Design in High School Based on Web Technology

2012 ◽  
Vol 220-223 ◽  
pp. 2641-2644
Author(s):  
Shu Lan Gao
Keyword(s):  
High School ◽  
High Education ◽  
System Design ◽  
Query Language ◽  
Database System ◽  
Structure Query Language ◽  
School Based ◽  
Information Center ◽  
Structure Query ◽  
Education In China

Library is the information center of high school. With the development of high education in China, the construction of library is of great importance in high school. Since the knowledge of all kinds of subjects increase dramatically in nowadays, the book subscription has become a heavy task in the library. The recent manual works for book subscription in many schools have not met the requirements from different departments of them. Hence, a book subscription system is designed based on Web. In this system, the active sever page technology is used, together with the structure query language sever database system.

Sign in / Sign up

Export Citation Format

Share Document