updated views, added collumns to item table as given byfunctional design