Q1. A bank consists of many branches and a large number of customers. The customer can open numerous various kinds of accounts with the bank. The bank keeps track of customer with his SSN, name, address and phone number. The age is a factor to check whether he is a major. There are various types of loans, each recognized by a loan number. Customer can take out more than one kind of loan and all branches can give loans. Loans encompass a duration and interest rate. The account holder can enquire regarding the balance in his account. Draw the ER Diagram for the bank.
Q2. Describe the underlying concept of:
a) Specialization and Generalization.
b) Attribute inheritance.
Q3. Distinguish between:
a) Disjoint and overlapping constraints.
b) Total and partial constraints.