MCP Exam Study Query

Hi All,
I'm currently studying for MCP exam 70-229. I'm on the database logical
modeling section, and have come up with this question:
In a non-identifying relationship, how would a join work, or is the term
used to describe a situation where a relationship is at fault?
Many Thanks,
Simon.Your question is not very clear.
You can join on any two columns with similar datatypes.
There does not have to be an explicit Parent-Child (PK-FK) relationship.
However, without a relationship, the question is: would the data provide any
useful information? And the answer is: it depends.
If that helps, then I was lucky. If not, please ask again, offering some
information about what you are seeking.
Regards,
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I'm currently studying for MCP exam 70-229. I'm on the database logical
> modeling section, and have come up with this question:
> In a non-identifying relationship, how would a join work, or is the
> term used to describe a situation where a relationship is at fault?
> Many Thanks,
> Simon.
>|||Hi Arnie,
Thanks for the post, I do understand that a relatioship can be either
explicit or implicit, but I'm not sure this is what the question refers to,
to bo honest, I'm not 100% sure what the question means myself! :)
Heres an excerpt from the book I'm working from:
"A relationship is said to be identifying if the primary key of a child
entity contains all the attributes of a foreign key. If the primary key of
the child entity does not contain all the attributes of a foreign key, the
the relationship is non-identifying"
The more I read that statement, the more confused I get! 8o)
Any ideas?
Simon.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uTMqldWlGHA.884@.TK2MSFTNGP05.phx.gbl...
> Your question is not very clear.
> You can join on any two columns with similar datatypes.
> There does not have to be an explicit Parent-Child (PK-FK) relationship.
> However, without a relationship, the question is: would the data provide
> any useful information? And the answer is: it depends.
> If that helps, then I was lucky. If not, please ask again, offering some
> information about what you are seeking.
> Regards,
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another Certification Exam
>
> "Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
> news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> I'm currently studying for MCP exam 70-229. I'm on the database logical
>> modeling section, and have come up with this question:
>> In a non-identifying relationship, how would a join work, or is the
>> term used to describe a situation where a relationship is at fault?
>> Many Thanks,
>> Simon.
>>
>sql

MCDBA - UK

Is it worth studying towards an MCDBA (hopefully going to get my
employer to pay for it) ... has anyone completed it in the UK? if so
what learning methods did you use(ie Boot Camp, elearning etc)? And
who do you recommend for the training course?

Thanks

Chris LongstaffHi

In today's job market any qualification is an advantage on the CV. It may be
the differentiating factor and should show that you have attained a given
level. But don't tell your current employer!!

When you consider taking an exam, it is not only the subject being tested
that you need to be competent in, exam technique is very important. You can
know the subject inside out but if you make silly mistakes during the exam
itself, you may make it difficult for yourself.

My personal opinion is that regardless of the course you may take, you also
need to do some additional reading, exam prep and practical experience to
gain the most from the qualification. The amount required will depend on the
course taken and method of learning.

A factor you should also consider is the length of time you are going to
require to be away from the workplace. A boot camp may be a shorter overall
time, but is a more sustained abscence.

John

"Chopper" <chopper@.postmaster.co.uk> wrote in message
news:49de9835.0311130340.416fb24f@.posting.google.c om...
> Is it worth studying towards an MCDBA (hopefully going to get my
> employer to pay for it) ... has anyone completed it in the UK? if so
> what learning methods did you use(ie Boot Camp, elearning etc)? And
> who do you recommend for the training course?
> Thanks
> Chris Longstaff