349 views
1 votes
1 votes
STUDENT(SID(PK) , SNAME) with 100 tuples.

ENROLL(SID CID (composite key) with 200 tuples.

how many maximum tuples in

STUDENT JOIN ENROLL ??

thanku

2 Answers

0 votes
0 votes

In STUDENT table as SID is the primary key, there are 100 different SID s stored.

example:

SID SNAME
01 Aaru
02 Shiva

.......

100

Varun

In ENROLL table as SID and CID together make a composite key, there is a possibility of same SID with 200 different CID

SID CID
02 CID-01
02 CID-02

.......

02

CID- 200

In such case, STUDENT (JOIN) ENROLL can give a maximum of 200 tuples.

SID SNAME CID
02 Shiva CID-01
02 Shiva CID-02

.........

02

Shiva

CID-200

Answer: 200

0 votes
0 votes

given STUDENT(SID , SNAME)  with SID is PK 

and ENROLL(SID, CID) with sidcid is CK

so maximum 200 tuple can map

Related questions

0 votes
0 votes
0 answers
2
0 votes
0 votes
0 answers
3
Sajal Mallick asked Nov 20, 2023
168 views
According to me answer is 2.Is it right? Suggestion is needed how to approach this if it is given in more complexity.
0 votes
0 votes
1 answer
4
nihal_chourasiya asked Oct 14, 2023
213 views