Create an app in salesforce simulating the functionalities

Assignment Help Other Subject

Reference no: EM133036296

Data Modelling

- Create an app in salesforce simulating the functionalities of a Bank (App Label: "Bank").
- It should have following tables to store data Bank, Branch, Account, Loan, Loan Detail and transaction.
- A bank can have many branches and any branch cannot exist without a bank.
- A branch has many accounts and an account cannot exist without a branch.
- An account can be shifted to any other Branch.
- Every account has transactions greater than or equal to 0. Transaction cannot exist without an account.
- There are predefined loans for banks. Each account can have more than one loan. And each loan can be taken by more than one account.
- Every object should have appropriate fields according to them.
- Savings Account can only be created if starting balance is greater than equals to 10000 (minimum balance).
- Current Account can only be created if starting balance is greater than equals to 25000 (minimum balance).
- Savings Minor Account can only be created if starting balance is greater than equals to 2500 (minimum balance).
- The daily limit of an account depends on the account type. Both of them have pre-defined values.
- Branch should display the number of accounts it holds as Total Number of Accounts.
- Bank should display the total number of branches it has.
- Transaction should be of two types withdraw or deposit.
- Account should display the average transaction the particular account has, both in withdrawing and depositing as separate.
- Loan table should include the details necessary for the loan like tenure, rate of interest, number of installments etc.
- Loan Detail should store the data for a particular loan on an account.
- And also validate all the fields required in every object.
- Display remaining amount, remaining number of installments at loan detail record using related loan records.
- Balance field on account must be calculated using the related transactions records.
- The balance in account should not be less than the minimum balance as described above.

Attachment:- Data Modelling Assignment.rar

Reference no: EM133036296

Questions Cloud

Explain the duties owned by directors and offers : Xyz Pty ltd is 50% owned by Big LTD. In 2009 Ltd. was approached by BLACK Ltd. The other shareholders in xyz, to make further major investment in xyz, to enable

Advantages of addressing complex issues in the workplace : Question 1: Describe how legislation may be applicable to workplace problems (provide an example as part of your answer).

What would be your monthly payment to pay off the loan : Instead of going through a dealer's financing, you want to make a down payment of $1,800. What would be your monthly payment to pay off the loan

Role of the executive housekeeper : The new & young worker When it comes to New and Young Worker Training, employers are required to orientate and train all workers "before" work begins, on safe w

Create an app in salesforce simulating the functionalities : Create an app in salesforce simulating the functionalities of a Bank and Display remaining amount, remaining number of installments at loan detail record

Find ratios use de-levered net income : Which of the following ratios use de-levered net income? (check all that apply)

What is net income : Given number: Asset beginning of the year is 26,000 - If the owner contributed 8,800 and withdraw 44,500, what is net income

Compute the company acid-test ratio for year two : Question - Refer to the following selected financial information from Fennie's, LLC. Compute the company's acid-test ratio for Year 2

Enrollment management specialization : Enrollment management has evolved over the past 25 years into an essential function of a college or university.

User Account

All Pages