Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
311 views
in Structured Query Language by (30.3k points)
closed by

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.

1 Answer

+1 vote
by (30.5k points)
selected by
 
Best answer

1. Item code is the primary key for the table 

2. SQL statements:

(i)

(ii)

(iii)

(iv)

(v)

(vi)

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...