Normalization
(1) In relational database design, the process of organizing data to minimize redundancy. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective is to isolate data so that additions, deletions, and modifications of a fieldcan be made in just one table and then propagated through the rest of the database via the defined relationships.
There are three main normal forms, each with increasing levels of normalization:
First Normal Form (1NF):Each field in a table contains different information. For example, in an employee list, each table would contain only one birthdate field.
Second Normal Form (2NF):Each field in a table that is not a determiner of the contents of another field must itself be a function of the other fields in the table.
Third Normal Form (3NF): No duplicate information is permitted. So, for example, if two tables both require a birthdate field, the birthdate information would be separated into a separate table, and the two other tables would then access the birthdate information via an index field in the birthdate table. Any change to a birthdate would automatically be reflect in all tables that link to the birthdate table.
There are additional normalization levels, such as Boyce Codd Normal Form (BCNF), fourth normal form (4NF) and fifth normal form (5NF). While normalization makes databases more efficient to maintain, they can also make them more complex because data is separated into so many different tables.
(2) In data processing, a process applied to all data in a set that produces a specific statistical property. For example, each expenditure for a month can be divided by the total of all expenditures to produce a percentage.
(3) In programming, changing the format of a floating-point numberso the left-most digit in the mantissa is not a zero.
Read Also:
- Nonrepudiation
In reference to digital security, nonrepudiation means to ensure that a transferred message has been sent and received by the parties claiming to have sent and received the message. Nonrepudiation is a way to guarantee that the sender of a message cannot later deny having sent the message and that the recipient cannot deny having […]
- not invented here syndrome
Not invented here syndrome (NIHS) is a slightly tongue-in-cheek name for the tendency of both individual developers and entire organizations to reject suitable external solutions to software development problems in favor of internally developed solutions. Closely related to the “let’s re-invent the wheel” syndrome, NIHS can be seen in intensities ranging from a mild reluctance […]
- null character
A character that has all its bits set to 0. A null character, therefore, has a numeric value of 0, but it has a special meaning when interpreted as text. In some programming languages, notably C, a null character is used to mark the end of a character string. In database and spreadsheet applications, null […]
- Notebook Computer
)(n.) An extremely lightweight personal computer. Notebook computers typically weigh less than 6 pounds and are small enough to fit easily in a briefcase. Aside from size and portability, the principal difference between a notebook computer and a personal computer is the display screen. Notebook computers use a variety of techniques, known as flat-panel technologies,to […]
- null-modem cable
A specially designed cable that allows a user to connect two computers directly to each other via their communications ports (RS-232 ports). Null modems are particularly useful with portable computers because they enable the portable computer to exchange data with a larger system. Null modem cables have the Tx (transmit) and Rx (Recieve) lines crossed […]