Question: he two tables below to answer questions 6-10. instructor teaches D COurse id sec idsemester year 2009 2009 name 10101 ICS-101 Fall 10101 Srinivasan Comp.

he two tables below to answer questions 6-10. instructor teaches D COurse id sec idsemester year 2009 2009 name 10101 ICS-101 Fall 10101 Srinivasan Comp. Sci. 65000 Finance 90000 40000 12121 Wu 15151 MozartMusic 10101 CS-315 1 Spring 2010 10101 CS-347I 12121 FIN-201 1 Spring 2010 22222 Einstein Physics 95000 60000 32343 El Said History6oopn 15151 MU-199 1 Spring 2010 222221 PHY-1011TFall 2009 6. Find the names of all instructors in the Art department who have taught some course and the course id Write the query using SQL. 7. Find the names of all instructors with salary between $90,000 and $100,000 (that is, 2 $90,000 and S $100,000) ind the average salary of instructors in the Computer Science department 9. Find the number of tuples in the course relation. 10. Find the salaries of all instructors that are less than the largest salary

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!

Please answer 7-10 tables below to answer questions 6-10. instructor teaches ID name course i sec idsemester wwar 2009 salary 10101 Srinivasan Comp. Sci. 65000 Finance 90000 40000 2121 Wu 15151...

tables below to answer questions 6-10. instructor teaches ID name manme course id sec idsemester war 2009 salary 10101 Srinivasan Comp. Sci. 65000 Finance 90000 40000 Fall 2121 Wu 15151 Mozart Music...

RW tabies below to answer questions 6-10. instructor teaches Srinivasan Comp. Sci.65000 Finance 90000 40000 22222 Einstein Physics 95000 Said History 60000 0101 CS-101 10101|CS-315 | 1 Spring 2010...

(a) Assume all course ids are in the format of 4 capitals followed by 4 digits, where the first digit indicates the course is designed for the i-th year students. For example, AAAA1100 is a course...

Database questions. Needs to be in SQL Oracle. 1. Find the names and ids of the students who have taken exactly one course in the Spring 2010 semester. 2. Find the names and ids of the students who...

student takes ID course_id sec_id semester year grade ID name dept_name tot_cred course advisor section course id sec_id semester year building room_no time_slot_id course id title dept_name credits...

Database Questions 1. Find the ids of instructors who are also students using a set operation . Assume that a person is identified by her or his id. So, if the same id appears in both instructor and...

Solve the following questions using Oracle . You are not allowed to use the syntax of any DBMS other than Oracle. 1. Find the names and ids of the students who have taken all the courses that are...

Solve the following question using oracle:sql 1 a. Write a query that uses a derived relation to find the student(s) who have taken at least two courses in the Spring 2010 semester. Schema of the...

This is database system concept and using oracle. Sorry, it is too long. 1.Find the names and ids of the students who have taken exactly one course in the Spring 2010 semester. 2.Find the names and...

Dayton Dairies is a vertically integrated company that has dairy farms, processing plants, and retail ice cream stores. Daytons strategy is to maximize shareholder value by providing top-of the- line...

You are a senior manager in a U.S automobile company considering whether to invest in production facilities in China, Russia, or Germany. These facilities will serve local market demand Evaluate the...

Generally, how tong does a fraudalert last? Selectone A . 3 0 days. B . 6 0 - days. C . 9 0 days. D . 1 2 0 days.

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Working with other project stakeholders for support.

Knowledge of project management (PMI) teachings

1. What is the relationship between information technology, project management, and Arups business model and business strategy?