2. Henry has been hired as a systems analyst to work on an information system project for a library. Currently, books are ordered manually. Three librarians receive a checklist containing details of forthcoming books and journals everý week. Each one places checkmarks against the books they think should be ordered. The three marked lists are then reviewed by a head librarian, who finalizes the list of books and the quantity to be ordered. The final list is sent to a clerk, who mails it to the appropriate publishers for orders. A systems analyst is designing an app that automates loan application processes. However, many factors must be considered before a loan can be processed or verified by the system. The analyst has described the different scenarios as follows:

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%

want accurate answer

If answer copied from existing answer from chegg or bartleby I report the answer to support team

dont post existing answers

 

2. Henry has been hired as a systems analyst to work on an information system project for a library.
Currently, books are ordered manually. Three librarians receive a checklist containing details of
forthcoming books and journals every week. Each one places checkmarks against the books they think
should be ordered. The three marked lists are then reviewed by a head librarian, who finalizes the list of
books and the quantity to be ordered. The final list is sent to a clerk, who mails it to the appropriate
publishers for orders.
A systems analyst is designing an app that automates loan application processes. However, many factors
must be considered before a loan can be processed or verified by the system. The analyst has described
the different scenarios as follows:
The app first checks whether the loan applicant is an existing customer or a new one. For existing
customers, the system first verifies the age of the customer, followed by their source of income, the
amount of monthly income, and the loan applied for. It then displays whether the application has been
processed successfully.
If the age of an applicant is less than 30 and they receive a monthly salary of up to $30,000, their eligibility
ranges between a minimum of $200,000 for no less than five years' duration and a maximum amount of
$500,000, payable in at least 10 years. Those who earn more than $30,000 a month are eligible for
$500,000, payable in at least five years, and a maximum amount of $1,000,000, payable in at least 10
years. For those who earn from búsinesses, similar slabs apply, but an additional document verification
and a registered TaxPayerID is required. Finally, those who earn less than $10,000 a month are not eligible
for a loan.
All the applicants aged between 30 and 60 years are eligible for a maximum amount of $500,000 for a
minimum duration of five years. For those who have retired, the eligible amount is capped at $200,00,
payable in at least five years.
For new customers, their credit rating is verified first. If found acceptable, they too are eligible for loan
applications according to the slabs mentioned above. The application is rejected if their credit rating is
unacceptable.
a) Draw a decision tree for this scenario.
b) Create a decision table with the minimum number of rules for this scenario.
Transcribed Image Text:2. Henry has been hired as a systems analyst to work on an information system project for a library. Currently, books are ordered manually. Three librarians receive a checklist containing details of forthcoming books and journals every week. Each one places checkmarks against the books they think should be ordered. The three marked lists are then reviewed by a head librarian, who finalizes the list of books and the quantity to be ordered. The final list is sent to a clerk, who mails it to the appropriate publishers for orders. A systems analyst is designing an app that automates loan application processes. However, many factors must be considered before a loan can be processed or verified by the system. The analyst has described the different scenarios as follows: The app first checks whether the loan applicant is an existing customer or a new one. For existing customers, the system first verifies the age of the customer, followed by their source of income, the amount of monthly income, and the loan applied for. It then displays whether the application has been processed successfully. If the age of an applicant is less than 30 and they receive a monthly salary of up to $30,000, their eligibility ranges between a minimum of $200,000 for no less than five years' duration and a maximum amount of $500,000, payable in at least 10 years. Those who earn more than $30,000 a month are eligible for $500,000, payable in at least five years, and a maximum amount of $1,000,000, payable in at least 10 years. For those who earn from búsinesses, similar slabs apply, but an additional document verification and a registered TaxPayerID is required. Finally, those who earn less than $10,000 a month are not eligible for a loan. All the applicants aged between 30 and 60 years are eligible for a maximum amount of $500,000 for a minimum duration of five years. For those who have retired, the eligible amount is capped at $200,00, payable in at least five years. For new customers, their credit rating is verified first. If found acceptable, they too are eligible for loan applications according to the slabs mentioned above. The application is rejected if their credit rating is unacceptable. a) Draw a decision tree for this scenario. b) Create a decision table with the minimum number of rules for this scenario.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Distributed Database Concepts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education