Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please can someone solve this A company has several employees. Each employee is trained on some machines, and many employees can be trained on the

image text in transcribed

image text in transcribed

please can someone solve this

A company has several employees. Each employee is trained on some machines, and many employees can be trained on the same machine. For each employee, the company has an ID, name, address, zone, salary, tax level, machineid, trained since date, machine maximum capacity, machine type and machine energy rating on file. More information about various fields is below. Table 1 : Employee Training Eid- employee ID, Ename - employee name, Eaddress- employee address, Ezone- zone depending on eaddress, Esalary- employee salary, Etaxlevel- tax bracket depending on esalary and ezone, Mid - Machine ID that the employee is trained on, Trained Since-Date since given employee was trained on given machine, Mcapacity - Maximum Capacity of that machine, Mtype- type of machine, Menergyrating- energy rating of machine, depending on mcapacity and mtype Note: As per convention, the underline below a field name signifies a key. eid ename eaddress lezone esalaryetaxlevel mid trainedsince mcapacity mtype 3 Morty Smith 23 Harry Place 4200 3900 A 1 2000-01-01 120 Type A 5 Russell Bueno 803 Arroyo Lane 4523 3500Z 1 2011-04-03 120 Type A 5 Russell Bueno 803 Arroyo Lane 4523 3500 Z 2 2012-05-04 98 Types 3 Morty Smith 23 Harry Place 4200 3900 A 3 1999-05-03 230 Types 3 Morty Smith 23 Harry Place 4200 3900 A 4 2012-12-12 111 TypeP menergyrating A A 4 4 Frank Whitney 174 Ramsey Circle 2 Rick Astley 23 Harry Place 2300 4200 2900F 4100B 2013-07-15 2010-04-01 111 TypeP 30 TypeC C B 5 2300 5 B 4 Frank Whitney 174 Ramsey Circle 2 Rick Astley 23 Harry Place 2900F 4100B 2019-08-01 2020-12-12 30 Type 110 TypeP 4200 7 B 4 Frank Whitney 174 Ramsey Circle 2300 2900F 7 2021-02-01 110 TypeP B 1 Glenda McCall 56573 Hintze Lane 4001 4000A 8 2013-07-15 99 Type A D 1 Glenda McCall 56573 Hintze Lane 4001 4000 A 9 2010-04-01 100 Types D Now, here is additional information. You will need both Table 1 and Table 2 and the related information here to solve Q5 Table 2: Project Pid- project ID, Pname- project name, Pcapacity- required capacity to execute project pid pname pcapacity 2 Clark 100 3 Sanchez 112 98 4 Bassham 7 McCall 229 9 Alt 23 The company accepts projects that are executed on machines. Each project has a required capacity. For a machine to execute a project, it must have maximum capacity >= project capacity. Machines of any type can execute any project provided it has the capacity. Note: As per convention, the underline below a field name signifies a key. Question: Express this query in relational algebra. Find eid of employees who can execute Project Sanchez

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions