Question: Please complete 13-21 and please make it readable. thank you HW-algebra 2 Instructions There are 5 tables: student (sID, sname, age, major, alD) Here alD

Please complete 13-21 and please make it readable. thank you

HW-algebra 2 Instructions There are 5 tables: student (sID, sname, age, major, alD) Here alD is advisor ID, same as faculty ID. course cno, cname, credits, dept) faculty (fID, name, dept) take(sID. cno, year. semester, grade) teach(fID. cno. year. semester) Please answer the following queries using relational algebra. 1-12 were given as last homework. 13. Count the number of students in each major 14. Find the major with less than 100 students. 15. Calculate the total credits taken by student of SID S1111. 16. What the average grade for CS100 in each semester. 17. Who is the oldest student? (show SID) 18. List cno and cname of CS department's 4-credit courses. 19. Find the students who never gotten an F. (Show student ID.) 20 List Professor Jack Smith's advisees: show student ID and name. 21. List the students who have the same names as someone else's. Show student ID

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!

You mo not I: load this Ie to an online homework he! sites. Please see our course syllabus [or honor code rules. Thank you. Your solutions document should include the following items. Points will be...

'1' Mali - Maram Alllulv X C: Conrmed Calendly X Log in - WSSChools X F Content X Eb 53312662 X 9' Continue' P3 lmplew X t Dashboard X 9 Take Test' 54 SQL' Untitled document C n...

Additional info: cells travel down to 984, this workbook is named Orders so please use Orders! in formulas as the formulas are being typed in a separate workbook. Please complete this urgently if...

The data is monthly data from July 1926 until January 2016 for the following series: the excess return on the market (Mkt-RF), the performance of small stocks relative to big stocks (SMB, Small Minus...

Please complete using Microsoft excel Please complete using Microsoft Excel 40) Which one of the following stocks is correctly priced if the riskfree rate of 40) return is 3.2 percent and the market...

RHIM 4322 * Homework 7 * Cost of Capital Please complete and show work in an excel spreadsheet following the Demo Exercise. Do transfer the financial data to the spreadsheet. No need to show the...

main.cpp file #include "SimpleVectorOfInts.h" #include #include #include using namespace std; int main() { // test default constructor SimpleVectorOfInts emptyVector; // NOTE: These asserts will fail...

PLEASE DO # 1 3 - 2 1 & $# 1 3 - 2 2 # 1 3 - 2 1 : Dumgor Appliance Center sells and services several brands of major appliances. Past sales for a particular model of refrigerator have resulted in...

Please, complete the following using the t-table provided: a. The t-score that has 1% of the distribution above it when sample size is 10 isAnswer.: b. The t-score that has 5% of the distribution...

The hydrochemistry data for HH2 are given in Table 2 (a sample from the ocean close by is included to provide the ocean end-member). Please complete the following tasks: (a) Make an assessment of the...

When a new partner who has been the sole owner of a business is admitted to a partnership by having the partnership take over the old business, what usually serves as the basis for preparing the...

A block of mass m = 1 kg another mass m = 2kg, are placed together (see figure) on an inclined plane with angle of inclination 0. Various values of 0 are given in List I. The coefficient of friction...

Thato, a manager for an insurance company, was disappointed in Mlya, one of his direct reports. Miya's job is to sell insurance, but she did not meet her quota for calls to potential new customers in...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

___ 21. I am most fulfilled in my career when I have been able to build something that is entirely the result of my own ideas and efforts.

___ 19. I will feel successful in my career only if I achieve complete autonomy and freedom.

___ 20. I seek jobs in organizations that will give me a sense of security and stability.