(i) Write the degree and cardinality of the above table.

Question

On the basis of following table answer the given questions:

Table: CUSTOMER_DETAILS

Cust_ID	Cust_Name	Acct_Type	Accumlt_Amt	DOJ	Gender
CNR_001	Manoj	Saving	101250	1992-02-19	M
CNR_002	Rahul	Current	132250	1998-01-11	M
CNR_004	Steve	Saving	18200	1998-02-21	M
CNR_005	Manpreet	Current	NULL	1994-02-19	M

(i)  Write the degree and cardinality of the above table.

(ii)  What will be the output of the following query : Select max(DOJ) From Customer_Details;

(iii)  Write the sql query to delete the row from the table where customer has no accumulated amount.

Answer 1

(i) The degree is 6 and cardinality is 5.

(ii) +------------+

|max(DOJ)|

+------------+

|1998-02-21|

+------------+

(iii) Delete from Customer_Details where Accumlt_Amt is NULL;