The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 398 Weeks Ago, 2 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
EMPLOYEE(NAME, SSN, BDATE, ADDRESS, SALARY)
DEPARTMENT(DNAME, DNUMBER, MGRSSN)
(MGRSSN references SSN in EMPLOYEE table)
WORKSIN(ESSN, DNUMBER, HOURS)
(DNUMBER references DNUMBER in DEPARTMENT table)
(ESSN reference SSN in EMPLOYEE table)
Write the relational algebra expressions for the following queries:
1) List the names of employees whose salary is greater than 30000
2) List the names of employees who work in A????1shoesA????1 department
3) List the names of employees who work in all departments
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll