I want to desing a database in which I want to Handel three things:
1. Personal Information
2. Studies (Academic Qualification)
3. Family Details
4. Job Histroy
Looking these I come to know that above all are separate entities, Please help me how I can design a database for above mentioned entities.
The problem is I have to Print a single report containing all above data.
If I create a seperate table for each entity considering Peronal Info as Master table and rest all as Child tables, how can a write a single query containing all above information. If we consider one master and three detail tables, then join create a problem and correct data not obtained.
Please help me in this regard, how can I solve this problem