The thing is that i am facing problem with fixing the primary key and foreign key. Because in all the tables i have the same fields. Now if i think
"accoutno" is the primary key then for every table it will be the primary key. So, it is possible to take the same key as a primary key for those tables. Please anwer me because i am facing with the problem.
Or how should i solve that problem.
Basically, I have six php pages for six tables where pages are taking inputs and inserting those in mentioned fields in the six tables. That's why i am planning to include 6 different tables against six php pages. If i make one table then how should i take inputs from 6 different pages only in one table. Still i am not clear about that one. Please if possible help me.