Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started