Fill in Order Details

  • Submit paper details for free using our simple order form

Make Payment Securely

  • Add funds to your account. There are no upfront payments. The writer will only be paid once you have approved your paper

Writing Process

  • The best qualified expert writer is assigned to work on your order
  • Your paper is written to standard and delivered as per your instructions

Download your paper

  • Download the completed paper from your online account or your email
  • You can request a plagiarism and quality report along with your paper

Introduction to Databases Relational Algebra and Calculus SQL Queries Constraints Triggers

Introduction to Databases

Relational Algebra and Calculus

SQL, Queries, Constraints, Triggers

Show the results of the following operations:

(a) ΠD(T2)

(b) T1 ✶T1.C=T2.A T2

(c) T1 ✶ T2

(d) T1 − T2 (Assume that T1 and T2 are union-compatible.)

(e) (T1 ✶ T2) ✶ (T2 ✶ T2)

Express each of the following queries in relational algebra (not in SQL):

(a) (1 pt.) Find the title and year of every pair of movies that have at least onestar in common.

(b) (1.25 pts.) Find the name of each star who never acted in more than one moviein any single year.

(c) (1.25 pts.) Find the name of each star who acted in every movie produced bythe “Paramount” studio between 2000 and 2017.

(a) Print the name and department of each professor who has taught a course notfrom his/her department at least once.

(b) Print the sid and name of each student who has earned a 3.5 or higher grade inat least two different courses.

(c) Print the name and age of the student(s) with the highest GPA in their exactage group (i.e., the name and age of the student(s) with the highest GPA amongall 15 year olds, the name and age of the student(s) with the highest GPA amongall 16 year olds, and so on), for ages less than or equal to 18.

(d) For each department that both (a) has the substring “Engineering” in its name(e.g., “Electrical Engineering”) and (b) has at least 2 students majoring in thedepartment, print the name of the department and the average GPA of thestudents who major in the department.

(e) Some courses are popular among students just because students enrolled in those courses usually get good grades. Print the department name, course number,and course enrollment of each course C such that the following two conditionshold: (1) course C’s enrollment is at least 3% larger than the average enrollment of the courses offered by C’s department, and (2) course C’s average grade isat least 3% larger than the average grade obtained by students in the coursesoffered by C’s department. Assume that the enrollment of a course is the sumof the enrollment of all its sections. You can completely ignore any course thathas no students enrolled in it. 


  • Google Rating
  • Sitejabber
  • Trustpilot
Cindy L
Cindy L
You can't fault the paper quality and speed of delivery. I have been using these guys for the past 3 years and I not even once have they ever failed me. They deliver properly researched papers way ahead of time. Each time I think I have had the best their professional writers surprise me with even better quality work. Elite Academic Research is a true Gem among essay writing companies.
Samuel Y
Samuel Y
I really appreciate the work all your amazing writers do to ensure that my papers are always delivered on time and always of the highest quality. I was at a crossroads last semester and I almost dropped out of school because of the many issues that were bombarding but I am glad a friend referred me to you guys. You came up big for me and continue to do so. I just wish I knew about your services earlier.
Mindi D
Mindi D
Brilliant writers and awesome support team. You can tell by the depth of research and the quality of work delivered that the writers care deeply about delivering that perfect grade.
Stuart L
Stuart L
Thanks for keeping me sane for getting everything out of the way, I’ve been stuck working more than full time and balancing the rest but I’m glad you’ve been ensuring my school work is taken care of. I'll recommend Elite Academic Research to anyone who seeks quality academic help, thank you so much!
Zahraa S
Zahraa S
Absolutely spot on. I have had the best experience with Elite Academic Research and all my work have scored highly. Thank you for your professionalism and using expert writers with vast and outstanding knowledge in their fields. I highly recommend any day and time.


Consider Your Assignments Done

“All my friends and I are getting help from eliteacademicresearch. It’s every college student’s best kept secret!”

Jermaine Byrant

“I was apprehensive at first. But I must say it was a great experience and well worth the price. I got an A!”

Nicole Johnson
Finance & Economics

Our Top Experts


See Why Our Clients Hire Us Again And Again!


Avg Rating


Elite Academic Research Promises You:

Always on Time

If we are a minute late, the work is on us – it’s free!


If the work we produce contains plagiarism we’ll pay out a £5,000 guarantee.


Providing quality work is core to our beliefs, which is why we will strive to give you exactly that, and more!

Written to Standard

All of our assignments go through a stringent quality checking process from start to finish.

Success Guarantee

When you order form the best, some of your greatest problems as a student are solved!






Pay an expert to take your online class and say goodbye to poor grades, missed deadlines, and the struggles
of balancing your education with other work/life responsibilities. Life Is too Short to Spend on Classes
You Have No Interest In. Focus on what is really important in your life. Let our professional handle your class.

    Guaranteed A or B

    100% Confidential

    Experienced Tutors

    24/7 Support

Fill in free quote request

Tell us about your online class and what help you need. Try to give us the maximum information.

Agree on price

Our representative will contact you to discuss the details of your order and the rates for our assistance.

Pay and get help

When everything is agreed, you will receive an email with the invoice. After you pay, we start working on your task.