Chapters

Time and Distance

Rumman Ansari Software Engineer 2024-07-28 09:03:18 157 Share
Subject Syllabus Details Subject Details

☰ TContent

☰Fullscreen

Table of Content:

Time and Distance Formulas
Basic Formulas
Speed
Distance
Time
Conversions
Speed in km/hr to m/s
Speed in m/s to km/hr
Relative Speed
Same Direction
Opposite Direction
Time to Meet
Time to Meet (Same Direction)
Time to Meet (Opposite Direction)
Average Speed
Examples
Example 1: Finding Speed
Example 2: Finding Time
Stay Ahead of the Curve! Check out these trending topics and sharpen your skills.

Time and Distance Formulas

Basic Formulas

Speed

Speed = \frac{Distance}{Time}

Distance

Distance = Speed \times Time

Time

Time = \frac{Distance}{Speed}

Conversions

Speed in km/hr to m/s

Speed (m/s) = Speed (km/hr) \times \frac{5}{18}

Speed in m/s to km/hr

Speed (km/hr) = Speed (m/s) \times \frac{18}{5}

Relative Speed

Same Direction

Relative Speed = {Speed}_{1} - {Speed}_{2}

Opposite Direction

Relative Speed = {Speed}_{1} + {Speed}_{2}

Time to Meet

Time to Meet (Same Direction)

Time = \frac{Distance}{Relative Speed}

Time to Meet (Opposite Direction)

Time = \frac{Distance}{Relative Speed}

Average Speed

When the same distance is traveled at different speeds:

Average Speed = \frac{2 \times {Speed}_{1} \times {Speed}_{2}}{{Speed}_{1} + {Speed}_{2}}

Examples

Example 1: Finding Speed

If a car travels 150 km in 3 hours, what is its speed?

Speed = \frac{150 km}{3 hours} = 50 km/hr

Example 2: Finding Time

If a person walks at a speed of 5 km/hr for 10 km, how long does it take?

Time = \frac{10 km}{5 km/hr} = 2 hours

MCQ Available

There are 80 MCQs available for this topic.

80 MCQ Take Quiz

No Questions Data Available.

No Program Data.

Stay Ahead of the Curve! Check out these trending topics and sharpen your skills.

➚ Long Question Share

A function is a sequence of statements that accepts input, processes them to perform a specific task and provides the output. Functions must have a name but the function name can never start with a special character such as @, $, #, and so on.

Types of function

Pre-Defined Function
User-Defined Function

User-defined Function:

In a user-defined function we write our logic according to our needs. The main advantage of a user-defined function is that we are not just limited to pre-defined functions. We can write our own functions for our specific needs or to simplify complex SQL code. The return type of a SQL function is either a scalar value or a table.

Creation of a function

Create function ss(@id int)   
returns table   
as   
return select * from item where itemId = @id

Execution of a Function

 select * from ss(1)

➚ Long Question Share

According to the MSDN Books online COALESCE() returns the first Non NULL value. Let's understand this with an example.

Consider the Employees Table below. Not all employees have their First, Midde and Last Names filled. Some of the employees has First name missing,

➚ Long Question Share

Modular Programming: Functions allow modular programming where it is generated once and called multiple times during programming.
Faster Execution: Every time a function is called, the execution code is saved in the cache that helps in faster execution of function when it is called again.
Reduced Network Traffic: A function utilizes the WHERE clause for reducing the overall size of the code that ultimately results in enhanced network performance.