Mr. James created a table CLIENT with 2 rows and 4 columns. He added 2 more rows to it and deleted one column.

Q. (a) Mr. James created a table CLIENT with 2 rows and 4 columns. He added 2 more rows to it and deleted one column. What is the Cardinality and Degree of the Table CLIENT ?

(b) Consider the following table FITNESS with details about fitness products being sold in the store. Write command of SQL for (i) to (iv).>

 
(i) To display the names of all the products with price more than 20000.
(ii) To display the names of all products by the manufacturer "Aone".
(iii) To change the price data of all the products by applying 25% discount reduction.
(iv)To add a new row for product with the details
 "P7", "Vibro Exerciser", 28000, "Aone".

Answer =

(a)

Cardinality = 4

Degree = 3

(b)

(i)

select PNAME from FITNESS

Where price > 20000;

(ii)

select pname  from FITNESS

Where manufacturer = “Aone”;

(iii)

update FITNESS

Set  price = price * 0.75 ;

(iv)

insert into FITNESS values (“P7” , “Vibro Exerciser”, 28000, "Aone" ) ;