1)Consider the following Entities and Relationships
[30 Marks]
Customer (cust_no, cust_name, address, city)
Loan (loan_no, loan_amt)
Relation between Customer and Loan is Many to Many
Constraint: Primary key, loan_amt should be > 0.
Create a Database in 3NF & write queries for following.
• Find details of all customers whose loan is greater than 10 lakhs.
• List all customers whose name starts with 'ba'.
• List names of all customers in descending order who has taken a loan in Nasik city.
• Display customer details having maximum loan amount.
• Calculate total of all loan amount
Find details of all customers whose loan is greater than 10 lakhs.
sql>select customer.cust_name,customers.address from customers,loan,customer_loan where customers.cust_no=customer_loan.cust_no and Loan.loan_no=customer_loan_no and Loan.loan_amt>=10000;
List all customers whose name starts with 'ba'.
sql>select * from customers where cust_name like'ba%';
List names of all customers in descending order who has taken a loan in Nasik city
sql>select customers.cust_name,customers.address from customers,loan,customers,loan,customers_loan where cutomers.cust_no=customer_loan.cust_no and Loan.loan_no=customer_loan.loan_no and customers.city='nashik' orderd by customers.cust_name desc;
Display customer details having maximum loan amount.
sqlselect customers.cust_name,customers.address from customers,loan,customers,loan,customers_loan where cutomers.cust_no=customer_loan.cust_no and Loan.loan_no=customer_loan.loan_no and loan.loan_amt=(select ma(loan.loan_amt)from loan);
Calculate total of all loan amount.
sql>select sum(loan.loan_amt)from loan;
/
Search
Recent Posts
Mail Management System
Posted on 2019-07-18Online food ordering system
Posted on 2019-07-18Library Management System
Posted on 2019-07-17Health center system project
Posted on 2019-07-17Gym Management System
Posted on 2019-07-17furniture management system
Posted on 2019-07-17Electronic shop management system
Posted on 2019-07-17Automobile Workshop Management
Posted on 2019-07-17Online Visa Processing System
Posted on 2019-07-17Inventory management System
Posted on 2019-07-17petrol-management system
Posted on 2019-07-17Cloths management system
Posted on 2019-07-17Society Management system
Posted on 2019-07-17Mall management system
Posted on 2019-07-17school management system
Posted on 2019-07-17Sales Order Processing System
Posted on 2019-07-17Retail sales management
Posted on 2019-07-17Raw Materials Management
Posted on 2019-07-17railway reservation system
Posted on 2019-07-17purchase and sales management system
Posted on 2019-07-17Placement Management System
Posted on 2019-07-17Pet Shop Management System
Posted on 2019-07-17petrol pump management system
Posted on 2019-07-17Patient Information System
Posted on 2019-07-17news agency system
Posted on 2019-07-17Cinema Booking System
Posted on 2019-07-17Medical Store System
Posted on 2019-07-17leave management System
Posted on 2019-07-17Laboratory Information Management System
Posted on 2019-07-17content management system
Posted on 2019-07-17Inventory management System
Posted on 2019-07-17Institute Management System
Posted on 2019-07-17Hotel management System
Posted on 2019-07-17Gym Management System
Posted on 2019-07-17Garage Management System
Posted on 2019-07-17Furniture shop management system
Posted on 2019-07-17Fisheries management System
Posted on 2019-07-17Fertilizer scheduling system
Posted on 2019-07-17online eye care system
Posted on 2019-07-17Dental Clinic Management System
Posted on 2019-07-17Cyber Café Management
Posted on 2019-07-17Milk Billing System
Posted on 2019-07-17Colddrink management system
Posted on 2019-07-17Cable management System
Posted on 2019-07-17Beauty parlor management system
Posted on 2019-07-17Facebook Clone
Posted on 2019-05-28Dance Class Management System
Posted on 2019-05-24Library Management System
Posted on 2019-05-24Cab Management System
Posted on 2019-05-23Blood Bank Management system
Posted on 2019-05-23Beauty Parlour Management System
Posted on 2019-05-23vissa proccesing system
Posted on 2019-05-23Toll Plazza
Posted on 2019-05-23BILLING APPLICATION
Posted on 2019-05-23FLORICULTURE MANAGEMENT SYSTEM
Posted on 2019-05-23Car On Rent
Posted on 2019-05-23E-commers Shop
Posted on 2019-05-23