1. consider the following relations. the primary keys are underlined.

Order now Get a quote

consider the following relations. the primary keys are underlined.

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)

 Department(d_ID, d_name, address)

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.

Calculate the price of your order

Select your paper details and see how much our professional writing services will cost.

Type of paper

Academic level

Pages 275 words

We`ll send you the first draft for approval by at

Price: $36

We care about originality
Our custom human-written papers from top essay writers are always free from plagiarism.
We protect your privacy
Your data and payment info stay secured every time you get our help from an essay writer.
You control your money
Your money is safe with us. If your plans change, you can get it sent back to your card.

1
You give us the details

Complete a brief order form to tell us what kind of paper you need.
2
We find you a top writer

One of the best experts in your discipline starts working on your essay.
3
You get the paper done

Enjoy writing that meets your demands and high academic standards!

Order now

We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.

Swift delivery

Our writing service can deliver your short and urgent papers in just 4 hours!
Professional touch

We find you a pro writer who knows all the ins and outs of your subject.
Easy order placing/tracking

Create a new order and check on its progress at any time in your dashboard.
Help with any kind of paper

Need a PhD thesis, research project, or a two-page essay? For you, we can do it all.
Experts in 80+ subjects

Our pro writers can help you with anything, from nursing to business studies.
Calculations and code

We also do math, write code, and solve problems in 30+ STEM disciplines.

Get instant answers to the questions that students ask most often.

See full FAQ

Order now