Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Consider the following bank database: BANK(Code, Name, Addr) BANK_BRANCH(Code, BranchNo, Addr) ACCOUNT(AcctNo, Balance, Type, Code, BranchNo) LOAN LoanNo, Amount, Type, Code, BranchNo) CUSTOMER(SSN, Name,
3. Consider the following bank database: BANK(Code, Name, Addr) BANK_BRANCH(Code, BranchNo, Addr) ACCOUNT(AcctNo, Balance, Type, Code, BranchNo) LOAN LoanNo, Amount, Type, Code, BranchNo) CUSTOMER(SSN, Name, Addr, Phone) DEPENDENT(SSN,dname, bdate, sex) A C(AcctNo,_SSN) L C(LoanNo, SSN) Write a query to find the number of customers who have dependents but do not have any loans. Create views for the subquery parts and use the set difference operator
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Modern Database Management
Authors: Jeffrey A. Hoffer Fred R. McFadden
9th Edition
B01JXPZ7AK, 9780805360479
