Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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 payment

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Relational Database And SQL

Authors: Lucy Scott

3rd Edition

1087899699, 978-1087899695

More Books

Students also viewed these Databases questions

Question

Which are non projected Teaching aids in advance learning system?

Answered: 1 week ago