Answer to Question #145163 in Databases | SQL | Oracle | MS Access for Ankita Sonawane

Question

Consider the following relation.
Instructor (ID , name, dept – name, salary) Department (dept – name , building ,budget) Classroom (building , roomno , capacity ) Teaches (ID , course – id , sec – id , semesters) Course (course – id , title , dept – name , credit)
Student (ID , name dept – name ,fot – ored ) Takes (ID , course – id , sec – id, semester , year, grade)
Write down queries expressed in SQL.

1)Find the name of all instructors who got the highest salary in their department.

2)Find the names of all the students whose total credits are greater than 100.

3)Find the course id and grades of all courses taken by any student.

4) Find all departments that have at least one instructor, and list – the name of the departments along with the number of instructor

Answer 1

Dear Ankita Sonawane, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order