I was a little bit confused about RDBMS. Please help urgently.
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