Relational algebra in DBMS

Presentation

•

Architecture, Education

•

University

•

Hard

Kavi Moki

Used 6+ times

FREE Resource

3 Slides • 0 Questions

Relational algebra

Q1.Find the names of sailors who have reserved boat 103
πsname((σbid=103Reserves) |X|Sailors)

Q2. Find the names of sailors who have reserved a red boat?
πsname((σcolor='red'Boats) |X|Reserves |X|Sailors)

Q3. Find the colors of boats reserved by Lubber?

πcolor((σsname='Lubber'Sailors) |X| Reserves |X| Boats)

Relational Algebra

Q4. Find the names of sailors who have reserved at least one boat?
πsname(Sailors |X| Reserves)

Q5. Find the names of sailors who have reserved a Red boat or a Green boat?
ρ(T empboats,(σcolor='red'Boats) ∪ (σcolor='green'Boats))

πsname(T empboats |X|Reserves |X|Sailors)

Q6. Find the names of sailors who have reserved a Red boat and a Green boat?

ρ(T empred, πsid((σcolor='red'Boats) |X|Reserves))
ρ(T empgreen, πsid((σcolor='green'Boats) |X| Reserves))
πsname((T empred ∩ T empgreen) |X| Sailors)

Relational Algebra

Q7. Find the names of sailors who have reserved at least two boats?

Q8. Find the sids of sailors with age over 20 who have not reserved a red boat?

Q9. Find the names of sailors who have reserved all the boats?

Q10. Find the names of sailors who have reserved all boats called Interlake?

Relational algebra

πcolor((σsname='Lubber'Sailors) |X| Reserves |X| Boats)

Show answer

Auto Play

Slide 1 / 3

SLIDE

Similar Resources on Wayground

7 questions

SP8: Coaching

Presentation

•

KG - University

5 questions

Teach a fish to...

Presentation

•

Professional Development

7 questions

Born A Crime Apartheid

Presentation

•

12th Grade

2 questions

Kids Snack Brainstorm

Presentation

•

University

3 questions

An Oral Exam

Presentation

•

5 questions

Review of Reading Skills

Presentation

•

University

5 questions

Dictation test + Final exam: most common mistakes

Presentation

•

11th - 12th Grade

4 questions

Tourism: pros and cons glossary and text- content by Pearson

Presentation

•

Professional Development

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade