Computer Science
What do you understand by the terms Cardinality and Degree of a relation in relational database?
Related Questions
What are DDL and DML?
Differentiate between primary key and candidate key in a relation.
Differentiate between DDL and DML. Mention the two commands for each category.
Write SQL Commands for (i) to (v) and write the outputs for (vi) to (viii) on the basis of the following table:
Table: FURNITURE
NO ITEM TYPE DATEOFSTOCK PRICE DISCOUNT 1 White Lotus DoubleBed 2002-02-23 3000 25 2 Pinkfeathers BabyCot 2002-01-29 7000 20 3 Dolphin BabyCot 2002-02-19 9500 20 4 Decent OfficeTable 2002-02-01 25000 30 5 Comfortzone DoubleBed 2002-02-12 25000 30 6 Donald BabyCot 2002-02-24 6500 15 (i) To list the details of furniture whose price is more than 10000.
(ii) To list the Item name and Price of furniture whose discount is between 10 and 20.
(iii) To delete the record of all items where discount is 30.
(iv) To display the price of 'Babycot'.
(v) To list item name, type and price of all items whose names start with 'D'.
(vi) SELECT DISTINCT Type FROM Furniture;
(vii) SELECT MAX(Price) FROM Furniture WHERE DateofStock > '2002-02-15' ;
(viii) SELECT COUNT(*) FROM Furniture WHERE Discount < 25 ;