Computer Science Engineering (CSE) Exam > Computer Science Engineering (CSE) Questions > Q4. i) Examine the given relations of a Banki...
Start Learning for Free
Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.?
Most Upvoted Answer
Q4. i) Examine the given relations of a Banking Database Management Sy...
Salaries of Employees in the Same City as the Bank
- Relational Algebra Expression: π salary (σ Employee.city = Bank.city (Employee ⨝ Works for ⨝ Bank))
- Explanation:
- Join the Employee, Works for, and Bank relations using the common attribute B_id.
- Select the tuples where the city of the employee is the same as the city of the bank.
- Project the salary attribute of the resulting relation.
Employee Names in the City of DFC Bank
- Relational Algebra Expression: π Emp_name (σ Bank.Bank_name = "DFC Bank" (Employee ⨝ Works for ⨝ Bank))
- Explanation:
- Join the Employee, Works for, and Bank relations using the common attribute B_id.
- Select the tuples where the Bank_name is "DFC Bank".
- Project the Emp_name attribute of the resulting relation.
By following these relational algebra expressions, you can easily find the salaries of employees living in the same city as the bank they work for and list out employee names residing in the city where DFC bank is located.
- Relational Algebra Expression: π salary (σ Employee.city = Bank.city (Employee ⨝ Works for ⨝ Bank))
- Explanation:
- Join the Employee, Works for, and Bank relations using the common attribute B_id.
- Select the tuples where the city of the employee is the same as the city of the bank.
- Project the salary attribute of the resulting relation.
Employee Names in the City of DFC Bank
- Relational Algebra Expression: π Emp_name (σ Bank.Bank_name = "DFC Bank" (Employee ⨝ Works for ⨝ Bank))
- Explanation:
- Join the Employee, Works for, and Bank relations using the common attribute B_id.
- Select the tuples where the Bank_name is "DFC Bank".
- Project the Emp_name attribute of the resulting relation.
By following these relational algebra expressions, you can easily find the salaries of employees living in the same city as the bank they work for and list out employee names residing in the city where DFC bank is located.
Attention Computer Science Engineering (CSE) Students!
To make sure you are not studying endlessly, EduRev has designed Computer Science Engineering (CSE) study material, with Structured Courses, Videos, & Test Series. Plus get personalized analysis, doubt solving and improvement plans to achieve a great score in Computer Science Engineering (CSE).
|
Explore Courses for Computer Science Engineering (CSE) exam
|
|
Similar Computer Science Engineering (CSE) Doubts
Top Courses for Computer Science Engineering (CSE)View all
Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.?
Question Description
Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.? 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 Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.?.
Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.? 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 Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.?.
Solutions for Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.? 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 Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.? defined & explained in the simplest way possible. Besides giving the explanation of
Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.?, a detailed solution for Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.? has been provided alongside types of Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.? theory, EduRev gives you an
ample number of questions to practice Q4. i) Examine the given relations of a Banking Database Management System and answer the following queries in the form of relational algebra expressions Employee (E_id, Emp_name, salary, city) Works for (E_id, B_id) Bank (B_id. Bank_name, city, phone) a) Find the salaries of all the employees who live in the same city as the bank for which they work. b) List out the employee names residing in the city where DFC bank is located.? tests, examples and also practice Computer Science Engineering (CSE) tests.
|
|
Explore Courses for Computer Science Engineering (CSE) exam
|
|
Suggested Free Tests
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
|
© EduRev
|
Education Revolution
|
|
Signup to see your scores
go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup