Employers - Post Free Jobs
Forum guidelines
  • Home
  • »
  • SQL
  • »
  • Master Table and Transaction Table
AuthorQuestion
Master Table and Transaction Table
Posted on: 02 Sep 2013
Can any one explain me what is meant by master table and transaction table in DB?

whats difference between master and transaction table?

Give me one real time example please?

AuthorReply
Kunal Vaishya
  • 2
  • 0
accepted
Re: Master Table and Transaction Table
Posted on: 02 Sep 2013   Accepted Answer
Hi ,
In Simple way 
Master Table means your basic data which you want to use another place like Address Book , Employee List , Product List.


EmployeeTable - Sample
EmployeeID 
EmployeeName
EmployeeDOB


BankTable - Sample
BankID 
BankName




Transaction table means if doing any transaction like payment gateway , Account credit , Debit like this. Which each transaction needed different different master table. 


BankTransactionTbale- Sample
TranID - Primary Key
EmployeeID - Master Table Fields Primary key to Connect (EmployeeTable)
BankID -Master Table Fields Primary key to Connect (BankTable)
Amount
CR/DB






Data Sample


EmployeeTable
EmployeeID EmployeeName EmployeeDOB
1Employee1-
2Employee2-
3Employee2-


BankTable - Sample
BankID BankName
1      SBI
2      ICICI
3      AXIS


BankTransactionTbale- Sample
TranID        EmployeeID BankID         Amount         CR/DB
1                1                1                        5000        CR
2                1                1                        3500        CR
3                2                1                        4600        CR
4                2                1                        7800        CR






















   





kingskunal If this post is useful then mark it as "Accepted Answer"
Re: Master Table and Transaction Table
Posted on: 02 Sep 2013  
hi,

refer to this link

http://scn.sap.com/thread/729334

"If you Dream it You can do it"
Re: Master Table and Transaction Table
Posted on: 07 Sep 2013  
There was a time so long ago that young developers might think this is from another Galaxy.
 
There was a time when data was kept on magnetic tapes and data entry was done using punched cards. At that time the data on the tape was called the master file. It might be a file of customers or an inventory of items or it might be a parts list for things like aircraft or it might be accounting data such as a General Ledger or Accounts Receivable data. Transactions would be punched into cards then read into the system and sorted and then matched to the master file and the master file would be updated.

That is where the terminology originated. The terminology is not relevant to the online instantaneous way that data is updated currently but some old programmers like me might still use the terminology. As an old person I can say that anyone using the terms master and transaction is likely also old.

Thinking is a feeling; pleasant for some and unpleasant for others.
Re: Master Table and Transaction Table
Posted on: 11 Oct 2013  
Master Table - It is a base table. only one master table must be perfomed.

Transaction Table - It is a sub table or inherited table. more than transaction tables are performed.

Re: Master Table and Transaction Table
Posted on: 11 Oct 2013  
Thank u Kunal,Sanjeeb ,ashlryturnier and Sam sir for your kind explanation.got it now...


Re: Master Table and Transaction Table
Posted on: 11 Oct 2013  
Master Table is Primary key Table..In which have unique values,and its a one time entry.

Transaction Table is a foreign key reference.

Assume there is a two table

Table-1:VendorMaster(Id(PK),Name)

Table-2:PurchaseHeader(Id(PK),BillNo,Date,Master_Id(FK))

In above table id is a primary key and Master_id is a foreign key.
 

sudeep.s.k
Re: Master Table and Transaction Table
Posted on: 11 Oct 2013  
Thanks suddep:)

SPONSORED BY

Offshore Software and Database Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.