Please convert following figure into a relational schema. In each table, the primary key and foreign keys (arrows) must be identified.

Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter2: Data Models
Section: Chapter Questions
Problem 11P
icon
Related questions
Question
Please convert following figure into a relational schema. In each table, the primary
key and foreign keys (arrows) must be identified.
BANK
N
BRANCHES
BANK BRANCH
Code
Name
Addr
Addr
Branch no
ACCTS
LOANS
Acct_no
Balance
Loan no
Amount
ACCOUNT
Туре
Туре
LOAN
M
AC
LC
Sn
Name
Phone
CUSTOMER
Addr
Transcribed Image Text:Please convert following figure into a relational schema. In each table, the primary key and foreign keys (arrows) must be identified. BANK N BRANCHES BANK BRANCH Code Name Addr Addr Branch no ACCTS LOANS Acct_no Balance Loan no Amount ACCOUNT Туре Туре LOAN M AC LC Sn Name Phone CUSTOMER Addr
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Normalization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning