Question

data across different tables can be linked using _____​

Answer 1

Answer:

Let's suppose you have two databases on the same server - Db1 and Db2. Db1 has a table called Clients with a column ClientId and Db2 has a table called Messages with a column ClientId (let's leave asside why those tables are in different databases).

Now, to perform a join on the above-mentioned tables you will be using this query:

select *

from Db1.dbo.Clients c

join Db2.dbo.Messages m on c.ClientId = m.ClientId

Answer 2

Water pollution has become a continuous threat and issue on Earth and affects all animals and humans majorly in all aspects. Water pollution is the contamination and accumulation of toxic elements and impurities in water generated due to human activities. Water pollution is a serious problem threatening the world, and to find a solution, we will need first to find the source of origin.

Water pollution occurs through many sources such as agricultural, industrial, urban runoff, animal feces and carcass, leeching and landfill, and other human activities. These activities are a result of human’s needs competition to take the top level.

Water pollution also occurs due to natural causes like a tsunami, cyclone, earthquake, volcanic eruption, etc. Although humans do not control them, they cause little or very little damage to water compared to human activities.

Some irresponsible human activities contaminate water bodies, which are a source of drinking water for the residents. Other activities such as bathing of domestic animals, washing clothes, dumping animal carcass and feces, and water bodies are other reasons for water pollution.

To stop water pollution, we need to control activities on a large and follow drastic changes in our habits to help us save water and Mother Earth.