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

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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