Welcome to Assignment Heroes

# 1. Consider The Following Relations. The Primary Keys Are Underlined. All Attributes Are Of Type String If Not Indicated Otherwise.  Student(S_ID, S_name, S_degree: Integer, AdvisorID, D_ID)  Lectu

1. Consider The Following Relations. The Primary Keys Are Underlined. All Attributes Are Of Type String If Not Indicated Otherwise.  Student(S_ID, S_name, S_degree: Integer, AdvisorID, D_ID)  Lectu. 1. Consider the following relations. The primary keys are underlined. All attributes are of type string if not indicated otherwise.

 Student(s_ID, s_name, s_degree: integer, advisorID, d_ID)

 Lecture(l_ID, l_name,l_degree: integer, p_ID, d_ID)

 Register(s_ID,l_ID,score: integer, Semester)

 Professor(p_ID,p_name, d_ID)

a. Find the names of professors who have taught in every semester.

b. List the names of lectures that the CISE department offers but that are taught by a professor whose department is not CISE.

c. Find the names of students who got the highest score in the lecture ‘Databases’.

d. Find the names of students who have registered every lecture of the CISE department.

e. Find the names of students who got more than 90 in the ‘DB’ lecture and less than 70 in the ‘Algorithm’ lecture.

1. Consider The Following Relations. The Primary Keys Are Underlined. All Attributes Are Of Type String If Not Indicated Otherwise.  Student(S_ID, S_name, S_degree: Integer, AdvisorID, D_ID)  Lectu

## Why US?

##### 100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

##### Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

##### Original Writing

We complete all papers from scratch. You can get a plagiarism report.

##### Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.