IP-Header
December 25, 2023Pointers
December 25, 2023Question 16230 – UGC NET Dec-2020 and June-2021 Paper-2
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 X COURSE
Match List I with List II in context to the above problem statement.
Choose the correct answer from the options given below:
Correct Answer: D
Question 10 Explanation:
Lets say STUDENT Relation has ‘p’ number of attributes and COURSE Relation has ‘q’ number of attributes.And lets say STUDENT Relation has ‘m’ records and COURSE Relation has ‘n’ tuples. And let’s say ‘R’ is the result of Cross Product of STUDENT X COURSE.
Then Cardinality of R is m*n
And Degree of R is p+q. Foreign Key of relation STUDENT is Courseno and there is no foregin key in COURSE relation.
Then Cardinality of R is m*n
And Degree of R is p+q. Foreign Key of relation STUDENT is Courseno and there is no foregin key in COURSE relation.
A -I , B -III , C -IV , D – II
A -I , B -III , C -IV , D – II
A -I , B -III, C -II , D – IV
A -III , B -I , C -IV , D – II
Subscribe
Login
0 Comments