Scribd Logo
Upload

Welcome to Scribd!

  • 6 views

    CS Assignment

    Uploaded by

    Aayush Upadhyay

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    CS Assignment

    Uploaded by

    Aayush Upadhyay
    6 views2 pages

    Original Title

    CS Assignment.docx

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    6 views2 pages

    CS Assignment

    Uploaded by

    Aayush Upadhyay

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    COMPUTER SCIENCE

    (CODE – 083) Class :-XII


    Unit : Database Management System

    SQL ASSIGNMENT

    Consider a database LOANS with the following table:


    NO NAME LOAN AMT. INT RATE. DATE.
    1 R.K. Gupta 300000 12.00. 19-07-2009
    2 S.P. Sharma 500000 0.00 22-03-2008
    3 K.P. Jain 300000 NULL 08-03-2007
    4 M.P. Yadav 800000 10.00 06-12-2008
    5 S.P. Sinha 200000 12.50. 03-01-2010
    6 P. Sharma 700000 12.50 05-06-2008
    7 K.S. Dhall 500000 NULL 05-03-2008
    Assume that no of installment are 24,41,23,20,10,4,36 respectively. With installment name column
    Write SQL commands for the tasks 1 to 20
    Create Database and use it
    1. Create the database LOANS.
    2. Use the database LOANS.
    Create Table / Insert Into
    3. Create the table Loan_Accounts and insert tuples in it.
    Simple Select
    4. Display the details of all the loans.
    5. Display the AccNo, Cust_Name, and Loan_Amount of all the loans.
    Conditional Select using Where Clause
    6. Display the details of all the loans with less than 40 installments.
    7. Display the AccNo and Loan_Amount of all the loans started before 01-04-2009.
    8. Display the Int_Rate of all the loans started after 01-04-2009.
    Using NULL
    9. Display the details of all the loans whose rate of interest is NULL.
    10. Display the details of all the loans whose rate of interest is not NULL.
    Using DISTINCT Clause
    11. Display the amounts of various loans from the table Loan_Accounts. A loan amount
    should appear only once.
    12. Display the number of instalments of various loans from the table Loan_Accounts. An
    installment should appear only once..
    Using Logical Operators (NOT, AND, OR)
    13. Display the details of all the loans started after 31-12-2008 for which the number of
    instalments are more than 36.
    14. Display the Cust_Name and Loan_Amount for all the loans which do not have number
    of instalments 36.
    15. Display the Cust_Name and Loan_Amount for all the loans for which the loan amount
    is less than 500000 or int_rate is more than 12.
    16. Display the details of all the loans which started in the year 2009.
    17. Display the details of all the loans whose Loan_Amount is in the range 400000 to
    500000.
    18. Display the details of all the loans whose rate of interest is in the range 11% to 12%.
    Using IN Operator
    19. Display the Cust_Name and Loan_Amount for all the loans for which the number of
    instalments are 24, 36, or 48. (Using IN operator)
    Using BETWEEN Operator
    20. Display the details of all the loans whose rate of interest is in the range 11% to 12%.
    (Using BETWEEN operator)

    You might also like