Design operational database to support the process described

Assignment Help Database Management System
Reference no: EM131536088

Assignment: Data Modeling Challenge

Who are we?

Funding Circle is the world's leading marketplace exclusively focused on small businesses. We provide a platform for businesses to borrow directly from a wide range of investors.

Objective

Imagine Funding Circle hasn't been built yet. There is no website or backend application. It is just an idea in somebody's mind and we have chosen you to help us model the systems from scratch. We require you to translate the below requirements into a logical data model and present this in the most appropriate way. Please note - we are looking for database structure not a process flow.

Loan lifecycle process:

• Small businesses (borrowers) can apply for a loan

• If the application is successful, it is listed on a marketplace where multiple investors can fund a part of the loan (loan part), until the full amount of the loan has been funded.

• Once a loan has been fully funded, the borrower receives the full amount and a monthly repayment schedule is generated.

• The borrower then makes a repayment according to the schedule, that repayment gets distributed between investors according to the value on each loan part.

• In addition to the initial purchase of the loan parts there is a secondary market where Loan part can be bought or sold to a different investor.

• There is no limit on how many times a loan part can be bought or sold.

Requirements:

1. Design operational database to support the process described above

2. Design reporting database schema (if different from the above) to serve Daily snapshot report:

- Be able to report total outstanding amount per Investor per day (any historical day) , taking in account repayments.

- Be able to report unique number of businesses Investor being exposed to per day (any historical day)

Provide reasoning for your decisions.

Reference no: EM131536088

Questions Cloud

Explain the structure and genetic properties of dna : Describe the structure and genetic properties of DNA. Outline the DNA typing techniques. Identify the methods used to test DNA.
What is the amount of the income taxes expense : Selected account balances from the adjusted trial balance for Zen Corporation as of its calendar year-end December 31, 2011, follow.
Internal and external od professionals : Describe the advantages and disadvantages of internal and external OD professionals impact on organizational change?
Identify which company stock you would recommend : Summary information from the financial statements of two companies competing in the same industry follows.
Design operational database to support the process described : Design operational database to support the process described above. Design reporting database schema to serve Daily snapshot report.
Describe the functions of ancient myths : Describe the functions of ancient myths, using examples from two (2) different neolithic cultures, and comment on whether myth is inherently fictional
Compute days sales in inventory : Selected year-end financial statements of McCord Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2010.
What would be the selling price today : What would be the selling price today of a 10% coupon bond of 3 year maturity (maturity value $1,000)?
Prepare a table showing park current ratio : Park Corporation began the month of May with $650,000 of current assets, a current ratio of 2.50:1, and an acid-test ratio of 1.10:1.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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