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
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/
--
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
Raguramakrishan
On Fri, Sep 23, 2011 at 1:09 PM, Akash Mukherjee akash...@gmail.com 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
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
KORTH OR NAVATHE is nyc...:)
regards,
PAYAL GUPTA,
CSE 3rd yr,
NIT_B
On Fri, Sep 23, 2011 at 1:09 PM, Akash Mukherjee akash...@gmail.com 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
@payal : thanx but des are more of theory books ryt??
On Fri, Sep 23, 2011 at 5:32 PM, payal gupta gpt.pa...@gmail.com 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 akash...@gmail.comwrote:
hican ne1
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 akash...@gmail.comwrote:
@payal : thanx but des are more of theory books ryt??
On Fri, Sep 23, 2011 at 5:32 PM, payal gupta gpt.pa...@gmail.com wrote:
@ 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 gpt.pa...@gmail.com wrote:
hmmm..yes dey r d theory...vich i used..n dey r gud
regards,
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
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;
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
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
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
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
2^m-1...??
Im not sure tho
On Tue, Aug 9, 2011 at 1:09 PM, krishna meena krishna.meena...@gmail.comwrote:
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
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
17 matches
Mail list logo