₦airaland Forum

I have been learning normaliztion recently, and after watching a couple of videos, I tried to normalize a random sql table I found online. I am still not really sure if I am right, but could someone please double-check my solution for 2NF (Not really sure how to continue to 3NF). If possible please also do roughly convert this 1NF to 3NF. Thanks in advance

In other to normalize the table to 1NF, ensure the attributes have ONLY atomic domains. So, we'll need to expand the table so it contains more rows.

Since the table is already in 1NF, we now make it to 2NF. And to achieve this, we need ensure the non-prime keys are fully dependent on the candidate key. We'll need to split this table into 3. The first should contain mission number and mission date. The second table should contain Agency Number, Lead Agency and Country. And the third table should contain the remaining attributes.

As for the 3NF, the only transitive dependency evident to me is in the third table and that is between Equipment and Total weight. So for the 3NF, we'll add a fourth table containing only Item weight and Total weight.

Mission_Equipment table:
Mission no., Mission date, Equipment,

Agency table:
Agency no., Lead agency, Country,

Weight table:
Qty, Weight, Total weight,

Database Normalisation is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables.Check this link to better understand

https://www.mindstick.com/Articles/855/introduction-to-database-normalization

http://agiledata.org/essays/dataNormalization.html

I hope it will help you

Thanks