Shree Secondary School

The Normalization Process Normalization is a data analysis technique to design a database system. It allows the database designer to understand the current data structures within an organization. Furthermore, it aids any future changes and enhancements to the system. The end result of normalization is a set of entities, which removes unnecessary redundancy (i.e. duplication of data) and avoids the anomalies discussed earlier. Normalization follows a staged process that obeys a set of rules. The steps of normalization are: Select the data source and convert into an unnormalised table (UNF) Transform the unnormalised data into first normal form (1NF) Transform data in first normal form (1NF) into second normal form (2NF) Transform data in second normal form (2NF) into third normal form (3NF) Occasionally, the data may still be subject to anomalies in third normal form. In this case, we may have to perform further transformations. Transform third normal ...

1.1   Introduction to Computer Computer is an electronic device/ machine that takes data as a input from user, processes them and gives output in the form of meaningful information. It accepts different forms of input such as data, programs and user reply. OR Computer is a programmable machine which has two principal characteristics; It responds to a specific set of instructions in a well-defined manner. It can execute a prerecorded list of instructions (a program). Data is the raw details and/or collection of facts, figure and etc about any Entity (Person, place, thing, event etc) that need to be processed to generate useful information. Information is the processed form of data which gives a specific meaning. Programs are the set of instruction that can be executed by the computer in sequential of random manner to perform a specific task. Computer System Collection of different electronic devices (such as Mouse, Keyboard, Monitor, CPU, S...