Create a table stock ,which stores daily sales of items in shop which the

Answer 1

create table stock(item_code int primary key ,item varchar(20),manufacture_code varchar(5),oty int,unit_price double (10,2));

Answer 2

item_code integer primary key
item_varchar(20)
manufacture_code varchar(5)
oty integer
unit price decimal