Question#4 Answer below question, considering the relational database as represented in the following tables. acct_id A-301 A-307 A-318 A-319 A-322 loan_id L-421 L-445 L-437 L-419 branch_name New York Seattle Los Angeles New York Los Angeles branch_name San Francisco Los Angeles Las Vegas Seattle balance 350 275 550 80 275 account amount 7500 2000 4300 2900 loan cust_name acct_id A-318 A-322 A-319 A-307 A-301 depositor Johnson Smith Reynolds Lewis Reynolds cust_name loan_id Anderson L-437 Jackson L-419 L-421 L-445 borrower Lewis Smith 1. Find names of all customers with a bank account at the bank using relational algebra 2. Find names of all customers with a loan account at the bank using relational algebra 3. Find names of all customers that have either a bank account or a loan at the bank using relational algebra.

Question#4 Answer below question, considering the relational database as represented in the following tables. acct_id A-301 A-307 A-318 A-319 A-322 loan_id L-421 L-445 L-437 L-419 branch_name New York Seattle Los Angeles New York Los Angeles branch_name San Francisco Los Angeles Las Vegas Seattle balance 350 275 550 80 275 account amount 7500 2000 4300 2900 loan cust_name acct_id A-318 A-322 A-319 A-307 A-301 depositor Johnson Smith Reynolds Lewis Reynolds cust_name loan_id Anderson L-437 Jackson L-419 L-421 L-445 borrower Lewis Smith 1. Find names of all customers with a bank account at the bank using relational algebra 2. Find names of all customers with a loan account at the bank using relational algebra 3. Find names of all customers that have either a bank account or a loan at the bank using relational algebra.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Relational databases have six essential characteristics.
Explain the role of data binding in the context of microservices and distributed systems.
The data dictionary plays a significant role in the Database Life Cycle (DBLC) process.
Describe an example of a Web-enabled database environment.
What is The Significant Role Of Metadata
Describe a typical Web-enabled database environment.
Differentiate between database management systems and file-oriented systems.
Differentiate between database management systems and file-oriented systems.
Use of a database has what advantages and disadvantages?
Describe how a physical database is designed.
large scale database