Test your technical skills online, appear in Virtual Interview and be ready for job!
Twitter Twitter LinkedIn YouTube Google
Be Interview ready ! | Search
Make friends on DotNetFunda.com and expand your network!
Winners

Win Prizes

Announcements
Like us on Facebook
Sponsor
Top Forums Author
Wed, 16-Apr-2014 Authors
Iliyas
10
Nismeh
10
Sepatukaca
10
All Time Authors
Jayakumars
3930
Karthikanbarasan
3455
Chvrsri
3140

Latest members | More ...


(Statistics delayed by 5 minutes)

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

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

what is transaction table ,master table in SQL server ?

Thanks in advance

S.Naveen...

Reply | Reply with Attachment

=> Scroll below for responses


Comments or 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


Login to post response.

Comments / Responses
Select text & click toolbar to format. Formatting appears in viewmode only. HTML Tags are not allowed.
Bold Italic Underline Paragraph Title Code  Link 
 Wait ... Processing ..... please wait.

Found interesting? Add this to: