Given the following STUDENT‐COURSE scheme : STUDENT (Rollno, Name, Courseno) COURSE (Courseno, Coursename, Capacity), where Rollno is the primary key of relation STUDENT and Courseno is the primary key of relation COURSE. Attribute Coursename of COURSE takes unique values only. The number of records in COURSE and STUDENT tables are 3 and 5 respectively. Following relational algebra query is executed : R = STUDENT × COURSE
Match List I with List II in context to the above problem statement.
| List I | List II | ||
| A. | Degree of table R | I. | 15 |
| B. | Cardinality of table R | II. | NIL |
| C. | Foreign key of relation STUDENT | III. | 6 |
| D. | Foreign key of relation COURSE | IV. | Courseno |
Choose the correct answer from the options given below :
1
A ‐ III , B ‐ I , C ‐ IV , D ‐ II
2
A ‐ II , B ‐ III , C ‐ IV , D ‐ I
3
A ‐ I , B ‐ III , C ‐ IV , D ‐ II
4
A ‐ I , B ‐ III, C ‐ II , D ‐ IV