Question

2. Part 2 Given a set of tables with their content (tuples/rows), show what would be retrieved if the given SQL queries were issued Consider tables, of a Supplier-Parts DB, shown in Figure 2. Names of tables, columns and identification of primary foreign keys are shown. Questions in this part ask you to show what would be displayed by the following SQL queries should they be executed against the tables having content (tuples/rows) shown in Figure 2. In each answer to a question, do not forget to display column headings in addition to the tuples/rows that would be shown. + and Note for those who are familiar with the SAFE mode assume that the SAFE mode is turned off (although it should not matter). If you feel that there is an error in the statement, e.g. instead of "FROM", it is spelled "FORM", please make and note a reasonable assumption (e.g., I assume that "FORM" should have been "FROM") and proceed. Also, consider both single or double quotes to be correct for string literals· +' 1. SELECT ppo, color- FROM WHERE color Red p,pop, color- p JOIN USING (pno) color Red 2. SELECT FROM WHERE 3. SELECT popgo, color, suo, qty ↓ FROM WHERE color 'Red': ↓ 4. SELECT FROM WHERE s NATURAL JOIN sp. JOIN p ↓ color 'Red': ↓ 5. SELECT ssne, sp.sno, sp.png, qty, p.pno FROM WHERE city = 'Paris, AND color = "Green, AND &sno= spoSng AND spopAR = ppuN. ↓ 6. SELECT FROM WHERE S, SD. P city Paris' AND color- Green'; * 7. SELECT FROM WHERE S, Sp. p city = 'Paris, AND color = 'Green, AND ssna= sposo; ↓

Answer 1

If you have any doubts, please give me comment...

1)

pno	color
P1	Red
P4	Red

2)

p.pno	color
P1	Red
P1	Red
P1	Red
P4	Red
P4	Red

3)

p.pno	color	Sno	Qty
P1	Red	S1	300
P1	Red	S2	200
P1	Red	S3	100
P4	Red	S1	200
P4	Red	S5	200