To get to the third normal form, we remove transitive dependencies. The product is related to the Customer because that they are both related to the Customer Order. The tables above are in second normal form, so we need to produce a table creates the link between the Product and Customer Order. The tables above are now in third normal form.

To start to normalise the Works Order table we get to the first normal form, so we remove any repeating groups. In the works order table above, we remove the Stock information. The stock item quantity stays in the Works Order table as the stock item quanitity is dependent on the Works Order number. The tables below are in first normal form.

*…show more content…*

The product name and unit price are related to the Works Order through the Product ID FK, it depends on Product ID FK not Works Order Number PK. There needs to be a table called Product with all the product information. The tables below are in second normal form.

To get to the third normal form, we remove transitive dependencies. The Stock table is related to the Product table because that they are both related to the Works Order table. The tables above are in second normal form, so we need to produce a table creates the link between the stock and the Works Order table. The tables below are now in third normal form.

To start to normalise the Purchase Order table we get to the first normal form, so we remove any repeating groups. In the works order table above, we remove the Stock information. The ordered quantity stays in the Purchase Order table as the ordered quanitity is dependent on the Purchase Order number. The tables below are in first normal