the following tables from 1NF to 3NF, and a brief explanation on what was done to perform the desired outcome, with references if possible.

  

Transcribed Image Text:

COLUMN_NAME ITEMID SUPPLIERID PLUCODE PRODUCENAME TYPE STOCKQTY NXTDELIVERY ITEMID SUPPLIERID ANPRDNAME TYPE COLUMN_NAME ITEMID DATA_TYPE CHAR (5) CHAR (10) CHAR (4,2) CHAR (15) CHAR (10) DATE Table Structure for Animal Products: COLUMN_NAME STOCKQTY NXTDELIVERY DATE Table Structure for Grains: SUPPLIERID GRAINNAME TYPE NULLABLE No No No No NUMBER (4,2) No No No STOCKQTY NXTDELIVERY DATE Table Structure of Suppliers: DATA TYPE CHAR (5) CHAR (10) CHAR (15) CHAR (10) No NUMBER(4,2) No Yes NULLABLE No No No DATA TYPE CHAR (5) No CHAR (10) No CHAR (15) No CHAR (10) No NUMBER(4,2) No Yes NULLABLE COLUMN_NAME ITEMID SUPPLIERID PLUCODE PRODUCENAME TYPE STOCKQTY NXTDELIVERY ITEMID SUPPLIERID ANPRDNAME TYPE COLUMN_NAME ITEMID DATA_TYPE CHAR (5) CHAR (10) CHAR (4,2) CHAR (15) CHAR (10) DATE Table Structure for Animal Products: COLUMN_NAME STOCKQTY NXTDELIVERY DATE Table Structure for Grains: SUPPLIERID GRAINNAME TYPE NULLABLE No No No No NUMBER (4,2) No No No STOCKQTY NXTDELIVERY DATE Table Structure of Suppliers: DATA TYPE CHAR (5) CHAR (10) CHAR (15) CHAR (10) No NUMBER(4,2) No Yes NULLABLE No No No DATA TYPE CHAR (5) No CHAR (10) No CHAR (15) No CHAR (10) No NUMBER(4,2) No Yes NULLABLE

Answer rating: 100% (QA)

1NF The given tables are already in 1NF Animal Products The table is already in 1NF Grains The table is already in 1NF Suppliers The table is already ... View the full answer