Gain Immediate access to our Essays
FREE access exchanged for your work, or pay £9.99
... any problem, but produce an answer which has a value NULL. (4) The following are the entities that will be tested for normalisation, using the 1NF, 2NF and 3NF: SUPPLIER (CODE, NAME, CONTACT, ADDRESS 1, ADDRESS 2, POST CODE, TOWN, PHONE, FAX). INVENTORY (ITEM_CODE, STORE_LOCATION, QUANTITY). 1st Normalisation Form (1NF) basically states that the entity is in the 1NF if it consists of a Primary Key. By analysing the two tables, SUPPLIER and INVENTORY, it is evident that they both consist of a primary key attribute. In the SUPPLIER table the primary key attribute is the CODE attribute, where as in the INVENTORY table it is the ITEM_CODE attribute. A table is in the 2nd Normalisation Form (2NF) if it is in the 1NF and no attribute is dependent on only a portion of the primary key. The SUPPLIER table has a single attribute primary key. Thus by default, this table is in the 2NF. On the other hand, ...