Create an ERD of the given scenarios and ANSWER the questions. The loan office in a bank receives from various party’s requests to investigate the credit status of a customer. Each credit request is identified by a Request ID and is described by a Request Date and Requesting Party Name. The loan office also received results of credit checks. A credit check is identified by a Credit Check ID and is described by the Credit Check Date and the Credit Rating. The loan office matches credit requests with credit check results. A credit request may be recorded before its result arrives; a particular credit result may be used in support of several credit requests. Draw an ERD for this situation. Now, assume that credit results may not be reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again using one entity type. Which of these two versions do you prefer, and why?
Create an ERD of the given scenarios and ANSWER the questions. The loan office in a bank receives from various party’s requests to investigate the credit status of a customer. Each credit request is identified by a Request ID and is described by a Request Date and Requesting Party Name. The loan office also received results of credit checks. A credit check is identified by a Credit Check ID and is described by the Credit Check Date and the Credit Rating. The loan office matches credit requests with credit check results. A credit request may be recorded before its result arrives; a particular credit result may be used in support of several credit requests. Draw an ERD for this situation. Now, assume that credit results may not be reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again using one entity type. Which of these two versions do you prefer, and why?
Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts
Section: Chapter Questions
Problem 3.11CP
Related questions
Question
Create an ERD of the given scenarios and ANSWER the questions.
The loan office in a bank receives from various party’s requests to investigate the credit status
of a customer. Each credit request is identified by a Request ID and is described by a Request
Date and Requesting Party Name. The loan office also received results of credit checks. A credit
check is identified by a Credit Check ID and is described by the Credit Check Date and the
Credit Rating. The loan office matches credit requests with credit check results. A credit request
may be recorded before its result arrives; a particular credit result may be used in support of
several credit requests. Draw an ERD for this situation. Now, assume that credit results may not
be reused for multiple credit requests. Redraw the ERD for this new situation using two entity
types, and then redraw it again using one entity type. Which of these two versions do you prefer,
and why?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage