Lab Report > CS8481-DBMS_LAB_QUESTION_SET_1[1]

1. Create the following tables with given attributes having appropriate data type and specify thenecessary primary and foreign key constraints:Customer (Custid, Custname, Age, phone)Loan (Loanid, Amount, Custid, EMI)a) List the name of the customers who have taken loan for more than Rs.50,000.b) List the Customer id of those who have no loan.c) List the total count of loan availed.d) Create a proc ...[Show More]

Preview 1 out of 5 pages
Purchase this document to unlock the blurred part and the rest of the document

Unlock Now

Reviews( 0 )