Database Design Assignment | Problem Analysis

Added on - 18 Sep 2019

  • 6

    Pages

  • 1233

    Words

  • 135

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 3 of 6 pages
Problem AnalysisTo design a database for a financial service provider as discussed in my assignment, first there arebranches of the service provider and in all the branches there are employees and employees are headedby branch manager which is present in each branch. A person can be customer by opening their accountin any of the branch and each customer is guided by the bank employee and in future he will be hismentor to do any stuff in the bank. After opening their account in the bank customer can able to withdraw,deposit and transfer money to another account. Customer can also able to change its details like address.The design of the database should handle all this stuff and everyone can able to do their task correctly.UsersUserBrief DescriptionFunction NeededBank EmployeeThe person who work in anybranch of the bank.They will able to create a new accountfor the customer and provide help inthe future and can manage existinguser.CustomersThe person who has bankaccount.They will be able to update theirpersonal details and do all the bankingstuff.EntitiesKey:Red Text = Brief Description,Green Text = Relationship descriptionsBranch-Contain all the information of all branches.A branch is related to the its employee.Employee-Contain all the information of each employee of their respective branch.Employee will addthe new user for the branch and access the type of account.Customer-Contain all the personal information of each customer.Customer will do transaction and canaccess its account.Transaction-Contain the record of all the transaction done by the user.Transaction is done by anycustomer and with each transaction there is updation in customer accounts.AccountType-Contain how many types of account is provided by the bank.Employee will access theaccount type to see the data of all accounts.Accounts-Contain the banking information of all the customers.Accounts of user keep on updatingwhile the customer will do any transaction.CustomerAccounts-Contain the information of related account number.Relation between thecustomers is there.
Entities with AttributeKey: (E) = Entity, (R, between [E] and [E]) = RelationshipBranch (E)branchNumber {PK}- Unique number for each branch.branchManager- Manager of the branch.branchAddress- Address of the the branch.Employee (E)employeeID {PK}- Unique ID of employee.employeeName- Name of the employee.Consists (R, between employee and branch)branchNumber {FK}- Branch number to which employee is associated.Customer (E)customerID {PK}- ID of the customer.customerName- Name of the customer.customerAddress- Address of the customer.customerDateTime- Date and time on which customer account is generated.Generates(R, between customer and employee)holdStatus- Status of the customer account that is active or inactive.Transaction (E)transactionID {PK}- ID of transaction.transactionType- Type of the transaction.amount- Amount of the transaction.Do(R, between customer and transaction)customerID {FK}- ID of the customer who done transaction.receiverID {FK}- ID of the customer who receives money.Account Type (E)accountNumber {PK}- Account number of each account type.accountType- Type of account.Intrest- Intrest given by the bank.minBalance- Minimum balance for that account.maxCreditLimit- Maximum credit limit given to this account.fees- Fees taken by the bank.Accounts (E)accountID {PK}- Accountid of accounts.employeeID {FK}- Employee ID of the employee associated with account.Balance- Remaining balance of the account.creditLimit- Credit limit of the account given by employee.Give type(R, between accountType and account)accountNumber {FK}- Account number of which account is managed.holds(R, between customer and account)customerID {FK}- ID of the customer.
Customer Accounts (E)customerAccountID {PK}- Unique ID of customer account.customerIDs- All IDs of customer to a particular account.getDetails(R, between account and customerAccount)accountID {FK}- ID of the customer account.
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document