Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write only relational algebra for the 6 questions following the given tables. [ Answer the Questions as Per Notes: Remind that you will be down

Write only relational algebra for the 6 questions following the given tables.

[ Answer the Questions as Per Notes: Remind that you will be down voted if you answer wrong or copy/paste any answer from any chegg posts. Answer 1-5 Questions.]

image text in transcribed

image text in transcribed

SLD 51 7 |310 s Name Rating 5222 Dustin 431 Lubber 8 258 / Rusty 4500 55.5 35.0 R1 SID SID 10 22 101 Day 10/10/96 103 / 11/12/96 58 52 SID IsName / Rating 9 Lubber Age 350 28 Yuppy Boats Table/ Relation 55.5 1731 5 350 44 Guppy 58 Rusty 10 350 BID BName Color 101 Interlake Blue 102 Interlake Red 103 Clipper Green Marine Red 104 1 who have reserved a RED Find names of Sailors boat ? (2 names Find of sailors who have reserved a RED or a GREEN boat? 21 Can also define tempboats using UNION (How?) - 2:2 What happens of is replaced by in this query? Find of sailors who have reserved a RED and a GREEN boat? A names 3 4 Find the names of sailors who have reserved all boats? of sailors who have reserved all "Interlake" boats? Find the names 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Administration The Complete Guide To Dba Practices And Procedures

Authors: Craig S. Mullins

2nd Edition

0321822943, 978-0321822949

More Books

Students also viewed these Databases questions