Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Study the diagram for Bank checking accounts How would you modify it so that a customer could have more than one address? Please post a

Study the diagram for Bank checking accounts

image text in transcribed

How would you modify it so that a customer could have more than one address? Please post a picture of your changes.

Data Model for Banking Checking Accounts Barry illiams DatabaseAnswers.org June 2nd. 2014 Addresses address id line 1 Customers customer id FR address_id customer name customer_phone customer email date became customer other details city zip postcode state_province_county country other address details Accounts account_id customer id account name date_opened date closed current balance other account details Merchants merchantid merchant name merchant_phone merchant email other details - Ref_Expense_Categories PR category_code FR parent_ category_code Transactions transactionid account id expense_category_description eg Parent Category = Food. eg Subcategory Groceries, Takeout, etc - fR expense_category_code merchant id Ref Transaction_Types Fpurchase_id PR transaction_type_code F transaction type_code date_of_transaction transaction_type_description eg Deposit, Withdrawal amount balance other details NOTE Items in Transactions reflect one of my Bank Statements and may vary with other Banks or Accounts Data Model for Banking Checking Accounts Barry illiams DatabaseAnswers.org June 2nd. 2014 Addresses address id line 1 Customers customer id FR address_id customer name customer_phone customer email date became customer other details city zip postcode state_province_county country other address details Accounts account_id customer id account name date_opened date closed current balance other account details Merchants merchantid merchant name merchant_phone merchant email other details - Ref_Expense_Categories PR category_code FR parent_ category_code Transactions transactionid account id expense_category_description eg Parent Category = Food. eg Subcategory Groceries, Takeout, etc - fR expense_category_code merchant id Ref Transaction_Types Fpurchase_id PR transaction_type_code F transaction type_code date_of_transaction transaction_type_description eg Deposit, Withdrawal amount balance other details NOTE Items in Transactions reflect one of my Bank Statements and may vary with other Banks or Accounts

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions