Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Task 1 only, theres a free website to make diagrams if you want. its called draw.io which i have been using for this. Plovide, customet
Task 1 only, theres a free website to make diagrams if you want. its called draw.io which i have been using for this.
Plovide, customet with debit cards for cash ithdrawals ou have been provided with the following business rules about Spock Bank 0 . Every branch of Spock Bank is provided with a unique identifier. Details of a branch clude: name, address, and phone number Each customer is provided with a unique identifier. Details of a customer include: name, . address, contact number, email address, and join date. e An account can be one of many different types. Each type of account has a unique identifier. Each account type needs to include: name, a description, interest rate and a yearly service fee e An account is identified by a combination of BSB and an account number. Details of account such as type of the account and current balance are stored . Every customer with an account may be provided with more than one debit card to withdraw cash. Each debit card has its own card number. Details of a debit card include: expiry date, CVV number, and PIN number Every ATM machine of Spock Bank is provided with a unique identifier. Details of an ATM include: location, opening hours, and maximum cash capacity e Every employee of Spock Bank is provided with a unique identifier. This identifier is used across the all of the branches. Details of an employee would include: name, address, phone number, position and annual salary . e Every department of Spock Bank is provided with a unique identifier. Details of a department would include: name, office location, and a contact number A loan can be one of many different types. Each type of loan has a unique identifier. Each loan type needs to include: name and description o A loan is identified by a unique number. Details of loan such as interest rate, total loan amount, and outstanding balance are stored e . Every cash withdrawal is identified by a withdrawal number. Other details of the withdrawal would include: ATM number - where the withdrawal happened, the card number, date and time of withdrawal, and the withdrawal amount. . Every loan repayment is identified by a repayment number. Other details of the repayment would include: the loan number - what the repayment is for, the repayment amount, date and time of repayment, and the employee who monitors the loan paymentStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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