Answer:
In case the data is arranged in the ascending order, you can always change the Binary search tree into a Height BST, and which is also known as the self-balancing BT. And through this, it's quite on hand to better the operations like searching on the new BST. And these SBBTs are quite commonly made use of for constructing as well as maintaining the ordered list. This is the case in the case of the priority queue, and this is what is required here.
Explanation:
Please check the answer.
Answer:
1. E.eid ,E.hobby, E.sal, E.did
2.E.eid , E.sal, E.hobby ,E.did , D.did, D.floor ,D.dname , D.budget.
3.E.eid , E.sal, E.hobby ,E.did , D.did, D.floor ,D.dname , D.budget.
4.E.eid , D.dname
Explanation:
The attributes that are examined for the query are the attributes of the table that are mentioned in the select statement and where clause.
So according to first query we are working on all attribues of Emp table so all of the attributes of Emp table are examined.In second query we selecting all attributes of both the tables hence all attributes of both the table and same in the next query.
In fourth query though the query is not complete where clause is missing but we have eid from Emp and dname from Dept tables for sure and the attributes mentioned in where clause will also be present.
Circles
Area of Circle is 
Total percentage increase in the area of the modified circle is 69%
Explanation:
(a) Given the diameter of the circle be d
Then the radius of the circle = r = d/2
and the area of the circle is given by:
Area(A) =
A = 
A = 
The area of circle is 
(b)
The increase in percentage while changing the dimensions is given by the formula :
Total % increase = a% + b% - (a% * b%)/100
Where ,
a% is the percentage increase in side a
b% is the percentage increase in side b
Let the percentage increase in radius is : a%
Since a% = b%
So the formula is
Total increase % = a% + a% + (a% * a%)/100
Given here the diameter of the circle increases by 30% so a =30
Therefore, putting the value of a in the formula
Total increase % = 30% + 30% + (30% *30%)/100
Total increase % = 60% + 9%
Total increase % =69%
Therefore the total percentage increase in the area of the modified circle is 69%