Breaking News: Grepper is joining You.com. Read the official announcement!

Database Normalization

Add Answer

Nice Narwhal answered on July 23, 2022 Popularity 10/10 Helpfulness 1/10

answer Database Normalization

related normalisation in dbms

related normalization in dbms

Database Normalization

Comment

there are several Normalization steps that include:
First Normal Form abbreviated as 1NF
1NF - attributes must be atomic, row sequence order must not matter,
	-  suffers from redundancy(repeat values).
    e.g state, cities(Accra,Windhoeck,Bujumbura)
    - in 1NF = state Accra| state Windhoeck | state Bujumbura
    
2NF - all non key attribute must fully depend on candidate key
	- e.g student_id# subject teacher   -> not in 2NF because teacher partially
    - depends on student_id (pk).
    - Fix by decompose into two tables
    [stud_id# lesson_id]
    [lesson_id#, subject, teacher]
    
3NF - should not have transitive dependency in that i.e from example
	-  stud_id# course age birth_date
    - above the age depends on the non key attribute birthdate.
    - most cases a fix is to create a separate table with
    new table: 
    [birthdate#,age)
    - in original table will be updated to:
    stud_id# course birth_date
    - birth_date must remain on parent tbl.

Popularity 10/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: database-normalization whatever

Link to this answer
Share Copy Link

Contributed on Sep 28 2023

Nice Narwhal

0 Answers Avg Quality 2/10

Closely Related Answers

normalisation in dbms

Comment

The process of organizing data to avoid any duplication of data and redundancy is known as Normalization.

Popularity 10/10 Helpfulness 3/10 Language whatever

Source: Grepper

Tags: whatever whateve

Link to this answer
Share Copy Link

Contributed on Jul 23 2022

Disturbed Dogfish

0 Answers Avg Quality 2/10

normalization in dbms

Comment

normalization in dbms

Popularity 10/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: normalization no

Link to this answer
Share Copy Link

Contributed on Mar 23 2023

Ugly Unicorn

0 Answers Avg Quality 2/10

Database Normalization

Contents

More Related Answers

Database Normalization

Closely Related Answers

normalisation in dbms

normalization in dbms

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.