... necessary I created my own for example, Order Number on the Order Form (see page two). From here the initial information can (normally) be broken down, for example figure one below is part of a normalization table (Ingredients Forecast, page one) showing an initial split from UNF to First Normal Form (FNF), (Blue=Name, violet=Primary Key and orange=Foreign Key) As you can see the attributes have been split into two groups both with names, primary and foreign keys. It sounds very easy in principle to choose a name and keys, but in practice turned out to be more than tricky. It took many attempts to get to my final solution (pages 1-5). The process of decomposing the entities from UNF to FNF is just the same going from FNF to SNF (Second Normal Form) and from SNF to TNF (Third Normal Form), however I was not always able to do this. The example shown ...

See this essay or coursework document in full right now