Answer / samba shiva reddy . m

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships.
One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships.
Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.

Answer / laxman

using junction table

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

What happens if an integer is too big for int date type?

0 Answers  

---

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

---

What is the bookmark lookup and rid lookup?

0 Answers  

---

can you any body tell me the how to decrease the logfile

4 Answers  

---

---

Explain optimistic and pessimistic concurrency?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

What is field in algebra?

0 Answers  

---

How many levels of sp nesting are possible?

0 Answers  

---

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---

What is difference between order by and group by?

0 Answers  

---