1 2.1.1 Transaction Details Module 3 Functional Requirements 5 1) To display the transactions made by customers living in a given zipcode for a given month and year. Order by day in descending order. 6 Everything from credit card table and customer zip code 8 2) To display the number and total values of transactions for a given transcation type. 9 total number of transactions, sum of the transaction value, and transaction type 10 11 3) To display the number and total values of transactions for branches in a given state 12 total number of transactions, sum of the transaction value, and branch state 13 14 2.1.2 Customer Details Module 15 16 Functional Requirements 17 18 1) To check the existing account details of a 19 custoner. 20 everything from custoner table 21 22 2) To modify the existing account details of a 23 customer 24For this you need to perform update 25 26 Update- you will ask the user to update flelds for custoner table (except ssn) based on ssn 27 3) To generate monthly bi11 for a credit card number for a given month and year. 28 .sum of the transaction value, month and year fron credit card 29 4) To display the transactions nade by a customer between two dates. Order by year, month, and day in descending order. 31everything from credit card table and display month, day, year in a single column using concat function 1 2.1.1 Transaction Details Module 3 Functional Requirements 5 1) To display the transactions made by customers living in a given zipcode for a given month and year. Order by day in descending order. 6 Everything from credit card table and customer zip code 8 2) To display the number and total values of transactions for a given transcation type. 9 total number of transactions, sum of the transaction value, and transaction type 10 11 3) To display the number and total values of transactions for branches in a given state 12 total number of transactions, sum of the transaction value, and branch state 13 14 2.1.2 Customer Details Module 15 16 Functional Requirements 17 18 1) To check the existing account details of a 19 custoner. 20 everything from custoner table 21 22 2) To modify the existing account details of a 23 customer 24For this you need to perform update 25 26 Update- you will ask the user to update flelds for custoner table (except ssn) based on ssn 27 3) To generate monthly bi11 for a credit card number for a given month and year. 28 .sum of the transaction value, month and year fron credit card 29 4) To display the transactions nade by a customer between two dates. Order by year, month, and day in descending order. 31everything from credit card table and display month, day, year in a single column using concat function