I want to create a database for manage equipment in restaurant such as chair,table,fork,spoon,glass.....


i have table like this :

tbldate ( dateid )

tblbreak ( dateid, equipmentid, qty, unitprice, reason )

tblequipment ( equipmentid, name, qty, unitprice )

tblbuydetail ( equipmentid, buyid, qty, unitprice )

tblbuy ( buyid, date, invoiceno, supplier )

This relationship is good or not. can everybody help me? and about form design?