Question

On the basis of following table answer the given questions:
3
Table: CUSTOMER DETAILS
I Cust_ID CustName Acct_Type Acoumit_Amt DOJ I Gender
I CNR_001 | Manoj Saving ! 101250 1992-02-19 M
CNR_002 Rahul Current 132250 I 1998-01-11 1 M
I CNR 004 Steve Saving | 18200 I 1998-02-21 | M
CNR_005 Manpreet Current 1 NULL 1994-02-19 M
O Write the degree and cardinality of the above table.
(m) What will be the output of the following query :
Select max(DOJ) From Customer_Details,
(1) Write the sol query to delete the row from the table where customer
has no accumulated amount.​

Answer 1

Answer:

The degree is 6 and cardinality is 5. (ii) +------------+ |max(DOJ)| +------------+ |1998-02-21| +------------+ (iii) Delete from Customer_Details where Accumlt_Amt is NULL;Read more on Sarthaks.com - https://www.sarthaks.com/508263/i-write-the-degree-and-cardinality-of-the-above-table?show=508269#a508269