ckboard.ncat.edu/web assessment/take/launch.jsp?course assessment id -1 edulweba

Question

ckboard.ncat.edu/web assessment/take/launch.jsp?course assessment id -1 edulwebapps Question Completion Status: 8 9 10 11 12 13 14 The latest scores from the Japanese Baseball League are in the table with schema Scores(Team, Day, opponent, Runs) The data in this table is as follows: Team Day opponent Runs Dragons Sunday Swallows 4 Sunday Bay Stars 9 Carp Monday Dragons 10 Hawks Monday Giants 7 Buffaloes uesday Tigers 2 0 Tuesday Giants Lions Bay Stars Friday Tigers 2 Golden Eagles Friday swallows 3 What is the result of executing the following query on this data SELECT S1 Team, 52 Team FROM Scores S1, Scores S2 WHERE si opponent S2 opponent AND si Team S2 Team Identify in the list below a tuple of the result, a Golden Eagle Lions b Ba Stars Bat Star:

Explanation / Answer

Hi, answered the first 4 questions. Hope you understand them.

Question 8:
Given that s1.opponent = s2.opponent and s1.team is not equal to s2.team

Option a:
s1.team = golden eagle, s2.team = lions
s1.opponent = swallows, s2.opponent = giants

Option b:
s1.team = bay stars, s2.team = hawks
s1.opponent = tigers, s2.opponent = hawks

Option c:
s1.team = carp, s2.team = hawks
s1.opponent = dragons, s2.opponent = giants

Option d:
s1.team = buffaloes, s2.team = bay stars
s1.opponent = tigers, s2.opponent = tigers

So, answer is option d as it satisfies the given criteria.

Question 9:
Given that s2.team = dragons and s1.team is not equal to s2.team and s1.runs > s2.runs

so, s2.runs = runs of team dragons = 4

Option a:
s1.runs = runs of bay stars = 2

Option b:
s1.runs = runs of lions = 0

Option c:
s1.runs = runs of buffaloes = 2

Option d:
s1.runs = runs of hawks = 7

as 7 > 4, answer is Option d.

Question 10:

All 4 options can occur in place of "???"

Question 11:

Given s1.runs <= all(s2.runs where s1.day=s2.day)

if day == sunday, then

s1.runs <= all(runs where day = sunday)

so, s1.runs should be least among all s1.runs where day = sunday
so, s1.team should be either carp or bay stars with minimum runs 2.

if s1.team = carp, s1.day = sunday -->> 1
if s1.team = bay stars, s1.day = sunday -->> 2

if day == monday, then

s1.runs <= all(runs where day = monday)

so, s1.runs should be least among all s1.runs where day = monday
so, s1.team should be swallows with minimum runs 0.

if s1.team = swallows, s1.day = monday -->> 3

so, answer should be either 1 or 2 or 3.

From the given options, Option b is the right answer. (bay stars, sunday)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.