236 views
0 votes
0 votes

What is the output of below question please draw table according to question.

1 Answer

0 votes
0 votes

 $\prod _{name} (\sigma _{grade=A}(Student * Grade))$

Name
A
B
C

  $(Student * Grade))$

Student * Grade
Name Roll No G.Roll no Grade
A 1 2 A
A 1 3 B
A 1 4 A
B 2 2 A
B 2 3 B
B 2 4 A
C 3 2 A
C 3 3 B
C 3 4 A

 $(\sigma _{grade=A}(Student * Grade))$

Name Student.Roll No Grade.Roll no Grade
A 1 2 A
A 1 4 A
B 2 2 A
B 2 4 A
C 3 2 A
C 3 4

A

Related questions

0 votes
0 votes
1 answer
1
Ashutosh_17 asked Mar 30, 2023
789 views
Let R be a relation of degree 5 then the total number of projections possible on R is ___?
0 votes
0 votes
0 answers
4
aashijn asked Apr 28, 2022
1,331 views
employee (person-name, street, city)works (person-name, company-name, salary)company (company-name, city)manages (person-name, manager-name) a. Find the names of all empl...