I am having an issue with the design of a investment database that I am using MySQL and java to implement. I want my program to have three account a system admin, a investment manager, and a customer. I want the customer to be able to login and just be able to check the balance of any account he/she may have. I want the investment manager to be able to look at his customers account in order to make suggestions, and finally I want the system admin to be able to edit all the information of all the users. For example for a 401k account the admin can make changes to the customers income or rate of interest. I am having a tough time deciding on the tables. I want to have a customer table with all the personal information of the customer, and then an employment table the information in here will be the employment information of a customer. I also want to make a login table but am not sure how I can do this, is there anyway I can take the first and last name of the information in the customer table and make it the username, then take the ssn and make it the password? Anyone have any ideas on table design (what tables to use) and how to create the login table?
This post has been edited by sport10: 11 February 2012 - 12:16 PM
Taking a person's Names and SSN as username and password is not good practice at all! They are easily discover-able. Why don't you make the customer register with a unique username and password first?
a simple Login table's attributes would be,
You'll have to have the UserID attribute in both Customers table as well as Login table 'cause you must link those 2 tables to identify customers individually.
This post has been edited by nK0de: 11 February 2012 - 12:30 PM
Thanks for that. I will do that then and make a register button that will prompt for a username and password creation. Any ideas on the table layout for the design? I just need some advice on how to make the layout for the tables.
I mean for the project in general. I know Ill need a customer table, a employer table, and a login table. I was just looking for ideas on additional tables that others may see to fit. If it helps I plan on having 3 accounts that customers can enroll in a retirement account (401k), a medical plan, and a education plan.