Question: Using relational algebra specify the following queries on the database schema shown in the above figure using relational operators . Also, show the result of

Using relational algebra specify the following queries on the database schema

Using relational algebra specify the following queries on the database schema shown in the above figure using relational operators. Also, show the result of each query if applied to the database of the figure above.

1. For each employee, retrieve employees name, and the total hours working in projects

2. List the last names of female employees who have no dependents.

EMPLOYEE | FNAME | MINIT | LNAME | SSN SEX SALARY SUPERSSN 333445555 1955-12-08 999887777 1968-07-19 Wallace 9876543211941-06-20 666884444 1962-09-15 453453453 1972-07-31 987987967 1969-03-29 888665555 1937-11-10 638 Voss, Houston, TX 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX 980 Dalas, Houston, TX 450 Stone, Houston, TX Jabbar E Borg DEPT LOCATIONS DEPARTMENT DNAME MGRSTARTDATE 1988-05-22 1995-01-01 1981-06-19 987654321 WORKS-ON ESSN | PNQHOURS 23456789 PNUMBER PLOCATION DNUM 3 5 DEPENDENT DEPENDENT NAME SEX RELATIONSHIP M 1983-10-25 F 1958-05-03 1942-02-28 Abner 988-12-30 1967-05-05

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!

Find an answer to this question (image 2 )using multisequenceoperation vs inline sequence in relational algebra Specify the following queries on the database schema shown in above Figure using the...

SQL Specify the following queries on the database schema shown in the following figure, using the operations of the relational algebra. EMPLOYEE PRONE FNAME MAHTUNE MINIT LNAME SSN BDATE ADDRESS SEX...

Specify the following queries on the database schema shown in the following figure, using the operations of the relational algebra. The homework assignment must be typed and submitted in a PDF format...

1. Specify the following queries on the database schema shown in Figure 3.6 using both the tuple relational calculus and the domain relational calculus. You don't need to show the result of each...

Due date: November 6, 2018 (Tuesday) Problems: 1. Specify the following queries on the database schema shown in Figure 3.6 using both the tuple relational calculus and the domain relational calculus....

1. Specify the following queries on the database schema shown in Figure 3.6 using both the tuple relational calculus and the domain relational calculus. You don't need to show the result of each...

Specify relational expressions for the following descriptions on the database schema shown in Figure 3.5 using the relational operators discussed in this chapter. Also show the result of each query...

Comment on this graph in the context of the relationship between interest rate and value of the two different type of the bonds. (8 points) Prices (5) 2,000 1,800- 1,600 1,400 1,200 1,100 1,000 800...

Farmers State Bank is considering a $500,000 loan to Willard Manufacturing. Three items appearing on Willard's balance sheet are: a. Cash on hand and in the bank, $20,000. b. Accounts receivable of...

ach business day, on average, a company writes checks totaling $ 4 1 , 6 2 7 to pay its suppliers. The usual clearing time for these checks is 3 . 2 days. Meanwhile, the company is receiving payments...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

(Appendices) Megan, age 28, is insured under an individual major medical policy. The plan has a calendar-year deductible of $1,500, a 25 percent coinsurance provision, and an annual out-of-pocket...

(Appendices) Some states have second-injury funds in their workers compensation programs. However, in recent years, a number of states have terminated such funds.LO6 a. How does a second-injury fund...

(Appendices) PURCHASES, SALES, AND COST OF GOODS SOLD. The following data were available for Jeans Inc., a seller of denim clothing, at January 1 of a recent year: Jeans Inc. records purchases and...