Give your own example of a relationship that is in 3rd Norma

Give your own example of a relationship that is in 3rd Normal Form. Be sure to discuss why it is in 3rd Normal Form.

Solution

Normalization is a process in database which reduces data redundancy and dependency. It makes the database relational. It devides large tables into small tables and establish relationship between them.

Example:

Employee Table:

Here in the above table if we need to set the primary key the we need to use composite key( Emp_Name, Emp_Address). Also in this table there is Transitive Dependency like Emp Salary is dependant on Emp_Designation.

3rd Normal Form:

The database needs to satisfy the following conditions like:

1. It should be in 2nd Normal Form(means we can not use composite key)...so we ned to add another column named as Emp_ID to uniquely identify the rows.

2. There shuld no Transitive Dependency (means we need to divide the table by Emp Designation and Emp_Salary.

So after applying 3rd Normal Form the tables look like..