Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account: CHECKING : Acct No, Date

A bank has three types of accounts: checking, savings, and loan.

Following are the attributes for each type of account:

CHECKING: Acct No, Date Opened, Balance, Service Charge

SAVINGS: Acct No, Date Opened, Balance, Debit Interest Rate

LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment

Using generalization, develop an EER (Enhanced Entity-Relationship) model segments to represent the following situations:

  1. Assume that each account must exactly one of these subtypes.
  2. Assume that each account must be at least one of these subtypes.

  1. Create the diagrams in the app.diagrams.net website, export as a .png or .jpeg file
  2. The diagram should be similar like this and should be done on app.diagrams.nets websiteimage text in transcribed
BRANCH CUSTOMER PK Customer PK Branchi Address BY Name Address LOAN ACCOUNT PK ACCID AccType PK LoanID Amount InterestRate

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Focus On Geodatabases In ArcGIS Pro

Authors: David W. Allen

1st Edition

1589484452, 978-1589484450

More Books

Students also viewed these Databases questions