answer for this

q)When joining more than 2 tables, what rule is true?

1) All tables must be related to each other.
 2)Every table must be related to at least one table.
3) A table does not have to be related.
 4)There must be one table that is directly related to all other tables.

q) When using a join, which option is true about the joining columns in each table.

1) Must have the same name  
2)Must have the same data type
3) Must have the same name and data type.  ]
4)Must have a PK FK relationship.
5)  Must have been joined in the past.
dAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Curiosity overwhelms me, which class is this homework for?
1
Nitin SontakkeDeveloperCommented:
@Jim,

Precise reaction coming to my while reading the question and your comment which put it in words. Perfect.
0
dAuthor Commented:
i know the answers
1)option 1
2)OPTION 4
BUT TO CONFORM
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

dAuthor Commented:
IS THIS ANWERS ARE CURRECT
0
Nitin SontakkeDeveloperCommented:
And yet another thought was, never ever I had any formal education in Microsoft SQL Server and why none of these questions come to my mind when I am typing a query.
0
dAuthor Commented:
PLEASE ANY ONE TELL ME
0
_agx_Commented:
Why not create two tables, with a single column each, and test each theory?
0
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
Practically we can not answer this question. Because there is no restriction on data type or name of column or relationship between columns to be joined.

But conceptually, to get correct data we can answer this.

As per my knowledge, i might be wrong.

First question answer is Option2 : Because Every table should be connected to at lest one table. It's no mandatory for all tables to be connected. Eg. If you need product details.
Product Category is connected Product sub category
Product sub category is connected to Product

Even though , Product Category and Product are not connected we can use them in single query.

Second Question answer is Option 4: It's not mandatory to have pk and fk relationship. But it would be great, if this relationship is there.

Hope it will help you..!!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PortletPaulEE Topic AdvisorCommented:
Consider question 2 a bit more ...

Would you attempt to join a number column to a name column?
or a date column to book title column?

Remember that each given answer starts with MUST.
0
dAuthor Commented:
can any one tell me the answer
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
dr pallavi - In case you haven't noticed EE is not a homework site.  We expect you to be able to think a little and work with the comments experts give you, and not just copy-paste a multiple-choice question and then demand 'give me the answer'.  Otherwise it's called academic dishonesty.
1
PortletPaulEE Topic AdvisorCommented:
Ps. Answer to question 2 isn't option 4....
0
PortletPaulEE Topic AdvisorCommented:
EE's homework policy is here http://support.experts-exchange.com/customer/portal/articles/1435136

Accordingly let me try to explain why option 4 isn't correct for question 2.

It is NOT mandatory that every join be through a PK/FK, you can join through columns that are not keys.

But, if you try to join through columns that are different data types, one of those columns will be converted to a compatible data type and this can lead to query errors. E.g. You cannot join a date to a varchar unless one of those columns is converted.

So, option 4 is incorrect.

Reconsider: Question 2, option 2.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.