You should Use these tables to help you category.(catNo, catogery Name) Items (itemNo, ItemName, Price, total_quantity, catNo), Items_stor_entry(entry_no number primary key, itemNo,entry_date, quantity), By using PL/SQL: procedure to add newltemQuantaty(itemName, newQuantaty) this firstly check the existing of this item name (by creating FUNCTION called checkExisting)and return item no if exists else it return 1, then if its exists then it will add new entry to Items_stor_entry table to create new row with this itemname as new entry to store. Then increase the item total_quantity in the items table with new quantity then display message show the items new total quantity in the store else if this item not exists it will display the message "no item has this name " will be display . (please don't solve this question if you don't have the complete and correct answer )