I design an online bank with Spring MVC.
The customer will have a unique customer ID, but he / she can have multiple accounts. As per customer code, there may be more than one account in the bank. So I design a table with attributes ->
CustomerID, AccountNumber where CustomerId will be the primary key.
Please suggest how to design the database.