Interested to Buy Any Domain ? << Click Here >> for more details...
Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database?
- 4 Answers
- 8811 Views
- I also Faced
- E-Mail Answers
Answer Posted / subbu
Yes we can have that ! Let me expalin with this small
example.
(PK)ProjectID (FK)ClientID -- Project Table
(PK)ClientID (FK)ProjectManagerID -- ClientTable
(PK)Employee (FK)ProjetcID -- Employee Table
Check This In this example I am having 3 tables and each
table have PK and FK.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is the order in which the sql query is executed?
What is 3nf normalization form?
What is a result set object returned by odbc_exec()?
How to fetch the next row from a cursor with a "fetch" statement?
List the advantages of using stored procedures?
What is a trigger? Why we need it?
How to replace given values with null using nullif()?
Explain what are various ways to enhance the ssrs report?
What is deploy, process and build? : sql server analysis services, ssas
What are the different types of sql server replication? : sql server replication
What do you mean by an execution plan?
What does Master database contains?
define and explain the differences between clustered and non-clustered indexes.
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Explain time data type in sal server 2008?
