Draw the ERD diagram to create relational model with reference to the scenario.

QUESTION

Note: Please make sure that all the points/rules must be implemented.

Draw the ERD Diagram to create relational model corresponding to the described Scenario.

The loan office in a bank receives from various parties, requests to investigate the credit status of a

Customers. 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 ERD for this

Situation.

Requirements:

ER Diagram of system implemented in tool such as Sqlyog & Draw.io (Available online).

 

 

Answer:

There are two entities present.

a) Credit_Request

b) Credit_Check.

 

Credit_request entity has three attributes of its own:

1)  Request_ID,

2) Requesting_Part_Name

3) Request_Date( Primary Key)

 

Credit_Check entity also has three attributes: 

1) Credit_Check_ID,

2) Credit_Rating 

3) Credit_Check_Date.

 

ERD Diagram: 

 

 

 

Also Read: Make a complete observation and analysis for this program based on a given budget.