Master Table

Question

Hi... What is master table how to create . Which condition we make a master table for any database record?

Davin Martyn · Answer

Why are we make master table?

Ankur Jain · Answer

Hi! You Just Identify Them By Using Primary Key and Foriegn Key References Assume There are Two Tables TABLE-1 : DEPT (DEPTID Primary Ke yDEPTNAME) TABLE-2: EMP(EMPID Primaty KeyENAMESALDEPTID Foriegn Key ) In above Two Tables we Have DEPTID is Acting as Primary Key and Foriegn Key..... Total EMPLOYEES are Organized in EMP table with Respective Departments So Some Transactions Are going in EMP By using Dept Table as a Reference DEPT is Master Table and EMP-Transaction Table we will also called as PARENT- CHILD tables even