What is the level of database normalization, explain? Miniature Database Table Structure for Produce COLUMN_NAME DATA_TYPE NULLABLE

What is the level of database normalization, explain?

 

Transcribed Image Text:

Miniature Database Table Structure for Produce COLUMN_NAME DATA_TYPE NULLABLE ITEMID CHAR (5) No SUPPLIERID CHAR (10) No PLUCODE CHAR (4,2) No PRODUCENAME CHAR (15) No TYPE CHAR (10) No STOCKQTY NUMBER (4,2) No NXTDELIVERY DATE No Table Structure for Animal Products: COLUMN_NAME DATA_TYPE NULLABLE ITEMID CHAR (5) No SUPPLIERID CHAR (10) No ANPRDNAME CHAR (15) No TYPE CHAR (10) No STOCKQTY NUMBER(4,2) | No. NXTDELIVERY DATE Yes Table Structure for Grains: COLUMN_NAME DATA_TYPE NULLABLE ITEMID CHAR (5) SUPPLIERID CHAR (10) GRAINNAME CHAR (15) TYPE CHAR (10) STOCKQTY NUMBER(4,2) | No zzzzz No No No No NXTDELIVERY DATE Yes Table Structure of Suppliers: COLUMN_NAME DATA_TYPE NULLABLE SUPPLIERID CHAR(10) No LASTDELIVERY DATE Yes SPECIALTY CHAR(15) Yes ACTIVE CHAR (1) No Table Structure of Purchases: COLUMN_NAME DATA_TYPE NULLABLE ITEMID CHAR (5) No TOTALBOUGHT NUMBER (8,2) Yes TOTALSOLD NUMBER(8,2) Yes TOTALREV NUMBER(10,2)| Yes MARGIN NUMBER(10,2)| Yes Miniature Database Table Structure for Produce COLUMN_NAME DATA_TYPE NULLABLE ITEMID CHAR (5) No SUPPLIERID CHAR (10) No PLUCODE CHAR (4,2) No PRODUCENAME CHAR (15) No TYPE CHAR (10) No STOCKQTY NUMBER (4,2) No NXTDELIVERY DATE No Table Structure for Animal Products: COLUMN_NAME DATA_TYPE NULLABLE ITEMID CHAR (5) No SUPPLIERID CHAR (10) No ANPRDNAME CHAR (15) No TYPE CHAR (10) No STOCKQTY NUMBER(4,2) | No. NXTDELIVERY DATE Yes Table Structure for Grains: COLUMN_NAME DATA_TYPE NULLABLE ITEMID CHAR (5) SUPPLIERID CHAR (10) GRAINNAME CHAR (15) TYPE CHAR (10) STOCKQTY NUMBER(4,2) | No zzzzz No No No No NXTDELIVERY DATE Yes Table Structure of Suppliers: COLUMN_NAME DATA_TYPE NULLABLE SUPPLIERID CHAR(10) No LASTDELIVERY DATE Yes SPECIALTY CHAR(15) Yes ACTIVE CHAR (1) No Table Structure of Purchases: COLUMN_NAME DATA_TYPE NULLABLE ITEMID CHAR (5) No TOTALBOUGHT NUMBER (8,2) Yes TOTALSOLD NUMBER(8,2) Yes TOTALREV NUMBER(10,2)| Yes MARGIN NUMBER(10,2)| Yes