Qn1 20 Marks Leading Australian Bank Maintaining Customer Details Based Following Database Q43871904
Qn1. 20 Marks A leading Australian bank is maintaining its customer details based on the following database table structure. Customer Customer_ID Name Count of Accounts Ex: 1001 Amber 1 Ex: 1002 Aiden 2 Accounts Account_ID Ex: A101 Ex: A102 Ex: A103 Customer_ID Account_Type Balance 1001 Savings 1200 1002 Savings 1000 1002 Cheque 800 The bank has approached you to develop a simple menu drive program to read and manage customers and account details. The bank has made the following requirements: a. The program should be menu-driven b. A customer could maintain zero (0) or more accounts c. Each account to be linked to a customer d. The types of accounts are Savings. Cheque, Credit, and Transaction e. Except for Savings, all other accounts can have negative balances f. Your program should be capable of creating and storing any number of customers with zero to four accounts for each customer g Your program should have the facility to search customer by customer name h. Your program should have the facility to calculate the total balance across all the accounts for a customer i. Your program should have the facility to calculate the total balances across all the accounts j. The program should have the facility to display all customers and account details As part of this assessment, you are required to develop a C-language-based program to fulfil the above requirements. Your program should be based on the following instructions: a. Use appropriate C-language constructs to create customer records – Structures b. Use appropriate C-language constructs to create account records – Nested Structures C. Ensure your approach allows a customer to maintain 0 or many accounts d. Use enum to create account types e. Use dynamic memory allocation to create and maintain any number of customers and accounts. f. Total balance calculation should be done using Recursive Function Show transcribed image text Qn1. 20 Marks A leading Australian bank is maintaining its customer details based on the following database table structure. Customer Customer_ID Name Count of Accounts Ex: 1001 Amber 1 Ex: 1002 Aiden 2 Accounts Account_ID Ex: A101 Ex: A102 Ex: A103 Customer_ID Account_Type Balance 1001 Savings 1200 1002 Savings 1000 1002 Cheque 800 The bank has approached you to develop a simple menu drive program to read and manage customers and account details. The bank has made the following requirements: a. The program should be menu-driven b. A customer could maintain zero (0) or more accounts c. Each account to be linked to a customer d. The types of accounts are Savings. Cheque, Credit, and Transaction e. Except for Savings, all other accounts can have negative balances f. Your program should be capable of creating and storing any number of customers with zero to four accounts for each customer g Your program should have the facility to search customer by customer name h. Your program should have the facility to calculate the total balance across all the accounts for a customer i. Your program should have the facility to calculate the total balances across all the accounts j. The program should have the facility to display all customers and account details As part of this assessment, you are required to develop a C-language-based program to fulfil the above requirements. Your program should be based on the following instructions: a. Use appropriate C-language constructs to create customer records – Structures b. Use appropriate C-language constructs to create account records – Nested Structures C. Ensure your approach allows a customer to maintain 0 or many accounts d. Use enum to create account types e. Use dynamic memory allocation to create and maintain any number of customers and accounts. f. Total balance calculation should be done using Recursive Function
Expert Answer
Answer to Qn1. 20 Marks A leading Australian bank is maintaining its customer details based on the following database table struct…
OR