Question How to make this database to be normalization?

[witecloner]

Hi all, i have finish design a simple database to handle stock application. Here above that structure.

TABLE STOCK
===========
ITEMID (PK)- CHAR(10)
ITEMNAME - VARCHAR(50)
ITEMMODEL - VARCHAR(50)
CATEGORYID (FK) - CHAR (10)
OLDPRICE - MONEY
STANDARDPRICE - MONEY
MARKETPRICE - MONEY
DATEPRICE - DATETIME
UNITNAME1 (FK)- CHAR(10)
UNITNAME2 - CHAR(10)
QTYUNITNAME2 - NUMERIC(18,2)
UNITNAME3 - CHAR(10)
QTYUNITNAME3 - NUMERIC(18,2)
PACKAGESNAME - CHAR(10)
QTYPACKAGES - NUMERIC(18,2)
FIRSTAMOUNT - NUMERIC(18,2)
DESC - TEXT
MODIFICATION - TIMESTAMP
OPERATOR - VARCHAR(50)

TABLE CATEGORY
==============
CATEGORYID (PK) - CHAR(10)
CATEGORYNAME - VARCHAR(50)

TABLE UNITNAME
==============
UNITNAME (PK) - CHAR(10)
UNITDESC - VARCHAR(50)

could anybody tell me, how can i design the normalization of that stock table?

how can i design the stock table for temporary delete record? i mean if i delete the record in stock table it's not delete permanently in database and will be store back. thank you.

 

[witecloner]

sorry cjard i'm beginer for this case, could you explain why be like that?
thank you

 

[witecloner]

Thank's Cjard. This problem have been solved.

I used a timer to periodic update the dataset, Where if the dataset has chages and then update the dataset.

Thank's again.