Re: [algogeeks] DBMS gate 2012 query
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 tuple of C = 2 new tuples Hence 7 new tuples. --
[algogeeks] DBMS gate 2012 query
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
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 algogeeks@googlegroups.com. To unsubscribe from this group, send email to algogeeks+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
Re: [algogeeks] dbms
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/algo... >> >> thanx :) >> >> -- >> 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 options, visit this group at >> http://groups.google.com/group/algogeeks?hl=en. >> > > -- > 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 options, visit this group at > http://groups.google.com/group/algogeeks?hl=en. > -- 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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
Re: [algogeeks] dbms
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 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 options, visit this group at > http://groups.google.com/group/algogeeks?hl=en. > -- 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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
Re: [algogeeks] dbms
@ 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, > 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...:) >>> >>> 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 :) - 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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en. >>> >>> -- >>> 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 options, visit this group at >>> http://groups.google.com/group/algogeeks?hl=en. >>> >> >> -- >> 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 options, visit this group at >> http://groups.google.com/group/algogeeks?hl=en. >> > > -- > 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 options, visit this group at > http://groups.google.com/group/algogeeks?hl=en. > -- 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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
Re: [algogeeks] dbms
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...:) >> >> 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 :) >>> >>> - >>> 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 options, visit this group at >>> http://groups.google.com/group/algogeeks?hl=en. >>> >> >> -- >> 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 options, visit this group at >> http://groups.google.com/group/algogeeks?hl=en. >> > > -- > 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 options, visit this group at > http://groups.google.com/group/algogeeks?hl=en. > -- 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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
Re: [algogeeks] dbms
@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...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 email to algogeeks@googlegroups.com. >> To unsubscribe from this group, send email to >> algogeeks+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/algogeeks?hl=en. >> > > -- > 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 options, visit this group at > http://groups.google.com/group/algogeeks?hl=en. > -- 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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
Re: [algogeeks] dbms
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 :) > > - > 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 options, visit this group at > http://groups.google.com/group/algogeeks?hl=en. > -- 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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
[algogeeks] dbms
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 email to algogeeks@googlegroups.com. To unsubscribe from this group, send email to algogeeks+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
Re: [algogeeks] dbms oop
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; > > 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 from this group, send email to > algogeeks+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/algogeeks?hl=en. > -- 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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
[algogeeks] dbms oop
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 from this group, send email to algogeeks+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
[algogeeks] DBMS Q
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 to algogeeks+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
Re: [algogeeks] DBMS question
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 algogeeks+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
[algogeeks] DBMS question
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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
Re: [algogeeks] DBMS
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 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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
Re: [algogeeks] DBMS
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 algogeeks@googlegroups.com. > To unsubscribe from this group, send email to > algogeeks+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/algogeeks?hl=en. > > -- Aditi Garg Undergraduate Student Electronics & Communication Divison NETAJI SUBHAS INSTITUTE OF TECHNOLOGY Sector 3, Dwarka New Delhi -- 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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
[algogeeks] DBMS
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...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
[algogeeks] dbms interview questions
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 and questions faced , it would be great . thanks! -- 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 options, visit this group at http://groups.google.com/group/algogeeks?hl=en.