Erd diagram of new system database structure

Assignment Help Operation Management
Reference no: EM133483948

Question

Your company is responsible to ensure the successful merger between two Banks and their systems. The first bank has an old legacy system for their savings product which is linked to a modern Customer Relationship Management system. This system has the saving product and carries an account balance for each client. The second bank has a system that has a loan product. The loan product carries the client details and loans linked to the client in the same system. This includes client details, and the original loan amount, the loan term, interest rate, instalment amount and the balance of the loan. It is agreed by the project stakeholders that both products will be created on a new cloud-based banking system that has a configurable product module and can accommodate both savings and loan products. The CRM system shall be used to store all customer information while the new banking system shall store the products, as well as the account information around the current state of each account. The new banking system shall host the savings accounts, as well as the "run down" of all the loan accounts from the take-on date (to the new system), for the clients after migration. The old legacy saving system shall be decommissioned, and the previous loan management system made inactive so that no new business can be acquired, but a balance breakdown still available for lookup (up to the point where the migration occurred). All new clients will be in the CRM system and accounts in the new banking system. The migration of data shall occur after hours between 10pm and 4 am, from the old to the new systems. Please consider the above scenario and provide the following:

1. A context diagram.

2. A logical ERD diagram of the new system database structure.

3. A process for how this solution will be delivered by the project.

4. A sequence diagram of the new system client and balance lookup.

5. List all the types of requirements in the above scenario.

 

 

Reference no: EM133483948

Questions Cloud

Restaurant culture relating : Write a discussion board post summarizing the article and expressing your thoughts on restaurant culture relating to Joe Beef or the industry.
What additional information would you want to have to make : COUC 521- Given this technical information, which of instruments would you select? What additional information would you want to have to make your decision?
Describe the impact that the affordable care act : Describe the impact that the Affordable Care Act (ACA) has had on health insurance.
Identify one behavior that you would like to change : Identify one behavior that you would like to change, set one goal addressing this behavior, and one objective which will be first step towards achieving goal.
Erd diagram of new system database structure : Your company is responsible to ensure successful merger between two Banks and their systems. A logical ERD diagram of the new system database structure.
Welding service for construction and automotive repair jobs : Gubser Welding, Inc., operates a welding service for construction and automotive repair jobs. What is the average number of jobs waiting for service?
How the user want to play the game : Start by welcoming the user and asking how they want to play it, either 2 players or a single player against the computer.
What drew you to nursing : What drew you to nursing? - What is your current practice role title and role responsibilities? - What are the advantages of your current practice role?
What is the effect of the adaptation step of lms algorithm : What is the effect of the adaptation step of the LMS algorithm? What is the advantage of increasing or reducing its value?

Reviews

Write a Review

Operation Management Questions & Answers

  Discuss the position of employees within firms and companies

Discuss the position of employees within firms and companies, and the ethical issues arising from their relations with shareholders.

  Quantity sold will total contribution margin be maximized

The Pampered Pooch sells high-end pet furniture, specializing in small breed dogs. The most popular item is the memory foam dog bed, with the following demand curve: Q = 21,600, 221(P). While expensive, the bed comes with a washable cover and free sh..

  Disadvantages of outsourcing key management functions

Assuming that you do not possess all of the skills to carry out every business function, which management skill would you acquire first, and why? What are the advantages and disadvantages of outsourcing key management functions, such as marketing and..

  Operating lease arrangement

The company will use an operating lease arrangement. (34%) tax bracket. What is the Present Value (PV) for these two alternatives? Use j (15%). Be sure to fully justify your answer. Use time lines. Prove first Dace in your answer.

  Competence generation and personnel management

Explain the complementarity of three societal spaces – systems of corporate governance, competence generation/personnel management and employment relations.

  Disadvantages of developing an enterprise resource plan

What are the 3 advantages and 3 disadvantages of developing an Enterprise Resource Plan?

  Race to the bottom as criticism of global economic activity

Describe the race to the bottom as a criticism of global economic activity.

  What is the role strategic management practice

What is the role strategic management practice in Microsoft Corporation?

  Explain the logic of the laststatement

In this instance, you can narrow the set of choices, but you probably wouldn't make a recommendation without an additional piece of information. Explain the logic of the laststatement.

  Identify the best value discipline-generic strategy

Write a paper of no more than 1,400 words that evaluates alternatives an organization must consider to realize growth. Identify the best value discipline, generic strategy, and grand strategy for your organization.

  Hmc include in new ais to describe each inventory item

What data elements should HMC include in the new AIS to describe each inventory item?

  Overview of the various forms of business ownership

Provides and overview of the various forms of business ownership. Describe one of the forms in terms of its advantages and disadvantages.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd