I have a homework assignment though all together relationship confuses me. I am given two tables and have to make a one to many relationship between the two tables though they don't have anything in common.
One is an Account table with 4 fields Account_Number, Account_Open_Data, Account_Type, and Account_Balance. The other is Customer table with 10 fields Customer ID, Name, FName, LName, Street Address, State Address, City, Zip code, Email, and Phone number. Do they have to have a field in common to have a one to many relationship or can they use the fields they have to make a relationship?
It's a homework assignment though I am looking at it more as a I need to know this because I enjoy databases and would like to work with them more. I could care less about the grade the knowledge is a lot better than any grade I can get.
Thank you in advance