KEMBAR78
12th Cs Database Assignment-3 | PDF
Scribd
Upload
19 views2 pages

12th Cs Database Assignment-3

The document contains a series of questions related to SQL queries and database operations for a Class-12 Computer Science assignment. It covers topics such as updating product prices, querying employee details, and manipulating tables in SQL. Additionally, it includes tasks related to displaying and inserting data in various tables, specifically focusing on products, employees, senders, and books.

Uploaded by

Palak Inani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
19 views2 pages

12th Cs Database Assignment-3

The document contains a series of questions related to SQL queries and database operations for a Class-12 Computer Science assignment. It covers topics such as updating product prices, querying employee details, and manipulating tables in SQL. Additionally, it includes tasks related to displaying and inserting data in various tables, specifically focusing on products, employees, senders, and books.

Uploaded by

Palak Inani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Class-12 CS

Assignment-3
_____________________________________________________________________________
Question 1. Rakesh wants to increase the price of some of the products by 20%, of his store
whose price is less than 200. Assuming the following structure, what will be the query?
Table: Product
PNo PName Quality Price

Question 2. What will be the output of the following queries on the basis of EMPLOYEE table?
Table: EMPLOYEE
Emp_Id Name Salary
E01 Siya 54000
E02 Joy NULL
E03 Allen 32000
E04 Neev 42000
(i) SELECT Salary + 100 FROM EMPLOYEE
WHERE Emp_Id = 'E02';
(ii) SELECT Name FROM EMPLOYEE
WHERE Emp_Id = 'E04';

Question 3. Write the queries for the following questions using the table Product with the
following fields.
(P_Code, P_Name, Qty, Price)
(i) Display the price of product having code as P06.
(ii) Display the name of all products with quantity greater than 50 and price less than 500.

Question 4. Write syntax of the conditions given below.


(i) Add a column in a table.
(ii) Delete a column from a table.

Question 5. Insert 1 record into the STUDENTS table for the (RollNo, Name, Class, Marks)
Question 6. Consider the following tables. Write SQL commands for the statements (i) to (v).
Table: SENDER

(i) To display the names of all Senders from Mumbai.


(ii) To display the RecID, SenderName, SenderAddress, RecName, RecAddress for every
Recipient.
(iii) To display Recipient details in ascending order of RecName.
(iv) To display number of Recipients from each City.
(v) To display the detail of recipients who are in Mumbai.
Question 7. Given the following tables for a database library

Write SQL queries for (i) to (v).


(i) To show Book name, Author name and Price of books of EPB Publishers.
(ii) To list the names from books of Fiction type.
(iii) To display the names and price of the books in descending order of their price.
(iv) To increase the price of all books of First Publ Publishers by 50.
(v) To display the detail of book whose quantity less than 10.

You might also like