Get your original paper written from scratch starting at just $10 per page with a plagiarism report and free revisions included!
Imagine that you and your classmates are a research team developing an improved process for evaluating auto loan applicants. The goal of the research is to predict which applicants will become delinquent or forfeit their loan. Those who score well on the application will be accepted; those who score exceptionally well will be considered for lower-rate loans. Prepare a brief report for your instructor addressing these questions:
a. What data do you need for each loan applicant?
b. What data might you need that is not typically requested on a loan application form?
c. Where might you get this data?
d. Take a first cut at designing a database for this application. Using the chapter material on designing a database, show the logical structure of the relational tables for this proposed database. In your design, include the data attributes you believe are necessary for this database, and show the primary keys in your tables. Keep the size of the fields and tables as small as possible to minimize required disk drive storage space. Fill in the database tables with the sample data for demonstration purposes (ten records). After your design is complete, implement it using a relational DBMS.