❖Communication practices: Principle 1 Listen: •Try to focus on the speaker‘s words, rather than formulating your response to those words. •Ask for clarification if something is unclear, but avoid constant interruptions. •Never become contentious in your words or actions (e.g., rolling your eyes or shaking your head) as a person is talking. Principle 2 Prepare before you communicate: •Spend the time to understand the problem before you meet with others. If necessary, perform some research to understand business domain. •If you have responsibility for conducting a meeting, prepare an agenda in advance of the meeting. Principle 3 someone should facilitate the activity: •Every communication meeting should have a leader (a facilitator) 1)To keep the conversation moving in a productive direction, 2)To mediate any conflict that does occur, and 3)To ensure that other principles are followed. Principle 4 Face-to-face communication is best: •It usually works better when some other represen...
What is Normalization, Need of normalization, Types of Normalization, 1.First Normal Form (1.NF), 2.Second Normal Form (2.NF)
- Get link
- X
- Other Apps
Normalization:-Normalization is a process of designing a consistent database by minimizing redundancy and inserting data integrity into the through decomposition. it is a step by step decomposition of aim complex record into a simple record. It is a process of organization data in the database in efficient way.
.Need of normalization
1.Ensure data Integrity data integrity ensure the correctness of data stored with in the database.
2.Prevent redundancy in data-It data is storage i two location but data is updated in only one location then the data become inconsistent. A normalization database store data in only one location.
3.Update Anomaly-Same information can be present in multiple record of various relation if user update one location then the changes reflect in all the location.
.Types of Normalization
There are three types of normalization
1.First Normal Form (1.NF):-It is a simplest from of normalization. It simplicity each attribute in a table. A relation in information it in the every row contain execute one value for the each attribute data
In information data has one rule, column should contain atomic data and there should be not only repeating group of data.
For Ex-Consider a staff table heaving the information about Faculty and there subjects.
2.Second Normal Form (2.NF):-This normal from many use there functional dependency any try to remove problems of first normal in from the. There fore when we create second normal form relation it need to satisfy 1NF relation consider the above table while one fore eliminating the repeating groups in that process we introduce relation redundancy in the table. To eliminate these record we have to split the table into two parts.
3.Third Normal form:-This normal form is used to minimize they transitive redundancy. Third normal form removed the Anomalies the that occur in 2NF. The table in 3Nf that have attribute and relation and it is transitively dependent on the primary key.
Ex-In above table hour depends on the subject and subject depends on staff id. Then in this 3NF we combine the information regarding subject hour and staff id
1.First Normal Form (1.NF)
2.Second Normal Form (2.NF)
Need of normalization
Normalization
Types of Normalization
- Get link
- X
- Other Apps
Popular posts from this blog
What is Computer engineering, complete information
Computer Engineering Computer Engineering is an engineering branch that is a combination of Computer Science and Electronics Engineering. Digital logic in design computer organization and architecture microprocessor in the system and interfacing computer networks and operating system. In this you learn the design, development and maintenance of both hardware (physical parts of the computer) and software (programs, applications, operating systems). 1.Scope of Computer Engineering . Computer Engineering students are taught these things: . Computer Hardware Design :-CPU circuit boards microcontrollers, embedded systems. ...
What is Constants, Variables, and Data Types
Constants Constants in java refer to fixed values do not change during the execution of a program , Java support several types of constants as illustrated. .Integer Constants An integer constant refer to a sequence of digits , There are three types integers .namely decimal imager octal integers and hexadecimals integers . Decimal integers consist of a set of thing preceded by an optional minus sign Valid of decimals integer constant .Variables A variable is an identifier that denotes a storage location seed to store a data value unlike constant that remain unchanged during the execution of a program , a variable may take different values at different times during the execution of the program ,we had used several variable for instance , we used variables length and breath to store the values o...
What is Diploma Engineering and How to Diploma engineering free course
What is diploma in engineering is a 3 year course .All India It is designed to students with practical skills and knowledge in a engineering. After completing the diploma, students further education through into a bachelor's degree program or enter the diploma in engineering course 1.School Level (Class 10 ) .Focus on Math Science Physics and Chemistry - MSPC . After class 10, you will have to take science stream. 2 .11th-12th Science Stream (MSPC Group) .Physics, Chemistry, Mathematics (PCM) are compulsory subjects. .You should prepare for entrance exams like JEE, MAHT-SET, VIT, BITSAT. .You have to clear these exams after class 12. 3.Duration: 4 years .Popular branches: . Diploma in computer Science (CSE) . Diploma in m echanical . Diploma in civil . Diploma in electrical . Diploma in Electronics & Communication . Diploma in...
Comments
Post a Comment