1.

                         STUDENT  Reg No  Name  Score101Preethi70102Anupama68103Ruksana94104Nancy87105Anu77                     GRADEReg No  Name  Score10170B+10268B10394A+10487A10577B+Consider the relations STUDENT and GRADE given above and predict the output of the following relational operations in table format. 1. σ (STUDENT) Score > 80 2. π (STUDENT) RegNo, Score 3. σ (GRADE) RegNo <103 4. σ (GRADE) Grade = ‘B+’5. π RegNo, Name ( σScores >70(STUDENT))

Answer»

1.

  Reg NoScores Grade
103Ruksana94
104Nancy87

2.

   Reg No     Score
10170
10268
10394
10487
10577

3. 

  Reg NoScores  Grede
10487A
10577B+

4. 

Reg NoScores  Grede
10170B+
10577B+

5.

   Reg No   Name
103Ruksana
104Nancy
105Anu


Discussion

No Comment Found