Why use Master table in project

Question

Hi all, Why use Master tables in a project. what are the advantages.

Arun Kumar Tiwari · Answer

Master table is use to store the basic information.which cannot need to change.

Rajanikant Hawaldar · Answer

Pretty simple, reusability of data. Can be changed on need but some data no need of change, let's take real time scenario of project 'Marketing'. In this project there will be form to enter customer profile, another form enter sales order details so when customer orders you need to select customer from customer profile master table at sales order form to avoid typing customer details again and again unless he is permanent or long term customer. If customer shift his company to other area then you need change customer address which helps to you while transport his order to his address. Let's take another scenario HR project, here employee profile data is master table. Here employee blood group will not change so no need to change again and again

SUJAY ANAND · Answer

Hi Master table is nothing but it holds or stores basic information. For eg we have registration table. In that table we will have fields like name,age,area,city,state ,pincode and mobile. The city and state will be the master table here. As city will be listed from city table and state will be listed from state table. Remaining all fields are transaction fields.

Salman Beg · Answer

Hi. Master tables are used to store the data which can not be changed throughout the life time. We can say these data as meta data. The advantages is, once data loaded into these tables it won't change. The example of master table are, Country table, State table etc. Thanks.