Question

plz give answer of this question

Answer 1

Hi,

Suggest the data types of fields in the table

ItemNo = INT

Item_name = VARCHAR

Quantity = INT

Price = INT

Discount = INT

Item description = VARCHAR

Which field should be made the primary key of the table?

ItemNo should be made the primary key of the table because it's unique.