Scribd
Upload
5 views5 pages

Relational Algebra Example

The document presents a series of questions related to a relational model concerning professors, focusing on their nationality, salary, and courses taught. It includes queries to filter data based on specific criteria such as nationality, salary thresholds, and course codes. The questions aim to extract various insights from the relational database, including sums and averages of salaries.

Uploaded by

asmaa zakria
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views5 pages

Relational Algebra Example

The document presents a series of questions related to a relational model concerning professors, focusing on their nationality, salary, and courses taught. It includes queries to filter data based on specific criteria such as nationality, salary thresholds, and course codes. The questions aim to extract various insights from the relational database, including sums and averages of salaries.

Uploaded by

asmaa zakria
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Relational Algebra Example

Use the following relational model to answer


the coming questions
Questions
• Question (1) display a list of all “Egyptian” professor data.
• Question (2) display a list of all “Egyptian” professor data who get
salary more than 10000 pounds.
• Question (3) display a list of professor names and nationalities who
get salary more than or equal to 20000 pounds.
• Question (4) display a list of professor name and code of courses he
taught
• Question (5) display a list of professor name and code of courses he
taught in summer semester.
Questions
• Question (6) display a list of “Egyptian” professor names and name of
courses taught in summer semester.
• Question (7) display a list of “Egyptian” professor names and salary
who taught courses with 3 credit hours in the summer semester.
• Question (8) display a list of professors who taught the course IS2510
but never taught IS3610.
• Question (9) display a list of professors who taught the course IS2510
and also taught IS3610.
• Question (10) display a list of professors who taught all the course
that professor walid taught.
Questions
• Question (11) display the sum of professor salaries
• Question (12) for each nationality, display the count of professors and
average of professors salaries.

You might also like