DIY+Store+Normalisation+Solution

**Solution**
**Unnormalised Form**




 * First Normal Form **




 * Second Normal Form **

In the relation //**order_details**//, the attribute //**product_description**// is not dependent on the compound key of //**product_number**// and //**order_number**//. A new relation is created called //**product**//




 * Third Normal Form**

The attribute //**customer_address**// is dependent on //**customer_name**// and so these attributes are moved to a new relation //**customer**//.