logo

Crowdly

103A-CSCSN-ISA-EDABA # WYK # Data Bases - Wykład

Looking for 103A-CSCSN-ISA-EDABA # WYK # Data Bases - Wykład test answers and solutions? Browse our comprehensive collection of verified answers for 103A-CSCSN-ISA-EDABA # WYK # Data Bases - Wykład at leon.pw.edu.pl.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

Given are the relations

Students: ST(S#, SNAME, AGE,

TRACK)

Lecture: L(L#, LNAME, ECTS)

Who attends what: LS(L#, S#)

Find lectures ((L# and LNAME) which are  attended only by students with the age > 22. Use ALL costruct .

View this question

Given are the relations

Students: ST(S#, SNAME, AGE, TRACK)

Lecture: L(L#, LNAME, ECTS): 

Who passed what: EXAMS(L#, S#, NOTE)

Find Lectures (L# and LNAME) with the maximum value of the average note (over the participating students).

View this question

Given are the relations

Students: ST(S#, SNAME, AGE,

TRACK)

Lecture: L(L#, LNAME, ECTS)

Who attends what: LS(L#, S#)

Find students (S# and SNAME) who attend lectures giving a maximal sum of  ECTS (IN TOTAL)

View this question

Want instant access to all verified answers on leon.pw.edu.pl?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!