Posts

Showing posts with the label 2.Second Normal Form (2.NF)

What is Software process framework And, Umbrella activities

Image
  ❖ Software generic process framework activities .   A process framework establishes the foundation for a complete software process by identifying a small number of framework activities that are applicable to all software projects, regardless of their size or complexity. • In fig each framework activity is populated by a set of software engineering actions. A collection of related tasks that produces a major software engineering work product. • Each action in process framework is populated with individual work tasks that accomplish some part of the work implied by the action. 1. Communication: Communication framework activity involves heavy communication and collaboration with the customer,encompasses requirements gathering, data gathering and other related activities. 2. Planning: Planning activity establishes a plan for software engineering work that follows. Planning describes the technical tasks to be conducted, the resources that will be required, schedule, and the risks...

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