Question 2Draw the result after applying each of the relational algebra operations on the following table:a) UnionDBCOURSESSECOURSESCodeCodeITDB4101NameNameITSE1202ITAD1100MATH1102 | Pure MathASPOSITDB1102DatabaseIT SkillsMATH1102 Pure MathIT SkillsITAD1100ITSE1101The result of DBCOURSES U SECOURSES is:

If Union operation is performed on two tables then the results are combination of both the tables…

Draw the result after applying each of the relational algebra operations on the a) Union DBCOURSES SECOURSES Code Name Code Name ITDB4101 ASP ITSE1202 OS ITDB1102 Database ITAD1100 IT Skills MATH1102 Pure Math MATH1102 Pure Math ITAD1100 IT Skills ITSE1101

Draw the result after applying each of the relational algebra operations on the a) Union DBCOURSES SECOURSES Code Name Code Name ITDB4101 ASP ITSE1202 OS ITDB1102 Database ITAD1100 IT Skills MATH1102 Pure Math MATH1102 Pure Math ITAD1100 IT Skills ITSE1101

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter11: Database Performance Tuning And Query Optimization

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

Consider the following relational schema and answer the following questions. User (email, name, address, householdSize) a. Express in relational algebra the query that finds all pairs of users where the two people both claim to have a household size 2 and have the same address and returns their names and the common address. b. Express the above query in SQL. c. Write in SQL the query that finds the users whose household size is at least 50% more than the average household size and returns their name and household size, sorted by household size. (Hint: decompose the problem into sub-problems, and you may use a view to capture an intermediate result.) d. Write in SQL the query that finds all users each having a household size different from the total number of users having the same address as him or her. (Hint: again, decompose the problem into sub-problems, and you may use a view to capture a intermediate result.)
Consider the following relational schema, and answer the following questions by writing relational algebra queries: Employee (EmpID, City, Zipcode) Works (EmpID, CorpID, Salary) Corporation (CorpID, City) Manages (EmpID, MngrID) a. Find the ID and City of all employees who work for Amawig. b. Find the ID and City of all employees who work for Amawig corporation and earn more than $100,000. c. Find the IDs of all employees who live in the same city as the corporation for which they work. d. Find the ID of all employees who live in the same area (zipcode) as do their managers. e. Find the IDs of all employees who earn more than every employee in the Amawig Corporation. f. Suppose that the corporations may have more than a branch in different cities. Find all corporations located in every city in which Amawig Corporation is located.
Given the following relational schema (Hint: the bold text represents a primary key), Department (dept_code, dept_name, emp_num, dept_address, dept_ext)Professor(emp_num, emp_fname, emp_lname, emp_dob, dept_code, prof_ext) Write a relation calculus using Domain Relational Calculus to find all professor names (firstname and lastname) who are in the department with the code "CIS"
Consider the following relational schema, and answer the following questions by writing relational algebra queries: Employee (EmpID, City, Zipcode) Works (EmpID, CorpID, Salary) Corporation (CorpID, City) Manages (EmpID, MngrID) a. Find the ID of all employees who work for Amawig Corporation. b. Find the ID and City of all employees who work for Amawig. c. Find the ID and City of all employees who work for Amawig corporation and earn more than $100,000. d. Find the IDs of all employees who live in the same city as the corporation for which they work. e. Find the ID of all employees who live in the same area (zipcode) as do their managers. f. Find the IDs of all employees who earn more than every employee in the Amawig Corporation. g. Suppose that the corporations may have more than a branch in different cities. Find all corporations located in every city in which Amawig Corporation is located.
Given the following relational schema (Hint: the bold text represents a primary key), Department (dept_code, dept_name, emp_num, dept_address, dept_ext)Professor(emp_num, emp_fname, emp_lname, emp_dob, dept_code, prof_ext) Write a relation calculus using Tuple Relational Calculus to find tbe department names and their addresses that Prof "Peter Rob" work
Consider the following Account table and express in Relational Algebra each of the questions below: accountID amount accountType customerID ac200 5000 current 100 ac201 8800 Saving 104 ac202 3900 current 103 ac203 2000 current 101 ac204 15700 Saving 105 ac205 9655 Saving 106 a. List the details of all the accounts of type ‘Saving’. ( . . . . . . . . . . . . . . ) b. Find the balance amount of the account that is owned by the customer whose id is 106. ( . . . . . . . . . . . . . . ) c. List the ids of customers who own an account of type “current” and its balance amounts is less than 7000 Omani rials. ( . . . . . . . . . . . . . . )
Consider the following Account table and express in Relational Algebra each of the questions below: accountID amount accountType customerID ac200 5000 current 100 ac201 8800 Saving 104 ac202 3900 current 103 ac203 2000 current 101 ac204 15700 Saving 105 ac205 9655 Saving 106 List the details of all the accounts of type ‘Saving’. Find the balance amount of the account that is owned by the customer whose id is 106. List the ids of customers who own an account of type “current” and its balance amounts is less than 7000 Omani rials.
The following question are based on the database whose relational schemas are emp(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) and DEPT(DEPTNO, DNAME, LOC). (a) Update employee SMITH’s job and salary to match that of employee WARD.(b) List the employees joined in Jan with salary ranging from 1500 to 4000. (c) Find out the names and salaries of employees whose salaries greater than salaries of their managers.(d) Find out the manager’s name and number of employees who is having maximum number of employees working under him.
Consider the following relational data model. Employee (empid, ename, address, title, headid) Works (Empid,Deptid,joindate) Department (Deptid, dname, block) Payment (title, salary) A) Write relational algebra for Display the employee name and department name of each employee. Display the employee who works as senior lecturer and belongs to BEI or BCT department. Display the employee name with corresponding department head. B) Write sql query for Creating the above relations; including appropriate versions of all primary and foreign key constraints Find the employee name and address whose address name ends with substring ‘pur’. Update the salary of senior lecturer by 25%.(Solve A - 1,2,3 only)
Given the following relational schema (Hint: the bold text represents a primary key), Department (dept_code, dept_name, emp_num, dept_address, dept_ext)Professor(emp_num, emp_fname, emp_lname, emp_dob, dept_code, prof_ext) Write a relation algebra to find all professor names (firstname and lastname) who are in the department named "Biology"
Consider the following relational schemaemployee (ename, street, city)works (ename, cname, salary, jdate)company (cname, city)manages (ename, mname)Write down the following queries in SQL 1. Find the names of all employees who earn more than every employee of Square Pharma. 2. Give all managers in this database a 4 percent salary raise, unless the salary would be greaterthan Tk.100,000. In such cases, give only a 3 percent raise.
Consider the following relational schema and answer the following questions. Employee (Employee_Id, First_Name, Last_Name, Email, Phone_Number, Hire_Date, Job_Id, Salary, Commission_Pct, Manager_Id, Department_Id) a. Write a query to find the manager ID and the salary of the lowest-paid employee for that manager. b. Write a query to get the department ID and the total salary payable in each department. c. Write a query to get the average salary for each job ID excluding programmer. d. Write a query to get the total salary, maximum, minimum, average salary of employees (job ID wise), for department ID 90 only.

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS