Showing posts with label Short Notes. Show all posts
Showing posts with label Short Notes. Show all posts

Friday, 4 October 2013

INDUSTRIAL DEVELOPMENT AND ECOLOGICAL ISSUES PDF

INDUSTRIAL DEVELOPMENT AND ECOLOGICAL ISSUES
INTRUDUCTION
Nowadays a lot of attraction is paid to ecological situation in the world. And its reasons are well understood. The reasons to speak about it are not necessary to be named. Everybody knows them quite well. The human progress together with the development of technology is causing a great influence of the global ecosystem, changing it forever.

There are not that many virgin lands on the earth where people can definitely say how that areas had looked before, because the influence of human on world system of nature has changed many places to no possibility of being recognized:  “These unprecedented rates of growth, which could have alarming effects on the environment and the life support system of the planet, have renewed the debate about the future prospects for human societies.

The purpose of industrial development of any region is to provide opportunities of better living and employment to the people. While industrial development almost inevitably creates more employment in the region, the possibilities of adverse effects on the environment also increased if these adverse effects are not properly contained or reduced to minimum. Thus there occurs a situation in which the material goods increase but the quality of life deteriorates. In the past, environmental aspects of industrial developments were usually not taken into account seriously, as it was believed that this was almost inevitable and almost necessary for the economic development. Environmental movement, for all purpose, had its beginning in 1972, the year of the Stockholm Conference. After Stockholm Conference of 1972 even the erstwhile underdeveloped countries have realized the environmental degradation can be disproportionately more than economic development unless suitable safeguards are not provided from the beginning. It has also been felt that the effects of pollution in all its aspects may not remain limited to the boundaries of developed and developing nations. The hazards of Green House effects and the depletion/disruption of ozone layer of the world atmosphere have become more real than just postulations. In India, our environmental thinking took its cue from the developed countries and perceived the preservation of the threatened species - both flora and fauna. Later two areas related to prevention of any further degradation and depletion of basic natural resources and life support system of land, water and vegetation were identified. The need to preserve the country’s production base and to combat industrial pollution and insanitation in the interest of public health has been felt. Institutional arrangements such as National Committee for environmental planning and coordination was set up in 1972 which was followed a little later by the creation of Central Pollution Control Board.

Environmental degradation affects developing countries more fundamentally, than it does the developed world. It is universally recognized, in developing countries, that, while economic development is an essential process to erase poverty and hunger, at the same time, it is equally important, to protect the environment from pollution at regional as well as national and
global levels. As such, effective measures are called for at all levels of production, to combat pollution and to save the environment, from degradation. In India, our efforts to provide to a vast and growing population, with food, and comforts, could be sustained in the long run, only if we protect and preserve our environment, from further degradation

INDUSTRIAL REVOLUTION
The Industrial Revolution was a period from the 18th to the 19th century where major changes in agriculture, manufacturing, mining, and transport had a profound effect on the socioeconomic and cultural conditions starting in the United Kingdom, then subsequently spreading throughout Europe, North America, and eventually the world. The onset of the Industrial Revolution marked a major turning point in human history; almost every aspect of daily life was eventually influenced in some way.
  • Textiles – Cotton spinning using Richard Arkwright's water frame, James Hargreaves's Spinning Jenny, and Samuel Crompton's Spinning Mule (a combination of the Spinning Jenny and the Water Frame). This was patented in 1769 and so came out of patent in 1783. The end of the patent was rapidly followed by the erection of many cotton mills. Similar technology was subsequently applied to spinning worsted yarn for various textiles and flax for linen.
  • Steam power – The improved steam engine invented by James Watt and patented in 1775 was initially mainly used for pumping out mines, but from the 1780s was applied to power machines. This enabled rapid development of efficient semi-automated factories on a previously unimaginable scale in places where waterpower was not available.
  • Iron founding – In the Iron industry, coke was finally applied to all stages of iron smelting, replacing charcoal. This had been achieved much earlier for lead and copper as well as for producing pig iron in a blast furnace, but the second stage in the production of bar iron depended on the use of potting and stamping (for which a patent expired in 1786) or puddling (patented by Henry Cort in 1783 and 1784).
The application of steam power to the industrial processes of printing supported a massive expansion of newspaper and popular book publishing, which reinforced rising literacy and demands for mass political participation.

INDUSTRIAL POLLUTION
Industrial : About 57,000 polluting industries in India generate about 13,468 mld of wastewater out of which nearly 60% (generated from large & medium industries) is treated
Air Pollution
Industrialization and urbanization have resulted in a profound deterioration of India's air quality. Of the 3 million premature deaths in the world that occur each year due to outdoor and indoor air pollution, the highest number are assessed to occur in India. According to the World Health Organization, the capital city of New Delhi is one of the top ten most polluted cities in the world. Surveys indicate that in New Delhi the incidence of respiratory diseases due to air pollution is about 12 times the national average.
According to another study, while India's gross domestic product has increased 2.5 times over the past two decades, vehicular pollution has increased eight times, while pollution from industries has quadrupled. Sources of air pollution, India's most severe environmental problem, come in several forms, including vehicular emissions and untreated industrial smoke. Apart from rapid industrialization, urbanization has resulted in the emergence of industrial centers without a corresponding growth in civic amenities and pollution control mechanisms.
Regulatory reforms aimed at improving the air pollution problem in cities such as New Delhi have been quite difficult to implement, however. For example, India's Supreme Court recently lifted a ruling that it imposed two years ago which required all public transport vehicles in New Delhi to switch to compressed natural gas (CNG) engines by April 1, 2001. This ruling, however, led to the disappearance of some 15,000 taxis and 10,000 buses from the city, creating public protests, riots, and widespread "commuter chaos." The court was similarly unsuccessful in 2000, when it attempted to ban all public vehicles that were more than 15 years old and ordered the introduction of unleaded gasoline and CNG. India's high concentration of pollution is not due to a lack of effort in building a sound environmental legal regime, but rather to a lack of enforcement at the local level. Efforts are currently underway to change this as new specifications are being adopted for auto emissions, which currently account for approximately 70% of air pollution. In the absence of coordinated government efforts, including stricter enforcement, this figure is likely to rise in the coming years due to the sheer increase in vehicle ownership.

Waste and Water Pollution
Water pollution has many sources. The most polluting of them are the city sewage and industrial waste discharged into the rivers. The facilities to treat waste water are not adequate in any city in India. Presently, only about 10% of the waste water generated is treated; the rest is discharged as it is into our water bodies. Due to this, pollutants enter groundwater, rivers, and other water bodies. Such water, which ultimately ends up in our households, is often highly contaminated and carries disease-causing microbes. Agricultural run-off, or the water from the fields that drains into rivers, is another major water pollutant as it contains fertilizers and pesticides.
During the last fifty years, the number of industries in India has grown rapidly. But water pollution is concentrated within a few subsectors, mainly in the form of toxic wastes and organic pollutants. Out of this a large portion can be traced to the processing of industrial chemicals and to the food products industry. In fact, a number of large- and medium-sized industries in the region covered by the Ganga Action Plan do not have adequate effluent treatment facilities. Most of these defaulting industries are sugar mills, distilleries, leather processing industries, and thermal power stations. Most major industries have treatment facilities for industrial effluents. But this is not the case with small-scale industries, which cannot afford enormous investments in pollution control equipment as their profit margin is very slender.

Chemical Pollution
As rapidly developing countries such as India industrialize, the dangers to local communities from pollution are often overlooked until there is a major disaster such as occurred in Bhopal.
The effects of chemical pollution is being rapidly felt across India. It has found that the incidence of diseases related to nervous, circulatory, respiratory, digestive and endocrine systems was one to four times higher in heavily industrialized areas as compared to unindustrialized areas. Many cases of congenital deformity and chromosomal abnormalities were also reported, in addition to 11 cases of different kinds of cancer. Skin disorders are also rampant.
The wave of industrialization that began in the late 1970s has changed the complexion of India's once placid landscape. Lakes, streams, as well as the groundwater are laced with toxic heavy metals and chemicals, as proved by several studies by government agencies and research institutions including the National Geophysical Research Laboratory.

SOIL POLLUTION
Acid rain is rain or any other form of precipitation that is unusually acidic, i.e. elevated levels of hydrogen ions (low pH). It can have harmful effects on plants, aquatic animals, and infrastructure through the process of wet deposition. Acid rain is caused by emissions of compounds of ammonium, carbon, nitrogen, and sulfur which react with the water molecules in the atmosphere to produce acids. Governments have made efforts since the 1970s to reduce the production of sulfuric oxides into the Earth's atmosphere with positive results. However, it can also be caused naturally by the splitting of nitrogen compounds by the energy produced by lightning strikes, or the release of sulfur dioxide into the atmosphere by volcano eruptions.

INDUSTRIAL WASTES
Toxic waste is waste material that can cause death or injury to living creatures. It can be spread quite easily and can contaminate lakes and rivers. The term is often used interchangeably with “hazardous waste”, or discarded material that can pose a long-term risk to health or environment.
As with most pollution problems, toxic waste began to be a significant issue during the industrial revolution. It usually is the product of industry or commerce, but comes also from residential use (e.g. cleaning products, cosmetics, lawn care products), agriculture (e.g. chemical fertilizers, pesticides), the military (nuclear weapons testing, chemical warfare), medical facilities (e.g. pharmaceuticals), radioactive sources, and light industry, such as dry cleaning establishments.

Health effects

Toxic waste
Toxic wastes often contain carcinogens, and exposure to these by some route, such as leakage or evaporation from the storage, causes cancer to appear at increased frequency in exposed individuals. For example, a cluster of the rare blood cancer polycythemia vera was found around a toxic waste dump site in northeast Pennsylvania in 2008.

MEASURES
  • Turn off Sound pollution 
  • Keep the volume of your T.V., music system low. 
  • Honk the car horn sparingly. 
  • Discourage use of loudspeakers. 
  • Avoid the use of band, crackers in wedding processions. 
  • Get all to practise laws regarding Sound pollution.
Vaporise Air pollution 
  • Keep smoke emission from homes, factories, vehicles to minimum. 
  • Avoid use of firecrackers. 
  • Dispose garbage in bins, do not bum it. 
  • Use spittoons or flowing drains for spitting. 
  • Get all to practice laws regarding Air pollution. 
Purify Water pollution 
  • Never dump garbage near communal taps, wells and other water bodies. 
  • Do not tinker with public water pipes. 
  • Immerse holy idols in authorized places. 
  • Get all to practice laws regarding Water pollution. 
Dispose off Chemical pollution
  • Prefer organic manure to chemical fertilizers, paper to polythene, cotton, jute to polyester. 
  • Dispose polythene bags through proper channel. 
  • Plant more trees and vegetation. 
  • Get all to practise laws regarding Chemical pollution.
CONCLUSION

Even though the industrial development changes our life style and culture it is important to control pollution caused by the industries by whatever means and to save the environment from pollution.

Friday, 30 August 2013

STRUCTURED QUERY LANGUAGE | DBMS | DQL,DDL,DML,DCL

SQL, which is an abbreviation for Structured Query Language, is a language used to request data from a database, to add, update, or remove data within a database, or to manipulate the metadata of the database.
SQL is generally pronounced as the three letters in the name, e.g. ess-cue-ell, or in some people's usage, as the word sequel.
SQL is a declarative language in which the expected result or operation is given without the specific details about how to accomplish the task. The steps required to execute SQL statements are handled transparently by the SQL database. Sometimes SQL is characterized as non-procedural because procedural languages generally require the details of the operations to be specified, such as opening and closing tables, loading and searching indexes, or flushing buffers and writing data to file systems. Therefore, SQL is considered to be designed at a higher conceptual level of operation than procedural languages because the lower level logical and physical operations aren't specified and are determined by the SQL engine or server process that executes it.
Instructions are given in the form of statements, consisting of a specific SQL statement and additional parameters and operands that apply to that statement. SQL statements and their modifiers are based upon official SQL standards and certain extensions to that each database provider implements. Commonly used statements are grouped into the following categories:

Data Definition Language (DDL)
  • CREATE
  • ALTER
  • DROP
  • TRUNCATE
CREATE :
Used to create a new table, a view of a table, or other object in database.
Example : create table test (id int null, name varchar(20));

Constraints:
Constraints are the rules enforced on data columns on table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the database.
Constraints could be column level or table level. Column level constraints are applied only to one column where as table level constraints are applied to the whole table.
Domain integrity constraint :Domain integrity Constraints are the rules enforced on a particular row of a table.
Not Null Constraint : Ensures that a column cannot have NULL value.
Default Constraint : Provides a default value for a column when none is specified.
Check Constraint : The CHECK constraint ensures that all values in a column satisfy certain conditions.
Entity integrity constraint :Constraints are the rules enforced on data columns on table

  • Unique Constraint : Ensures that all values in a column are different. 
  • Primary Key : Uniquely identified each rows/records in a database table 
Referential integrity constraint : It relates two or more tables
Foreign Key: Uniquely identified a rows/records in any another database table.

ALTER :

ALTER - Used to modify an existing database object, such as a table.
Example : Alter table test add d_id int;

DROP :

DROP - Used to delete an entire table, a view of a table or other object in the database.the structure remains 
Example : Drop table test;

TRUNCATE :

TRUNCATE - Used to delete an entire table, a view of a table or other object in the database with structure 
Example : truncate table test;

Data Manipulation Language (DML)

  • INSERT
  • UPDATE
  • DELETE
INSERT :
INSERT - Used to create a record. 
Example :
  • To insert values for every columns 
Insert into test values(1,’cse’,1)
  • To insert values for selected columns 
Insert into test(id,name) values(2,’it’); 

UPDATE :
UPDATE - Used to change certain records.
Example :
  • To Update with particular condition 
update test set id = 3 where id =2;
  • To update every rows of the table without condition 
update test set d_id = d_id * 1 

DELETE :
DELETE - Used to delete certain records
Example :
  • To delete a particular row 
Delete from test where d_id =1;
  • To delete every data of a table 
Delete from test

Data Control Language (DCL)


GRANT - Used to give a privilege to someone. 

REVOKE - Used to take back privileges granted to someone.


Data Query Language (DQL)

SELECT - Used to retrieve certain records from one or more tables.

Monday, 5 August 2013

Client/Server database

The client-server model consists of three parts,they are as follows,
  1. Client
  2. Server
  3. Network
  1. Client : The client is the machine running the front-end applications. The client has no direct data access responsibilities. It simply requests processes from the server and displays data managed by the server.
  2. Server : The server is the machine that runs the DBMS software and handles the functions required for concurrent, shared data access. The server receives and processes SQL and other query statements originating from client applications.
  3. Network : The network enables remote data access through client-server and server-to-server communication.
Advantages:
  • It enables wider access to existing databases
  • Increased performance
  • Hardware costs may be reduces
  • Communication costs are reduces
  • Increased consistency

Wednesday, 3 July 2013

INPUT/OUTPUT DEVICES AND PROCESSORS

INPUT/OUTPUT DEVICES OR I/O DEVICES:
Input/output devices enables communication between user and the software.
INPUT DEVICE:
Any peripheral device that provides input to the computer is called as Input device.Input devices are used to provide information to the computer.
Some of the input devices are,
  • Microphone  
  • Keyboard
  • scanner 
  • Web camera
OUTPUT DEVICE:
Any peripheral device that receives output from the computer is called as output device.Output devices are used to display or receive data's from the computer.
Some of the output devices are,
  • Monitors (LCD,LED,CRT etc..)
  • Projector
  • Speaker
  • Printer 
INPUT/OUTPUT PROCESSORS OR I/O PROCESSORS:
The I/O processor is a type of processor that is separate from the main processor of a computer.This i/o processor is designed only to handle input and output processes of the computer.
INPUT/OUTPUT INSTRUCTIONS:
An i/o instructions makes the transfer of data between peripheral device's and main memory.And this input/output instructions enables Central Processing Unit CPU to control the peripheral devices that has connected to it.
INSTRUCTION FORMAT:
OPCODE ADDRESS DATA
Some of the I/O instructions are,
  1. START IO 
  2. HALT IO 
  3. TEST IO
The I/O instructions executed by the Input Output processors are called as Channel Comment Words CCWS.
TYPES OF CCWS:
  1. Data Transfer instructions
  2. Branch Instructions
  3. IO device and control Instructions

Monday, 1 July 2013

DEFINE TRIGGERS | WHAT IS MEANT BY TRIGGER IN DBMS

Triggers:

A Trigger defines an action that the database should take when some database related event occurs.The execution of triggers is transparent to the users.A trigger may cause another trigger to be invoked.A mutating trigger is a trigger that triggers itself.

Types Of Triggers:

The triggers types are defined by the type of triggering transactions and by the level at which the trigger is executed.
  • Row-level triggers
  • Statement-level triggers
  • Before and after triggers
Row-level triggers:
Row-level triggers,trigger once for each row in a transaction.This trigger can be created by using the for each row clause trigger comment.
Statement-level triggers:
Statement-level triggers execute once in a transaction.It can be created by using create trigger comment.It is one of the default type of triggers.
Before and after triggers:
Since the events that executes triggers are database transactions,triggers can be executed immediatly before or after INSERT,UPDATE and DELETE comments.

Purpose of Triggers:
  • To generate data automatically
  • To enforce complex integrity constrains
  • To customize complex security authorizations
  • To maintain replicate tables
  • To audit data modifications

Monday, 17 June 2013

What are the Advantages and Disadvantages of DBMS

Define Data Base Management System or What is meant by DBMS ?

  • The collection of interrelated data's and the set of programs to access those data's are called as  Database management system.
  • or
  • The DBMS or database system consist of a collection of interrelated & persistent data and a set of application programs used to access,update and manage those data's. 
  • The collection of data is called as data base.Databases are usually designed to store & manage large amount of informations or data's.
  • The goal of DBMS is to provide an environment for both retrieving information from the data base and storing information into the database.
Advantages of  DBMS | Data Base Management System : 
  • Control of data redundancy
  • Data consistency
  • Sharing of data
  • Improved data integrity
  • Improved security
  • Enforcement of standards
  • Economy of scale
  • Improved data accessibility and responsiveness
  • Increased productivity
  • Increased concurrency
  • Improved backup and recovery services
These are some of the advantages of database management system or database system.

Disadvantages of  DBMS | Data Base Management System :
  • Complexity
  • Size
  • Cost of dbms is high
  • Additional hardware costs
  • Performance
  • Higher impact of failure
These are some of the disadvantages of database management system or database system.

Disadvantages of file system over DBMS :
  • Data redundancy and inconsistency
  • Difficulty in accessing data
  • Data isolation
  • Integrity Problems
  • Atomicity Problems
  • Concurrent - access anomalies
  • Security Problems 
These are some of the disadvantages of file system over database management system or database system.
--------------------------------------------------------------------------------------------------------------

Thursday, 13 June 2013

What are the types of Indexes in dbms

INDEX STRUCTURES FOR FILES :

TYPES OF INDEXES :

Different types of single-level ordered indexes are,
  • Primary index
  • Secondary index
  • Clustering index

Primary Index : 

  • Primary index is an ordered file whose records are of fixed length with two fields.The first field is of the same data type as the ordering key field called as Primary Key of the data file and the second field is a pointer to a disk block.
  • There is one index entry in the index file for eavh block in th data file.Each index entry has the value of the primary key field for the first record in a block and a pointer to that block as its two field values.
  • An index entry i will be referred using two field values (ie)<(K(i).P(i)>.
  • The first record in each block of the data file is called the anchor record of the block.
  • Indexes can also be characterized as
  1. Dense Index
  2. Sparse Index
1. Dense Index : It has an index entry for each search key value in the data file.
2. Sparse Index or Non-dense Index : It has index outries for only some of the search values.A primary index is hence a non-dense index,since it includes an entry for each disk block of the data file rather than for every search value.

Secondary Index :

  • It is also an ordered file with two fields.The first field is of the same type as some non-ordering field of the data file that is an indexing field.The second field is either a block pointer or a record pointer.
  • Secondary index usually needs more storage space and longer search time than does a primary index.This is because of its large number of entries.

Clustering index :

  • It records of a file are physically ordered on a non-key field which does not have a distinct value for each record that field is called clustering field.
  • Clustering index is to speed up retrieval of records that have the same value for the clustering field.
  • This differs from the primary index,which requires that ordering field is of the data file have a distinct value for each record.
  • A clustering index is also an ordered file with two fields;The first field is of the same type as the clustering field of the data file,and the second field is is a block pointer.


What is meant by Query Language | Define Query Language

Query Language Data Base Management System:

A query language is a language in which a user requests a information from the database.

Query language can be divided into two,they are
  • Procedural language
  • Non-Procedural language

Procedural language : 

In this language , the user instructs the system to perform a sequence of operations on the database to compute the desired result.

Non-Procedural language :

In this non-procedural language , the user describes the desired information without giving a specific procedure for obtaining that information.

This is the short description about meaning of query language in the database management systems DBMS.