Posts

Showing posts with the label Types of Normalization
  ❖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)

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 nor malization 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....