Re: [algogeeks] DBMS gate 2012 query

2013-01-01 Thread Karthikeyan V.B
Hi, Result of A U B has 5 tuples and C has 2 tuples. condition is either A.Id > 40 or C.Id < 15 First consider C.Id < 15 : 1 tuple from C satisies this condition Hence join this 1 tuple with 5 tuples of A U B = 5 new tuples A.Id > 40 yields 2 tuples from A U B - join this with the remaining tu

[algogeeks] DBMS gate 2012 query

2012-12-27 Thread rahul sharma
HI please explain the following question no: 2 on below link as i am not able to copy it. http://www.geeksforgeeks.org/database-management-system-set-3/ --

[algogeeks] Dbms

2011-10-06 Thread amit kannaujiya
Any one having good material on functional dependency and normalization , which contain examples and easily explain these concepts ... Plz post here ... -- You received this message because you are subscribed to the Google Groups "Algorithm Geeks" group. To post to this group, send email to algo

Re: [algogeeks] dbms

2011-09-28 Thread Akash Mukherjee
ty:) On Wed, Sep 28, 2011 at 3:50 PM, sharmila saru wrote: > Raguramakrishan > > On Fri, Sep 23, 2011 at 1:09 PM, Akash Mukherjee wrote: > >> hican ne1 suggest good books for dbms...not theory types but more of a >> question bank like maybe a cracking the coding interview is for >> coding/alg

Re: [algogeeks] dbms

2011-09-28 Thread sharmila saru
Raguramakrishan On Fri, Sep 23, 2011 at 1:09 PM, Akash Mukherjee wrote: > hican ne1 suggest good books for dbms...not theory types but more of a > question bank like maybe a cracking the coding interview is for > coding/algo... > > thanx :) > > -- > You received this message because you are

Re: [algogeeks] dbms

2011-09-23 Thread Akash Mukherjee
@ shady : sry, i thought with all the discussions on placement questions it would be a good place :P..will be more particular abt wat i post in future :) On Fri, Sep 23, 2011 at 7:01 PM, payal gupta wrote: > hmmm..yes dey r d theory...vich i used..n dey r gud > > > regards, > PAYAL GUPTA, >

Re: [algogeeks] dbms

2011-09-23 Thread payal gupta
hmmm..yes dey r d theory...vich i used..n dey r gud regards, PAYAL GUPTA, CSE_3rd yr NIT_B On Fri, Sep 23, 2011 at 11:21 PM, Akash Mukherjee wrote: > @payal : thanx but des are more of theory books ryt?? > > On Fri, Sep 23, 2011 at 5:32 PM, payal gupta wrote: > >> KORTH OR NAVATHE is nyc...:)

Re: [algogeeks] dbms

2011-09-23 Thread Akash Mukherjee
@payal : thanx but des are more of theory books ryt?? On Fri, Sep 23, 2011 at 5:32 PM, payal gupta wrote: > KORTH OR NAVATHE is nyc...:) > > regards, > PAYAL GUPTA, > CSE 3rd yr, > NIT_B > > On Fri, Sep 23, 2011 at 1:09 PM, Akash Mukherjee wrote: > >> hican ne1 suggest good books for dbms..

Re: [algogeeks] dbms

2011-09-23 Thread payal gupta
KORTH OR NAVATHE is nyc...:) regards, PAYAL GUPTA, CSE 3rd yr, NIT_B On Fri, Sep 23, 2011 at 1:09 PM, Akash Mukherjee wrote: > hican ne1 suggest good books for dbms...not theory types but more of a > question bank like maybe a cracking the coding interview is for > coding/algo... > > thanx

[algogeeks] dbms

2011-09-23 Thread Akash Mukherjee
hican ne1 suggest good books for dbms...not theory types but more of a question bank like maybe a cracking the coding interview is for coding/algo... thanx :) -- You received this message because you are subscribed to the Google Groups "Algorithm Geeks" group. To post to this group, send em

Re: [algogeeks] dbms oop

2011-09-01 Thread rahul vatsa
u mean, u want to write a class for mysql ? a simple class u cn write which will ve member functions, OpenConnection, fireTheQuery, Close & ... depending on ur requirements ... On Fri, Sep 2, 2011 at 12:52 AM, Maximilian Anthony < maximilian@gmail.com> wrote: > > make some databas in mysql;

[algogeeks] dbms oop

2011-09-01 Thread Maximilian Anthony
make some databas in mysql; now i want to implement it with class(OOP) what streategy fallow give some examle ; -- You received this message because you are subscribed to the Google Groups "Algorithm Geeks" group. To post to this group, send email to algogeeks@googlegroups.com. To unsubscribe

[algogeeks] DBMS Q

2011-08-25 Thread Vijay Khandar
ER-diagram is given and asking for min and max table. Can anyone Explain me .. -- You received this message because you are subscribed to the Google Groups "Algorithm Geeks" group. To post to this group, send email to algogeeks@googlegroups.com. To unsubscribe from this group, send email

Re: [algogeeks] DBMS question

2011-08-16 Thread venkateswari srinivasan
with out changing table , we can provide the required information to the user... -- You received this message because you are subscribed to the Google Groups "Algorithm Geeks" group. To post to this group, send email to algogeeks@googlegroups.com. To unsubscribe from this group, send email to a

[algogeeks] DBMS question

2011-08-16 Thread tech rascal
use of views in the database?? -- You received this message because you are subscribed to the Google Groups "Algorithm Geeks" group. To post to this group, send email to algogeeks@googlegroups.com. To unsubscribe from this group, send email to algogeeks+unsubscr...@googlegroups.com. For more op

Re: [algogeeks] DBMS

2011-08-09 Thread Bipin kumar yadav
it should be 2^(m-1)-1 because in given m elements 1 element should be primary key, which will combined with other attributes to form super key. so there will be 2^(m-1) such subset now we subtract 1 for the phi.so this should be 2^(m-1)-1. correct me if i m wrong,,, -- You received this m

Re: [algogeeks] DBMS

2011-08-09 Thread aditi garg
2^m-1...?? Im not sure tho On Tue, Aug 9, 2011 at 1:09 PM, krishna meena wrote: > In an RDBMS with m attributes, how many superkeys are possible? > > -- > You received this message because you are subscribed to the Google Groups > "Algorithm Geeks" group. > To post to this group, send email to al

[algogeeks] DBMS

2011-08-09 Thread krishna meena
In an RDBMS with m attributes, how many superkeys are possible? -- You received this message because you are subscribed to the Google Groups "Algorithm Geeks" group. To post to this group, send email to algogeeks@googlegroups.com. To unsubscribe from this group, send email to algogeeks+unsubscr

[algogeeks] dbms interview questions

2011-07-28 Thread nivedita arora
can someone pls tell that what kind of questions are asked on dbms in written as well as in interview. i know the main topics are- sql queries, normalisation ,acid properties, constraints on relationship etc but hvnt found any good link on type of que asked. if anyone can share their experience a