Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. For each of the following scenarios, draw the corresponding EER diagram. Incorporate business rules as needed, in order to model the scenario as completely

1. For each of the following scenarios, draw the corresponding EER diagram. Incorporate business rules as needed, in order to model the scenario as completely as possible.

a.The loan office in a bank receives from various parties 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 receives the 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 by several credit requests.

b. A faculty member must be qualified to teach at least two different courses.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Secrets Of Analytical Leaders Insights From Information Insiders

Authors: Wayne Eckerson

1st Edition

1935504347, 9781935504344

More Books

Students also viewed these Databases questions

Question

=+j Explain the essential nature of repatriation.

Answered: 1 week ago