Question: please give the correct answer 5. Consider the following relations database: Employee(person name, street, city) Works(person_name, company_name, salary) Company(company name, city) Manages(person_name, manager_name) (a) Write

please give the correct answer 5. Consider the following relations database:

please give the correct answer

5. Consider the following relations database: Employee(person name, street, city) Works(person_name, company_name, salary) Company(company name, city) Manages(person_name, manager_name) (a) Write down relational algebra to express the following queries: (i) Find the names of all employees who do not work in Sonali Bank. (ii) Find the names of all employees who lives in Dhaka. (iii) Find the names of all employee whose manager name is Md. Salam Mia

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

employee (ID, person name, street, city) works (ID, company_name, salary) company (company name, city) manages ( ID, manager id) Consider the above relational database, where the primary keys are...

Comp Sci Database Systems help . Please Read the problem carefully and understand it!! If you handwrite everything, please be legible!! Thank you for your help:) if you have any questions please...

Give an SQL schema definition for the following employee database: employee (employee name, street, city) works (employee name, company_name, salary) company (company name, city) manages(employee...

Solve the following question using PostgreSQL . Give an SQL schema definition for the following employee database: employee ( employee name , street, city) works ( employee name , company_name,...

Question#1: - Consider the relational database below, where the primary keys are underlined. Below is an instance of the database. - Give an expression in relational algebra for each of the following...

employee (person_name, street, city ) works (person_name, company_name, salary) company (company_name, city) manages (person_name, manager_name) Figure 6.22 Relational database for Exercises 6.2,...

A employee database is defined by the following relations: employee = (employee name, city, street) work = (employee_ name, company_name, salary) company = (company_name, city) manages =...

I am stuck , help please . This is my attempt so far ::: Select * company-name From works where salary > (Select avg(salary) from works) Consider the relational database schema described below, where...

Wilderness Guide Services, Inc., performs adjusting entries every month, but closes its accounts only at year-end. The company's year-end adjusted trial balance dated December 31, current year, is as...

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: (a) Develop a 3-year moving average to forecast registrations from year 4...

1 . Select a sample of invoices 2 . Obtain copies of invoices and corresponding sales orders, packing slips, and wire transfers 3 . Compare packing slip to sales order, ensure that amount shipped...

Suppose you are buying your first home for $250,000, and you have $15,000 for your down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at a...

4. Read the advice column in your daily paper or an online magazine. Bearing in mind what youve read in this chapter, consider the nature of the interpersonal conflicts discussed. What are the...

2. The engagement in and resolution of interpersonal conflict are often key factors in romantic comedies (like Life as We Know It and When Harry Met Sally), as well as in buddy-driven action films...

3. Define the roles individuals play in a group