Wednesday, 20 July 2016
IMPORTANCE OF COMMUNICATION
Communication is an indispensable part of the process of management. The success of an enterprise depends upon the effective of communication. Every manager must communicate in order to get things done through others. A good communication system offers the following benefits :
1. Basis of Decision-Making and Planning: Communication is essential for decision-making and planning. It enables the management to secure information without which it may be possible to take any decision. The quality of managerial decisions depends upon the quality of communication. Further, the decisions and plans of the management need to be communicated to the subordinates. Without effective communication, it may not be possible to issue instructions and orders. Effective communication helps in proper implementation of plans and policies of the management.
2. Smooth and Efficient Working: Communication makes possible the smooth and efficient working of an enterprise. It is only through communication that the management changes and regulates the actions of the subordinates in the desired direction.
3. Facilitates Co-ordination: Management is the art of getting things done through others and this objective of management cannot be achieved unless there is unity of purpose and harmony of effort. Communication through exchange of ideas and information helps to bring about unity of action in the pursuit of common purpose. It binds the people together and facilitates co-ordination.
4. Increases Managerial Efficiency: Effective communication increases managerial efficiency. It is rightly said that nothing happens in management until communication takes place. The efficiency of a manager depends upon his ability to communicate effectively with the members of his organisation. It is only through communication that management conveys its goals and desires, issues instructions and orders, allocates jobs and responsibility and evaluates performance of subordinates.
5. Sound Industrial Relations: Effective communication creates mutual understanding and trust among the members of the organisation. It promotes co-operation between the employer and the employees. Without communication, there cannot be sound industrial relations and industrial peace. It is only through communication that workers can put in their grievances, problems and suggestions to the management.
6. Helps in Establishing Effective Leadership: Communication is the basis of effective leadership. There cannot be any leadership action without the effective communication between the leader and the led. Communication is absolutely necessary for maintaining man to man relationship in leadership. It brings the manager (leader) and the subordinates (led) in close contact with each other and helps in establishing effective leadership.
7. Motivation and Morale: Communication is the means by which the behaviour of the subordinates is modified and change is effected in their actions. Through communication workers are motivated to achieve the goals of the enterprise and their morale is boosted. Although motivation comes from within yet the manager can also motivate people by effective communication, e.g., proper drafting of message, proper timing of communication and the way of communication, etc.
8. Effective Control: Communication acts as a tool of effective control. The plans have to be communicated to the subordinates, the actual performance has to be measured and communicated to the top management and a corrective action has to be taken or communicated so as to achieve the desired goals. All this may not be possible without an efficient system of communication.
9. Job Satisfaction: Effective communication creates job satisfaction among employees as it increased mutual trust and confidence between management and the employees. The gap between management and the employees is reduced through the efficient means of communication and a sense of belongingness is created among employees. They work with zeal and enthusiasm.
10. Democratic Management: Communication is also essential for democratic management. It helps to achieve workers’ participation in management by involving workers in the process of decision-making. In the absence of an efficient system of communication, there cannot be any delegation an decentralization of authority.
11. Public Relations: In the present business world, every business enterprise has to create and maintain a good corporate image in the society. It is only through communication that management can present a good corporate image to the outside world. Effective communication helps management in maintaining good relations with workers, customers, suppliers, shareholders, government and community at large.
COMMUNICATION FUNCTION IN ORGANISATIONS
The communication function as the means by which the activities in the organisation are coordinated to achieve the organisational goals. It is also the means by the which behaviour is modified, change is effected, information is made productive & goals are achieved. Whether it is with a business enterprise, a family, educational institution or trade exhibition, the transfer of information from individual to another is absolutely essential.
There are two main types of communication in every organisation – formal & informal communication.
1.Formal Communication
Formal communication refers to official communication which takes place through a chain of commands. It flows in formally established channels & is concerned with work related matters. Members of the enterprise and expected to communication with one another strictly as per channels laid down in the structure.
The formal communication may be divided into three categories which are given as follows:
a) Downward Communication:
Under this system, the flow of communication from the top management downward to be operating level. It may also be called a communication from a superior to a subordinate. It follows the line of authority from the top to the bottom of the organisation hierarchy. Downward communication consists of plans & policies, orders and instructions, procedures & rules etc.
b) Upward Communication:
It means the flow of information from the lower levels of the organisation to the higher level of authority. It passes from subordinate to superior as that from worker to foreman, foreman to manager. From manager to general manager & so on. This communication includes opinions, ideas, suggestions,complaints, grievances, appeals, reports etc. It is very important as it serves as the feedback on the effectiveness of downward communication. Management is able to know how well its policies, plans & objectives are followed by those working at lower levels of the organisation. It keeps the management informed about the progress of the work & difficulties faced in performance. On the basis of upward communication, the management revises its plans & policies & makes further planning.
c) Horizontal Communication:
The transmission of information and understanding between people on the same level of organisation hierarchy is called the horizontal communication. This type of communication is also known as lateral or side-ward or crosswise communication. Usually, it pertains to inter departmental managers working at the same level of organisation or among subordinates working under one boss. Horizontal communication speeds up information and promotes mutual understanding. It enables the managers working at the same level to exchange information and co-ordinate their activities without referring all matters to the higher level of management.The horizontal communication is generally of an informal nature. Whenever a departmental head requires some information from another departmental head, he tends to contact him directly. However, this type of communication can be oral or written.
2.Informal Communication
There is also a great deal of informal communication in an organisation. This communication flows through informal channels and may or may not be work related. Informal communication cuts through the formal organisational structure. Most of us are familiar with the term ‘grapevine’ used to describe a network of informal communication. Grapevines are present in all organisations. In fact, in large organisations, there are many grapevines moving up, down and across departments. Grapevines flourish because communication is a natural human tendency. People who know each other in the organisation talk together informally. One thing they have in common is the organisation they work for, so they talk about the happenings in the organisation. Grapevines carry two types of information : work related and people related. Employees want to know what is going on inthe organisation. When they are not kept informed through formal channels, they seek information from the grapevine. Likewise, they are curious about the people they work with. Grapevine carry the type of personnel information not generally communicated through formal channels. Employees get to know plans, promotions, punishments, etc, much before they are formally announced. Informality however, reduces uniformity of communication and sometimes false or distorted news is circulated. Some employees consider the grapevine their main source of information. It is fast- they get information quickly and more information is given than is normally included in formal downward communications, which are often written and may originate from some one they do not know personally.Manager often become frustrated with grapevines, particularly when they carry incorrect information. But grapevines exist; managers cannot stop them. Managers can, however, increase the accuracy of the grapevine by feeding it correct information. And they can try to reduce the relevance placed on grapevines by making certain that formal communication is complete and timely.
BUSINESS COMMUNICATION
The word 'Business' stands for any economic activity undertaken with a view to earn profit. The communication undertaken in the process of this activity is termed as business communication. From the very inception of the idea of the Business, to run the day to day activities of the Business, communication is involved. It includes oral, written, formal, informal, upward, downward, lateral, diagonal, inward, outward as well as non verbal communication.
Communication is the most vital ingredient of an organisation. In fact, an organisation cannot be conceived of without communication. An organisation is a group of persons constituted to achieve certain specific objectives. The achievement of these objectives largely depends upon a proper co-ordination and integration of human effort in an organisation. The people working in an organisation; their activities are also interrelated because all activities are performed only to active the organisational objectives. Co-ordination and integration of various human activities are possible only if there is an effective system of communication in the organisation which provides for exchange of information and sharing of various ideas. The more effective the system of communication, the better is the relation between workers and the management. It is communication which gives life to the organisation; so, it is rightly known as the life blood of an organisation.
Monday, 18 July 2016
INTEGRITY CONSTRAINTS
Integrity constraints provide a way of ensuring that changes made to the database by authorised users do not result in a loss of data consistency. An integrity constraint can be any arbitrary predicate applied to the database. They may be costly to evaluate, so we will only consider integrity constraints that can be tested with minimal overhead.
DOMAIN CONSTRAINTS
Domain constraints specify that the value of each attribute A must be an atomic value from the domain dom (A) for that attribute. Some data types associated with domains are given below;
- Standard
numeric data types for integers (such as short-integer, integer, long-integer).
- Real
numbers (float and double-precision float).
Characters, fixed-length strings, and
variable-length strings.
ENTITY INTEGRITY
Entity
integrity is a property that ensures that no records are duplicated and that no
attributes that make up the primary key are NULL. It is the one of the
properties necessary to ensure the consistency of the database.
Entity
Integrity ensures that there are no duplicate records within the table and that
the field that identifies each record within the table is unique and never
null.
The
existence of the Primary Key is the core of the entity integrity. Entity
integrity specifies that the Primary Keys on every instance of an entity must
be kept, must bt unique and must have values other than NULL.
REFERENTIAL INTEGRITY
Referential
integrity is usually enforced by the combination of a primary key or candidate
key (alternate key) and a foregin key. A foregin value must match an existing
value of the parent table.Foregin hey based on data values and are purely
logical not physical.
Characters, fixed-length strings, and variable-length strings.
ENTITY INTEGRITY
Entity integrity is a property that ensures that no records are duplicated and that no attributes that make up the primary key are NULL. It is the one of the properties necessary to ensure the consistency of the database.
Entity
Integrity ensures that there are no duplicate records within the table and that
the field that identifies each record within the table is unique and never
null.
The existence of the Primary Key is the core of the entity integrity. Entity integrity specifies that the Primary Keys on every instance of an entity must be kept, must bt unique and must have values other than NULL.
REFERENTIAL INTEGRITY
Referential integrity is usually enforced by the combination of a primary key or candidate key (alternate key) and a foregin key. A foregin value must match an existing value of the parent table.Foregin hey based on data values and are purely logical not physical.
DATA TYPES
The
data types available with SQL are given below;
|
Internal Data type
|
Description
|
|
VARCHAR2
(size)
|
Variable
length character string maximum length size bytes. Maximum size is 2000 and
minimum is 1. You must specify size for a VARCHAR2.
|
|
NUMBER
(p,s)
|
Number
having precision p and scale s. The precision p can range from 1 to 38. The
scale s can range from -84 to 127.
|
|
LONG
|
Character
data of variable length up to 2 gigabytes, or 231-1 bytes.
|
|
DATE
|
Valid date
range from January 1,4712 BC to December 31, 4712 AD.
|
|
RAW (size)
|
Raw binary
data of length size bytes. Maximum size is 255 bytes. You must specify size
of a RAW value.
|
|
LONG RAW
|
Raw binary
data of variable length up to 2 gigabytes.
|
|
ROWID
|
Hexadecimal
string representing the unique address of a row in its table. This data type
is primarily for values returned by the ROWID pseudo column.
|
|
CHAR(size)
|
Fixed
length character data of length size byte. Maximum size is 255. Default and
minimum size is 1 byte.
|
Tuesday, 14 June 2016
E-R DIAGRAMS
The overall logical structure of a database can be expressed graphically by E-R diagram. The entity-relationship model can be conveniently represented in a pictorial form using drawing tools.
1. Rectangles: represent entity set.
2. Ellipses: represent attributes.
3. Diamonds: represent relationships among entity sets.
4. Lines: link attributes to entity sets and entity sets to relationships.
5. Key attributes: have their names underlined.
6. Derived attributes: are shown in dotted ovals.
7. Double rectangular: represent weak entity types and their identifying relationship are shown by double diamonds.
8. Dotted line: The partial key of the weak entity type.
Subscribe to:
Posts (Atom)
