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

MCP Exam - 70-229

Dear All,
I am considering taking the above exam in the next few ws.
I have attended the course that accompanies the Exam and have read the
course material.
I have also recently started reading Inside SQL Server 2000 by Kalen
Delaney.
I have been using SQL 2000 for the past 18-24 Months.
Can anyone give me any information regarding the above exam? Typically
how long is the exam and any guidance re: revision would be most
helpful.
Many thanks
BarryTypically
> how long is the exam
Its about 180 minutes (plus additional time for non native english
speakers)
For content look here (but experience is the best for preparing)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Barry" <barry.oconnor@.singers.co.im> schrieb im Newsbeitrag
news:1116000519.113047.167620@.g14g2000cwa.googlegroups.com...
> Dear All,
> I am considering taking the above exam in the next few ws.
> I have attended the course that accompanies the Exam and have read the
> course material.
> I have also recently started reading Inside SQL Server 2000 by Kalen
> Delaney.
> I have been using SQL 2000 for the past 18-24 Months.
> Can anyone give me any information regarding the above exam? Typically
> how long is the exam and any guidance re: revision would be most
> helpful.
> Many thanks
> Barry
>|||I took the exam and it was 3 hours I believe.
Your best source of all information are the BOL, IMO.
I would read Microsoft's site about the contents of the exam
and then brush up on them using the BOL.
"Barry" <barry.oconnor@.singers.co.im> wrote in message
news:1116000519.113047.167620@.g14g2000cwa.googlegroups.com...
> Dear All,
> I am considering taking the above exam in the next few ws.
> I have attended the course that accompanies the Exam and have read the
> course material.
> I have also recently started reading Inside SQL Server 2000 by Kalen
> Delaney.
> I have been using SQL 2000 for the past 18-24 Months.
> Can anyone give me any information regarding the above exam? Typically
> how long is the exam and any guidance re: revision would be most
> helpful.
> Many thanks
> Barry
>|||Armando, Jens
Thank you both for your replies - I'm off for some light reading(!) :-D
Barry

Mcdba

Hi
I am wanting to take the 70-228 and 70-229 exams. Does anyone who has already passed them have any recommendations for the best / most complete books for studying them? Opinions seem so varied on Amazon...
Thx
Deshai desmondx,

Last week i cleared my 70-229 exam and i am taking 70-228 exam this next week.

In my opinion, Microsoft Training Kits will really help u for the exam. What u need is a little handson experience in SQL Server and Mircorsoft Training Kit for preparation and use Books online for indepth explanation and reference. U can easily get a good score in the exam.

I also used Inside SQL Server 2000 from MSPress

Guides from testking are also useful but don't rely only on them.

I have heared that self-test softwares r good. (but i hav'nt used any of them)

All the best for ur exam

With regards
Sudar|||Thanks for the advice Sudar,

Good luck with 228...
:-)
cheers
des