Bissoy.com
Doctors Medicines MCQs Q&A

The following relation records the age of 500 employees of a company, where empNo (Indicating the employee number) is the key: empAge(empNo, age) Consider the following relational algebra expression: πempNo(empAge ⋈ (age>age1) ρempNo 1, age1(empAge)) What does the above expression generate?

The following relation records the age of 500 employees of a company, where empNo (Indicating the employee number) is the key: empAge(empNo, age) Consider the following relational algebra expression: πempNo(empAge ⋈ (age>age1) ρempNo 1, age1(empAge)) What does the above expression generate? Correct Answer Employee numbers of all employees whose age is not the minimum.

Answer: Option 2

Explanation:

Consider the empAge(empNo, age) Table

empNo

age

100

22

101

21

102

23

103

24

104

25

105

26

200

22

201

21

202

23

203

24

204

25

205

26

206

27

We run the following Query on above Table 

IIempNo(empAge ⋈ (age>age1) ρempNo 1, age1(empAge))

We get Output Table as 

empNo

100

102

103

104

105

200

202

203

204

205

206

Hence the Output is "Employees whose age greater than at least one employee" or "Employees whose age is no minimum".

Related Questions

What is the total number of employees in the company? Which of the following option is sufficient alone to find the answer? A) In the company, employees like either tea or coffee or cold drink. Out of the total employees, 25% like tea and 40% like coffee. Out of remaining employees, 20% like cold drink and remaining employees don’t like any of these drinks. B) Out of total employees 18% working in the marketing departments, 35% working in IT departments. From the remaining employees 25% working in HR departments and 45% working in content departments and remaining 141 are working in other departments. C) Employees working in the company is form state X, Y and Z. 20% of employees working in the company is from state X and from remaining 60% employees is from state Z and the remaining employees is from the state Y. D) 60% of the employees in the company are married and remaining employees are unmarried. The ratio of male and female unmarried employees is 4 : 5 and ratio of married male and female employees is 3 : 4.
Consider the relational schema given below, where eId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that every employee has at least one associated dependent in the dependent relation. Employee (empId, empName, empAge) Dependent(depId, eId, depName, depAge) Consider the following relational algebra query: ΠempId(employee)-ΠempId (employee⋈(empId = eID)∧(empAge ≤ depAge)dependent) The above query evaluates to the set of empIds of employees whose age is greater than that of
The table below shows income (in rupees) for a particular month, together with their sources in respect of 5 employees A, B, C, D and E Employee A B C D E Salary 52,000 48,500 42,000 31,000 25,000 Overtime 0 0 1,500 2,500 3,200 Arrears 5,500 4,500 4,000 3,000 1,500 Bonus 3,500 3,000 2,500 2,000 2,000 Miscellaneous income 5,000 3,000 2,000 1,500 0 Total 66,000 59,000 52,000 40,000 31,700 How many employees have their salary more than four times their other incomes?
The following table shows the income (in rupees) for a particular month, together with their source, in respect of 5 employees (A, B, C, D and E)   A B C D E Salary 52,000 48,500 42,000 31,000 25,000 Overtime 0 0 1,500 2,500 3,200 Arrears 5,500 4,500 4,000 3,000 1,500 Bonus 3,500 3,000 2,500 2,000 2,000 Miscellaneous income 5,000 3,000 2,000 1,500 0 Total 66,000 59,000 52,000 40,000 31,700 How many employees got more arrears than the average arrears received by all the employees?
The following table shows the income (in rupees) for a particular month, together with their source, in respect of 5 employees (A, B, C, D and E).   A B C D E Salary 52,000 48,500 42,000 31,000 25,000 Overtime 0 0 1,500 2,500 3,200 Arrears 5.500 4,500 4,000 3,000 1,500 Bonus 3,500 3,000 2,500 2,000 2,000 Miscellaneous income 5,000 3,000 1,500 1,500 0 Total 66,000 59,000 40,000 40,000 31,700   For employee D, the income from overtime is what percentage of his total income?
The break-up (degree wise) of the total number of employees of a company working in five offices, A, B, C, D and E, in a city, in 2020 is shown in the following pie graph. Total Number of Employees = 3400 The ratio of the number of male and female employees working in office A is 5 ∶ 6 and 50% of the employees in office E are females. Let a be the ratio of the number of male employees in A to that of the female employees in E and b be the ratio of the number of male employees in E to that of the female employees in A. What is the ratio a ∶ b?
The following table shows the income (In Rs.) for a particular month, together with their source, with respect to 5 employees (A, B, C, D, and E)   A B C D E Salary 52,000 48,500 42,000 31,000 25,000 Overtime 0 0 1,500 2,500 3,200 Arrears 5,500 4,500 4,000 3,000 1,500 Bonus 3,500 3,000 2,500 2,000 2,000 Miscellaneous income 5,000 3,000 2,000 1,500 0 Total 66,000 59,000 52,000 40,000 31,700   How many employees got more than a total of Rs. 10,000 as income other than salary?
The average age of the employees of an office, having 10 employees was 48 years. When an employee 53 years resigned from office and another employee died on same day. So a new employee joins the office aged 34. Next year in the same month the average age of 9 employees was found to be 46 years. Find the age of the late employee at the time of his death.
Consider the following relational schema: employee(empId,empName,empDept) customer(custId,custName,salesRepId,rating) salesRepId is a foreign key referring to empId of the employee relation. Assume that each employee makes a sale to at least one customer. What does the following query return? SELECT empName FROM employee E WHERE NOT EXISTS (SELECT custId FROM customer C WHERE C.salesRepId = E.empId AND C.rating <> ’GOOD’);
A company paid Rs. 6,00,000 as bonus to its employees at different levels A, B and C. Each employee at level A receives one and half times of the amount that was paid to each employee at level B and each employee at level B was paid twice the amount paid to the employee at level C. If 50 employees were on level A, 75 on level B and 100 on level C, how much amount was paid to each employee of level A ?