1. Suggest a suitable primary key for the above table. Give justification.

Question

Consider the given table ITEMS

1. Suggest a suitable primary key for the above table. Give justification. 

2. Write SQL statements for the following: 

• To list all stationery items. 
• To list item code, name, and profit of all items. 
• To count the number of items in each category. 
• To list all stationery items in the descending order of their unit price. 
• To nd the item with the highest selling price. 
• To create a view that contains the details of all stationery items.

Answer 1

1. Item code is the primary key for the table 

2. SQL statements:

(i)

(ii)

(iii)

(iv)

(v)

(vi)