Question

Observe the following table carefully and· write the names of the most appropriate columns, which can be considered as (i) candidate keys and. (ii) primary key:

Code	Item	Qty	Price	Transaction Date
1001	Plastic Folder 14"	100	3400	2014-12-14
1004	Pen Stand Standard	200	4500	2015-01-31
1005	Stapler Mini	250	1200	2015-02-28
1009	Punching Machine Small	200	1400	2015-03-12
1003	Stapler Big	100	1500	2015-02-02

Answer 1

Candidate keys : Code, Item

Primary keys : Code