Hi Friends,

I was a little bit confused about RDBMS. Please help urgently.
EG :

Table 1 : Name, Age, Empid
Table 2 : DOB, ID, Salary

This is called RDBMS right as it is joining two tables having a common field ID/EmpId. Instead of having two tables why cannot we have only one table with all the fields in it. What is the necessity of creating a new table and connecting them using a primary key.In a single table also we can perform SQL query to get the results.

Please help urgently as i am having a seminar on coming tuesday