Answered step by step
Verified Expert Solution
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
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 AccountsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started