Question: Create an ER from the following requirement. Use Chen notation with participation andcardinality notation and make a separate diagram with UML notation. If you make

Create an ER from the following requirement. Use Chen notation with participation andcardinality notation and make a separate diagram with UML notation. If you make anassumption that is not in the requirements, please note this on the ER. Send yourcompleted ERs to me via e-mail. Be sure to include your name and section in theattachment.Banking: Create a database for a typical bank. We will track customers of the bank to includelast name, first name, address and customer type (business, joint, personal). The bank has varioustypes of accounts that we will track (checking, savings, bond). A customer may have multipleaccounts of each type. Accounts also have a balance, an interest rate and a date opened. Anaccount may be owned by one customer only. For each account you must keep track of all thetransactions on the account. Transaction types consist of deposits, withdrawals, and transfers.Each transaction consists of the amount, type (deposit, withdrawal, transfer), date, and account(s)for the transaction. Each transaction also has a location (app, teller, atm) and may have multiplecomments. Customers will need to be sorted by state. Please show image of the diagram

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!