Question: Need the answer for Q3 please * Question Completion Status: A small local lending company, ACME Bank, has been using Excel for many years to

Need the answer for Q3 please * QuestionNeed the answer for Q3 please * Question Need the answer for Q3 please

* Question Completion Status: A small local lending company, ACME Bank, has been using Excel for many years to track their loans, They have decided to build a database and have asked you to do a data mapping to show how the database might look. Basically, they have currently have all the data in the one Excel file. The table below contains details of each field and there explanations. Please map this out as a third relational form database. Write out each table, columns, keys and relations, as we did in class. Column Explanation Client Name The name of the person requesting the loan Client Address The complete address of the client, including city state and zip Date of birth Client date of birth SS number The clients SS num Credit (FICO) score Clients credit score. The credit score comes from third party agencies like Experian and Transunion. Loan amount The amount of the loan requested Loan purpose Values in the spread sheet are AUTO, HOME, MEDICAL, PERSONAL, OTHER Outstanding Debt The amount of outstanding debt that the client current holds with all their open accounts (This amount come from the credit reports as well) Loan officer The name of the loan officer who is in charge of approving or denying the loan. Loan officers are employees of the company. Loan status Values in the spreadsheet are A (Approved), P (Pending), D (Denied), 1 (more information needed) Reviewed by The name of the employee who reviews the loan. This person checks over and reviews the loan to ensure that the proper steps were taken Comments This is a space for ACME employees to add comments about a customer. There may be many comments added for a customer as different events happen during the loan process. QUESTION 3 18 points Saved For the above ACME bank example, judge whether the following are valid and appporiate IT project risks for this project. State why or why not these are IT project risks: a- Larger banks are coming to our town which may take business from us. They may affect the budget, time and scope of the project. b- The Excel spreadsheet that currently holds ACME's information is missing a substantial amount of data. This may end up taking more time to fix the data and take longer to import the data into the new database. This would affect the timeline and budget C- One of our main users is not good at system design at all and is not cooperative either. This would affect the timeline of the project. d- Prime interest rates are rising, this may discourage clients from taking out loans. This would affect the budget of the project e- A key member might quit the project which would cause time delays until we find a new replacement

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!