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

Need the answer for Q6 please * Question

Need the answer for Q6 please * Question

Need the answer for Q6 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 6 Read through the following statements and determine if they are non-functional requirements for the ACME project. Explain your reasoning: 1. The server will be housed on a cloud storage facility. 2. The system will have the ability to send reminders to loan officers about loans that they need to make decisions on. 3. The server will have Microsoft SQL server installed. 4. The development team will use best programming practices. 5. There will be four resources allocated to this project

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!