I have a scenario like XYZ company is creating a User management System , which allows to purchase for different company , so based on the package the system provides options to save last three or five user password to check and the max is ten .
XYZ---| Total password count 10
company 1 takes with 5 retrivals where the other takes 2 retrivals, please let me know how can I design the DB for the same.
My present deisgn what i have done i have master table with following fields
Master table => Company ID , COmpany Name,User ID , Number Of password count,
User table => User Id , Company ID,User Name , Password .
Password table => User ID ,Password1,......password10.
I want them to be design in better normalisation , Thanks.