Question
Differentiate between Candidate Key and Alternate Key in context of RDBMS.
Alternate Key: A candidate key that is not selected as a primary key is called an Alternate Key.
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Table: Club
| Member_id | Member_Name | Address | Age | Fee |
| M001 | Sumit | New Delhi | 20 | 2000 |
| M002 | Nisha | Gurgaon | 19 | 3500 |
| M003 | Niharika | New Delhi | 21 | 2100 |
| M004 | Sachin | Faridabad | 18 | 3500 |
(i) What is the cardinality and degree of the above given table?
(ii) If a new column contact_no has been added and three more members have joined the club then how these changes will affect the degree and cardinality of the above given table.
TABLE: SALESPERSON
| CODE | NAME | SALARY | ITCODE |
| 1001 | TANDEEP JHA | 60000 | I2 |
| 1002 | YOGRAJ SINHA | 70000 | I5 |
| 1003 | TENZIN JACK | 45000 | I2 |
| 1005 | ANOKHI RAJ | 50000 | I7 |
| 1004 | TARANA SEN | 55000 | I7 |
TABLE: ITEM
| ITCODE | ITEMTYPE | TURNOVER |
| I5 | STATIONARY | 3400000 |
| I7 | HOISTERY | 6500000 |
| I2 | BAKERY | 10090000 |
(a) To display the CODE and NAME of all salesperson having “I7” item Type Code from the table SALESPERSON.
(b) To display all details from table SALESPERSON in descending order of SALARY.
(c) To display the number of SALESPERSON dealing in each TYPE of ITEM.(Use ITCODE for the same)
(d) To display NAME of all the salesperson table along with their corresponding ITEMTYPE from the ITEM table.
(e) Select max(salary) from salesperson;
(f) Select distinct itcode from salesperson;
(g) select code,name,i.itcode from sales persons, item i where s.itcode=i.itcode and turnover>=7000000;
(h) Select sum (salary)from salesperson where itcode=”i2”;