Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) Questions  >  Consider the relation employee(name, sex, sup... Start Learning for Free
Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?
  • a)
    Names of employees with a male supervisor.
  • b)
    Names of employees with no immediate male subordinates.
  • c)
    Names of employees with no immediate female subordinates.
  • d)
    Names of employees with a female supervisor.
Correct answer is option 'C'. Can you explain this answer?
Verified Answer
Consider the relation employee(name, sex, supervisorName) with name as...
OR (∨) is commutative and associative, therefore i can rewrite given query as:
It is clear now they are saying something about female employees, This query does not say anything about male employees. Therefore Option A and B are out of consideration.

This query retrieves those e.name who satisfies this condition:
Means retrieves those e.name, who is not a supervisor of any female employees.
i.e it retrieves name of employees with no female subordinate.
(here "immediate" is obvious, as we are checking first level supervisor.)
Hence, option C.
View all questions of this test
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?a)Names of employees with a male supervisor.b)Names of employees with no immediate male subordinates.c)Names of employees with no immediate female subordinates.d)Names of employees with a female supervisor.Correct answer is option 'C'. Can you explain this answer?
Question Description
Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?a)Names of employees with a male supervisor.b)Names of employees with no immediate male subordinates.c)Names of employees with no immediate female subordinates.d)Names of employees with a female supervisor.Correct answer is option 'C'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?a)Names of employees with a male supervisor.b)Names of employees with no immediate male subordinates.c)Names of employees with no immediate female subordinates.d)Names of employees with a female supervisor.Correct answer is option 'C'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?a)Names of employees with a male supervisor.b)Names of employees with no immediate male subordinates.c)Names of employees with no immediate female subordinates.d)Names of employees with a female supervisor.Correct answer is option 'C'. Can you explain this answer?.
Solutions for Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?a)Names of employees with a male supervisor.b)Names of employees with no immediate male subordinates.c)Names of employees with no immediate female subordinates.d)Names of employees with a female supervisor.Correct answer is option 'C'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.
Here you can find the meaning of Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?a)Names of employees with a male supervisor.b)Names of employees with no immediate male subordinates.c)Names of employees with no immediate female subordinates.d)Names of employees with a female supervisor.Correct answer is option 'C'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?a)Names of employees with a male supervisor.b)Names of employees with no immediate male subordinates.c)Names of employees with no immediate female subordinates.d)Names of employees with a female supervisor.Correct answer is option 'C'. Can you explain this answer?, a detailed solution for Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?a)Names of employees with a male supervisor.b)Names of employees with no immediate male subordinates.c)Names of employees with no immediate female subordinates.d)Names of employees with a female supervisor.Correct answer is option 'C'. Can you explain this answer? has been provided alongside types of Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?a)Names of employees with a male supervisor.b)Names of employees with no immediate male subordinates.c)Names of employees with no immediate female subordinates.d)Names of employees with a female supervisor.Correct answer is option 'C'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Consider the relation employee(name, sex, supervisorName) with name as the key. supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce?a)Names of employees with a male supervisor.b)Names of employees with no immediate male subordinates.c)Names of employees with no immediate female subordinates.d)Names of employees with a female supervisor.Correct answer is option 'C'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Explore Courses
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev