Reports to BRANCH BranchID BranchName OHBranchAddress (Street1, Street2, City, State, ZIP) Phone ACCOUNT CUSTOMER AcctNumber DateOpened CurrentBalance CustomerID Name (fname, Iname) {Customer Category} AccountType d L S CHECKING SAVING LOAN OriginalAmt InterestRate ServiceCharge InterestRate Payment

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
icon
Related questions
Question

Draw the logical database design for the following Entity Relationship Diagram for the branches of a bank:

Reports to
BRANCH
BranchID
BranchName
BranchAddress
(Street1,
Street2, City,
State, ZIP)
Phone
ACCOUNT
CUSTOMER
AcctNumber
DateOpened
CurrentBalance
AccountType
CustomerID
Name (fname,
Iname)
{Customer Category}
d
C
L
S
CHECKING
SAVING
LOAN
OriginalAmt
InterestRate
ServiceCharge
InterestRate
Payment
Transcribed Image Text:Reports to BRANCH BranchID BranchName BranchAddress (Street1, Street2, City, State, ZIP) Phone ACCOUNT CUSTOMER AcctNumber DateOpened CurrentBalance AccountType CustomerID Name (fname, Iname) {Customer Category} d C L S CHECKING SAVING LOAN OriginalAmt InterestRate ServiceCharge InterestRate Payment
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Enhanced ER Model
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning