code BANK name address accountNo branches N ACCOUNT offers balance tyne address BRANCH 1 loans branch No LOAN amount type

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
code
BANK
branches
N
ACCOUNT
loanNo
enrolls
CUSTOMER
phone
address
name
Q1. Transform the ERD above to its corresponding Relational Schema.
Q2. Using the transform ERD, Write appropriate SQL DDL statement to define the database.
Q3. Specify the following queries in SQL.
a.) Retrieve all account numbers with balance greater than 100,000.
b.) Retrieve the bank name, branch name and account number of each customer account.
c.) Find the average loan per branch.
Q4. Write SQL update statements to do the following.
a.) Insert new customer Manuel Cruz, with social security number of 987-65-4320 who lives
at Iligan City and a contact number of 09170000001
b.) Marie Sanchez's loan amount was increased by 15,000.
c.) Sergio Ramos opened a checking account with a minimum balance of 150,000
d.) Remove the account record with account number 262262100
name
address
accountNo
SSN
M
N
N
offers
balance
address
type
N
BRANCH
loans
M
applies
N
branch No
LOAN
amount
type
Transcribed Image Text:code BANK branches N ACCOUNT loanNo enrolls CUSTOMER phone address name Q1. Transform the ERD above to its corresponding Relational Schema. Q2. Using the transform ERD, Write appropriate SQL DDL statement to define the database. Q3. Specify the following queries in SQL. a.) Retrieve all account numbers with balance greater than 100,000. b.) Retrieve the bank name, branch name and account number of each customer account. c.) Find the average loan per branch. Q4. Write SQL update statements to do the following. a.) Insert new customer Manuel Cruz, with social security number of 987-65-4320 who lives at Iligan City and a contact number of 09170000001 b.) Marie Sanchez's loan amount was increased by 15,000. c.) Sergio Ramos opened a checking account with a minimum balance of 150,000 d.) Remove the account record with account number 262262100 name address accountNo SSN M N N offers balance address type N BRANCH loans M applies N branch No LOAN amount type
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY