Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer the following questions: 1. Draw an ER diagram for the following database: A bank wants to store information about its customers and the loans

image text in transcribed
Answer the following questions: 1. Draw an ER diagram for the following database: A bank wants to store information about its customers and the loans taken by them. Each customer is assigned a unique id called customer-id. The customer's first and last names, date of birth need to be stored. From the date of birth the customer's current age can be determined. A customer may have multiple Each Customer may borrow maximum one loan. Every loan has to be borrowed by a customer. Each loan is assigned a unique id called loan-id. The loan details to be stored are loan amount, interest-rate and start-date. 2. Map the bank ER diagram from question 1 to relational table

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

More Books

Students also viewed these Databases questions

Question

Explain the steps involved in training programmes.

Answered: 1 week ago

Question

What are the need and importance of training ?

Answered: 1 week ago

Question

What is job rotation ?

Answered: 1 week ago

Question

What does Processing of an OLAP Cube accomplish?

Answered: 1 week ago