Home > Forums > Sql Server >


what is transaction table ,master table in SQL server? [Resolved]

Posted by Nav234 under Sql Server on 7/8/2010 | Views : 25161 | Status : [Member] | Replies : 1
Hi all

what is transaction table ,master table in SQL server ?

Thanks in advance

S.Naveen...


Responses

Posted by: BangaruBabu on: 7/8/2010 [Member] Starter

Resolved



You Just Identify Them By Using Primary Key and Foriegn Key References

Assume There are Two Tables

TABLE-1 : DEPT (DEPTID Primary Ke y,DEPTNAME)

TABLE-2: EMP(EMPID Primaty Key,ENAME,SAL,DEPTID 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






BangaruBabu Pureti
http://bangarubabupureti.spaces.live.com/

Nav234, if this helps please login to Mark As Answer. | Alert Moderator
 

  Have you tried Aspose: http://aspose.com/file-tools

Login to post response